Ticket #7823 (closed defect: fixed)

Opened 3 years ago

Last modified 7 months ago

Use of datetime() breaks plugin with mysql backend

Reported by: anonymous Assigned to: 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

Change History

10/14/10 14:14:42 changed by doki_pen

  • status changed from new to closed.
  • resolution set to fixed.

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

Fixes #7823

10/27/12 15:08:07 changed by hasienda

  • keywords set to database API.

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/Change #7823 (Use of datetime() breaks plugin with mysql backend)




Change Properties
Action