Ticket #8452 (closed defect: fixed)

Opened 2 years ago

Last modified 10 months ago

table trac.WIKI does not exist

Reported by: shabbychef Assigned to: 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

Change History

01/29/11 03:50:38 changed by rjollos

  • description changed.

(follow-up: ↓ 3 ) 12/20/11 16:00:19 changed by anonymous

+1 anyone solved that?

(in reply to: ↑ 2 ; follow-up: ↓ 4 ) 08/01/12 16:45:13 changed 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 '

(in reply to: ↑ 3 ) 08/01/12 20:32:35 changed by rjollos

  • status changed from new to assigned.
  • owner changed from trapanator to rjollos.

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.

08/01/12 20:32:51 changed by rjollos

  • status changed from assigned to closed.
  • resolution set to fixed.

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

(follow-up: ↓ 7 ) 08/01/12 20:35:33 changed by rjollos

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

(in reply to: ↑ 6 ) 08/02/12 09:29:42 changed 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/Change #8452 (table trac.WIKI does not exist)




Change Properties
Action