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: doki_pen
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 6 years ago by doki_pen

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

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

Fixes #7823

comment:2 Changed 4 years ago by hasienda

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

Add Comment

Modify Ticket

as closed The owner will remain doki_pen.
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.