Changes between Initial Version and Version 9 of Ticket #3874


Ignore:
Timestamp:
Mar 2, 2012 2:22:29 AM (2 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}}}