Modify

Opened 6 years ago

Closed 6 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

Description

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 6 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

Action
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.