Changes between Initial Version and Version 8 of Ticket #5568


Ignore:
Timestamp:
Dec 11, 2010, 9:51:50 PM (13 years ago)
Author:
Ryan J Ollos
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #5568

    • Property Owner changed from Prentice Wongvibulsin to Ryan J Ollos
    • 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{{{