Changes between Initial Version and Version 8 of Ticket #5568
- Timestamp:
- Dec 11, 2010, 9:51:50 PM (13 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #5568
- Property Owner changed from Prentice Wongvibulsin to Ryan J Ollos
-
Property
Status
changed from
new
toassigned
-
Property
Summary
changed from
Mysql requests issues with TracTicketStatsPlugin
to[Patch] SQL query failures with MySQL
-
Ticket #5568 – Description
initial v8 1 1 Hello, 2 2 3 I ran into SQL requests issues while running T icketStatsPlugin with a mysql backend :3 I ran into SQL requests issues while running TracTicketStatsPlugin with a mysql backend : 4 4 5 1)(1054, "Unknown column 'created' in 'where clause'") 5 1. `(1054, "Unknown column 'created' in 'where clause'")` 6 6 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 : 7 7 … … 13 13 }}} 14 14 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 : 16 16 17 17 {{{