Ticket #7217 (closed defect: fixed)

Opened 3 years ago

Last modified 2 years ago

WikiSearchMacro fails to work with MySQL

Reported by: karri.kahelin@alfame.com Assigned to: 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

wikisearchmacro-mysql.patch (417 bytes) - added by karri.kahelin@alfame.com on 06/08/10 10:13:29.
Patch to make macro work with MySQL

Change History

06/08/10 10:13:29 changed by karri.kahelin@alfame.com

  • attachment wikisearchmacro-mysql.patch added.

Patch to make macro work with MySQL

06/08/10 20:15:14 changed by rjollos

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

06/09/10 09:16:19 changed by karri.kahelin@alfame.com

It is.

06/10/10 03:12:15 changed by rjollos

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

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

06/10/10 03:13:44 changed 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.

12/07/10 02:42:03 changed by rjollos

[9626] is related to this change.


Add/Change #7217 (WikiSearchMacro fails to work with MySQL)




Change Properties
Action