Modify

Opened 8 years ago

Closed 8 years ago

Last modified 7 years ago

#7217 closed defect (fixed)

WikiSearchMacro fails to work with MySQL

Reported by: karri.kahelin@… Owned by: Ryan J Ollos
Priority: normal Component: WikiSearchMacro
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

Using WikiSearchMacro with MySQL produces the following error: 1248Every derived table must have its own alias

This can be fixed with a small change to a SQL query.

Attachments (1)

wikisearchmacro-mysql.patch (417 bytes) - added by karri.kahelin@… 8 years ago.
Patch to make macro work with MySQL

Download all attachments as: .zip

Change History (6)

Changed 8 years ago by karri.kahelin@…

Attachment: wikisearchmacro-mysql.patch added

Patch to make macro work with MySQL

comment:1 Changed 8 years ago by Ryan J Ollos

Do you know whether the patch is also compatible with SQLite?

comment:2 Changed 8 years ago by karri.kahelin@…

It is.

comment:3 Changed 8 years ago by Ryan J Ollos

Resolution: fixed
Status: newclosed

(In [8110]) Change to SQL query that makes macro compatible with MySQL. Patch by karri.kahelin@…. Fixes #7217.

comment:4 Changed 8 years ago by Ryan J Ollos

Thanks for the patch. Feel free to add your real name or Trac user name to the list of contributors on the wiki page for WikiSearchMacro.

comment:5 Changed 7 years ago by Ryan J Ollos

[9626] is related to this change.

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.