Opened 12 years ago

Closed 12 years ago

Last modified 12 years ago

#158 closed defect (fixed)

Postgres-backed trac installations fail due to IFNULL not existing

Reported by: brian Owned by: jornh
Priority: normal Component: PlannedMilestonesMacro
Severity: blocker Keywords:
Cc: Trac Release: 0.8


Postgres Trac installations do not have an IFNULL function which is used in the SQL query. Instead, you must change it to COALESCE() which will have the same effect in this instance:

"ORDER BY (coalesce(due, 0) = 0) ASC, due ASC, name" % time()

Attachments (0)

Change History (2)

comment:1 Changed 12 years ago by cadiolis@…

Trac Release: 0.8

Postgresql syntax is NULLIF (versus IFNULL)

"ORDER BY (NULLIF(due, 0) = 0) ASC, due ASC, name" % time()

comment:2 Changed 12 years ago by Matt Good

Resolution: fixed
Status: newclosed

(In [796]) * use the Milestone model API to be cross-DB compatible and preserve proper sorting (fixes #158, #213, #235, #398)

  • use Markup to make sure HTML is properly escaped for output

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain jornh.
The resolution will be deleted.

Add Comment

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

Note: See TracTickets for help on using tickets.