Opened 13 years ago
Last modified 11 years ago
#8391 closed defect
SQL error when using PostgreSQL viewing /hours where no tickets exist — at Version 4
Reported by: | Adam Piper | Owned by: | Ryan J Ollos |
---|---|---|---|
Priority: | high | Component: | TracHoursPlugin |
Severity: | normal | Keywords: | postgresql postgres sql syntax error |
Cc: | Trac Release: | 0.11 |
Description (last modified by )
While this works fine on SQLite, the WHERE ticket IN ()
is invalid for PostgreSQL. As such I have tweaked the code to merely return an empty list in this circumstance. See attached patch.
Change History (5)
Changed 13 years ago by
Attachment: | hours_postgres.diff added |
---|
comment:1 Changed 13 years ago by
Priority: | normal → high |
---|---|
Status: | new → assigned |
comment:4 Changed 11 years ago by
Description: | modified (diff) |
---|
I'm not setup to test on PostgreSQL yet, but I'll commit the fix and please report back if it is working well for you.
Note: See
TracTickets for help on using
tickets.
patch for early return where no ticket ID is provided