Modify

Opened 6 years ago

Closed 5 years ago

Last modified 5 years ago

#8452 closed defect (fixed)

table trac.WIKI does not exist

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

Description (last modified by Ryan J Ollos)

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 6 years ago by Ryan J Ollos

Description: modified (diff)

comment:2 Changed 6 years ago by anonymous

+1 anyone solved that?

comment:3 in reply to:  2 ; Changed 5 years ago by Jean-Yves Jourdain

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 5 years ago by Ryan J Ollos

Owner: changed from Trap to Ryan J Ollos
Status: newassigned

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 5 years ago by Ryan J Ollos

Resolution: fixed
Status: assignedclosed

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

comment:6 Changed 5 years ago by Ryan J Ollos

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 5 years ago by Jean-Yves Jourdain

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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Ryan J Ollos.
The resolution will be deleted.

Add Comment


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

 
Note: See TracTickets for help on using tickets.