Opened 7 years ago

Closed 7 years ago

Last modified 4 years ago

#7823 closed defect (fixed)

Use of datetime() breaks plugin with mysql backend

Reported by: anonymous Owned by: Robert Corsaro
Priority: high Component: AnnouncerPlugin
Severity: major Keywords: database API
Cc: Trac Release: 0.12


Instead of using datetime() in SQL queries, use CURRENT_TIMESTAMP, or do what other plugins do and use either trac.util.to_timestamp or trac.util.to_utimestamp.

Attachments (0)

Change History (2)

comment:1 Changed 7 years ago by Robert Corsaro

Resolution: fixed
Status: newclosed

(In [9293]) Make timestamps cross-db platform

Fixes #7823

comment:2 Changed 4 years ago by Steffen Hoffmann

Keywords: database API added

Oh no, don't use CURRENT_TIMESTAMP, because it produces non-portable time stamps! The way to go is really only the other option, hence we have to deal with #7975 now.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Robert Corsaro.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Note: See TracTickets for help on using tickets.