Changes between Initial Version and Version 9 of Ticket #3874


Ignore:
Timestamp:
Mar 2, 2012, 2:22:29 AM (3 years ago)
Author:
rjollos
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #3874

    • Property Cc rjollos added
    • Property Keywords SQL specific syntax added
    • Property Owner changed from Rottenchester to rjollos
  • Ticket #3874 – Description

    initial v9  
    11By using trac 0.11.1 and WikiStatsPlugin I'm getting the error when using the Stats macro:
    2   no such function: IF
     2{{{
     3no such function: IF
     4}}}
    35
    46I think it's from the SQL query in stats.py line 56-67:
    5    SUM(IF(version = 1, 1, 0)) as pages_created,
    6    SUM(IF(version = 1, 0, 1)) as pages_edited,
     7{{{
     8SUM(IF(version = 1, 1, 0)) as pages_created,
     9SUM(IF(version = 1, 0, 1)) as pages_edited,
     10}}}
    711
    812I tried to simple remove this two lines, then I get the error:
    9   no such column: pages_created
    10 
    11 
     13{{{
     14no such column: pages_created
     15}}}