Modify ↓

Opened 14 years ago

Closed 14 years ago

#8390 closed defect (duplicate)

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

Reported by: Adam Piper Owned by: Ryan J Ollos
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 (0)

Change History (1)

comment:1 Changed 14 years ago by Ryan J Ollos

Resolution: → duplicate
Status: new → closed

Duplicate of #8391 (which has the patch).

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Ryan J Ollos.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

E-mail address and name can be saved in the Preferences.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.