Re: [gentoo-user] php CURRENT_TIMESTAMP vs NOW()

[Joseph]

On 12/28/12 02:00, Michael Orlitzky wrote:

On 12/28/2012 01:44 AM, Joseph wrote:

I'm not a PHP programmer but I'll try to explain my problem.
I've create table in my php database:

DROP TABLE IF EXISTS visual_verify_code;
CREATE TABLE visual_verify_code (
   oscsid varchar(32) NOT NULL,
   code varchar(6) NOT NULL,
   dt TIMESTAMP(12) NOT NULL DEFAULT NOW(),
   PRIMARY KEY (oscsid)
);

Looks fine.

It worked OK, after few days I backup my database and try to restore it, but it keeps 
complaining on the "dt":
ERROR 1067 (42000) at line 38009: Invalid default value for 'dt'

so the database is dropped but never restored. The backup data base contain:

create table visual_verify_code (
   oscsid varchar(32) not null ,
   code varchar(6) not null ,
   dt timestamp default 'CURRENT_TIMESTAMP' not null ,
   PRIMARY KEY (oscsid)
);

CURRENT_TIMESTAMP shouldn't be quoted. How are you backing up the database?

Your are correct, when I removed the quotes it worked.

I'm backing it up through the backup.php sript that came with osCommerce, I can 
post it but it is a long one.

--
Joseph