Ticket #8390 (closed defect: duplicate)

Opened 2 years ago

Last modified 2 years ago

SQL error when using PostgreSQL viewing /hours where no tickets exist

Reported by: piperad Assigned to: rjollos
Priority: normal 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.

Attachments

Change History

01/11/11 19:30:52 changed by rjollos

  • status changed from new to closed.
  • resolution set to duplicate.

Duplicate of #8391 (which has the patch).

Add/Change #8390 (SQL error when using PostgreSQL viewing /hours where no tickets exist)




Change Properties
Action