Changes between Initial Version and Version 1 of Ticket #9976, comment 1


Ignore:
Timestamp:
Jun 29, 2015, 8:13:26 PM (9 years ago)
Author:
Ryan J Ollos
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #9976, comment 1

    initial v1  
    11The solution is to modify a SQL statement in the macros.py file to be valid with Postgresql.
    22Below is the new SQL statement (macros.py (line 246)):
     3
    34current:
    4 {{{
    5 #!sql
     5{{{#!sql
    66    sql = "SELECT name, text, max(version) FROM wiki WHERE name LIKE '%s%%' GROUP BY name ORDER BY name" % curpage
    77}}}
    88
    99new:
    10 {{{
    11 #!sql
     10{{{#!sql
    1211    sql = "SELECT name, text, version FROM wiki WHERE name LIKE '%s%%' AND version = (select max(version) FROM wiki WHERE name LIKE '%s%%')" % (curpage, curpage)
    1312}}}