Modify

Opened 3 years ago

Closed 21 months ago

Last modified 21 months 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 3 years ago by rjollos

  • Description modified (diff)

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

+1 anyone solved that?

comment:3 in reply to: ↑ 2 ; follow-up: Changed 21 months 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 21 months 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 21 months 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 21 months 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 21 months 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 .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from rjollos. Next status will be '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.