Opened 13 years ago

Last modified 11 years ago

#8391 closed defect

SQL error when using PostgreSQL viewing /hours where no tickets exist — at Initial Version

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

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 (1)

Changed 13 years ago by Adam Piper

Attachment: hours_postgres.diff added

patch for early return where no ticket ID is provided

Note: See TracTickets for help on using tickets.