Modify

Opened 5 years ago

Closed 5 years ago

Last modified 4 years ago

#7217 closed defect (fixed)

WikiSearchMacro fails to work with MySQL

Reported by: karri.kahelin@… Owned by: rjollos
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@… 5 years ago.
Patch to make macro work with MySQL

Download all attachments as: .zip

Change History (6)

Changed 5 years ago by karri.kahelin@…

Patch to make macro work with MySQL

comment:1 Changed 5 years ago by rjollos

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

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

It is.

comment:3 Changed 5 years ago by rjollos

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

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

comment:4 Changed 5 years ago by rjollos

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 4 years ago by rjollos

[9626] is related to this change.

Add Comment

Modify Ticket

Action
as closed The owner will remain rjollos.
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.