Modify

Opened 4 years ago

Closed 4 years ago

Last modified 2 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

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 4 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 2 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

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.