php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #20731 MySQL dependency
Submitted: 2002-11-30 04:52 UTC Modified: 2003-02-17 15:21 UTC
From: hopfgartner at rolmail dot net Assigned: jon (profile)
Status: Closed Package: PEAR related
PHP Version: 4.3.0RC2 OS:
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: hopfgartner at rolmail dot net
New email:
PHP Version: OS:

 

 [2002-11-30 04:52 UTC] hopfgartner at rolmail dot net 
Log 1.5.2

The code in Log/sql.php that constructs the INSERT statement contains the MySQL function NOW(). This is not portable.

It would be CURRENT_TIME in SQL:1999 and PostgreSQL and GETDATE() on the Microsoft SQL server.

Regards,

Peter Hopfgartner

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-02-17 15:21 UTC] jon@php.net 
This bug has been fixed in CVS.

We now use CURRENT_TIMESTAMP instead of NOW().  In addition, I've added a sequenced ID column to ensure unique identifiers.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Mon Jun 02 21:01:27 2025 UTC