Changes between Initial Version and Version 8 of Ticket #5568


Ignore:
Timestamp:
Dec 11, 2010 10:51:50 PM (4 years ago)
Author:
rjollos
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #5568

    • Property Owner changed from echo0101 to rjollos
    • Property Status changed from new to assigned
    • Property Summary changed from Mysql requests issues with TracTicketStatsPlugin to [Patch] SQL query failures with MySQL
  • Ticket #5568 – Description

    initial v8  
    11Hello, 
    22 
    3 I ran into SQL requests issues while running TicketStatsPlugin with a mysql backend : 
     3I ran into SQL requests issues while running TracTicketStatsPlugin with a mysql backend : 
    44 
    5 1)(1054, "Unknown column 'created' in 'where clause'") 
     5 1. `(1054, "Unknown column 'created' in 'where clause'")` 
    66 This is due to Mysql poor Alias handling, i propose to use the column name (t.time) instead of alias name(created) as shown in following patch : 
    77 
     
    1313}}} 
    1414 
    15 2) The next issue is related with the use of 'enum p' . Here comes the proposed patch : 
     15 2. The next issue is related with the use of 'enum p' . Here comes the proposed patch : 
    1616 
    1717{{{