Opened 9 years ago

Closed 8 years ago

Last modified 8 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 8 years ago by cadiolis@…

  • Trac Release set to 0.8

Postgresql syntax is NULLIF (versus IFNULL)

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

comment:2 Changed 8 years ago by mgood

  • Resolution set to fixed
  • Status changed from new to closed

(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

Add Comment

Modify Ticket

as closed The owner will remain jornh.
The resolution will be deleted. Next status will be 'reopened'.

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

Note: See TracTickets for help on using tickets.