SQL error when using PostgreSQL viewing /hours where no tickets exist
|Reported by:||piperad||Owned by:||rjollos|
|Severity:||normal||Keywords:||postgresql postgres sql syntax error|
Description (last modified by rjollos)
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 (6)
Changed 5 years ago by piperad
comment:1 Changed 5 years ago by rjollos
- Priority changed from normal to high
- Status changed from new to assigned
Note: See TracTickets for help on using tickets.