Modify

Opened 4 years ago

Closed 2 years ago

Last modified 2 years ago

#8452 closed defect (fixed)

table trac.WIKI does not exist

Reported by: shabbychef Owned by: rjollos
Priority: normal Component: BackLinksMacro
Severity: major Keywords:
Cc: Trac Release: 0.12

Description (last modified by rjollos)

this macro seems to fail, with the error:

Error: Macro BackLinks(None) failed

1146Table 'trac.WIKI' doesn't exist

Attachments (0)

Change History (7)

comment:1 Changed 4 years ago by rjollos

  • Description modified (diff)

comment:2 follow-up: Changed 3 years ago by anonymous

+1 anyone solved that?

comment:3 in reply to: ↑ 2 ; follow-up: Changed 2 years ago by terreorange

Replying to anonymous:

+1 anyone solved that?

I got the problem when I decided to use MySQL. In BackLinks.py, replace the string "WIKI" by "wiki" and that will work :

        sql = 'SELECT w1.name FROM wiki w1, ' + \
                  '(SELECT name, MAX(version) AS VERSION FROM wiki GROUP BY NAME) w2 ' + \
                  'WHERE w1.version = w2.version AND w1.name = w2.name '

comment:4 in reply to: ↑ 3 Changed 2 years ago by rjollos

  • Owner changed from trapanator to rjollos
  • Status changed from new to assigned

Replying to terreorange:

I got the problem when I decided to use MySQL. In BackLinks.py, replace the string "WIKI" by "wiki" and that will work:

Thanks, I'll get the change applied to the trunk now. More work on this macro is in store for the near future.

comment:5 Changed 2 years ago by rjollos

  • Resolution set to fixed
  • Status changed from assigned to closed

(In [11875]) Fixes #8452: Changed incorrectly named table: WIKI -> wiki. Thank you terreorange.

comment:6 follow-up: Changed 2 years ago by rjollos

I assumed that this is working well on 0.12 then, and added the 0.12 tag to the project wiki page.

comment:7 in reply to: ↑ 6 Changed 2 years ago by terreorange

Replying to rjollos:

I assumed that this is working well on 0.12 then, and added the 0.12 tag to the project wiki page.

Yes, I confirm, I use Trac 0.12.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.