Bug in OSC 2.2rc2 - backup.php

[syscon]

I use backup.php in admin/ to make a backup database but after recent addition of VVC_VERSION_3.2 I created a table:

 

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)
);

 

When I make a backup of the database it creates:

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)
);

 

There should be no quotes around 'CURRENT_TIMESTAMP'

 

Anybody knows how to fix it?

[♥geoffreywalton]

You could spend time debugging it or now you know the problem, if you ever need to restore the db, edit the file manually and remove the offending quotes then restore it..

 

HTH

 

G

[MrPhil]

Please don't open multiple threads for one problem. I have replied in your other thread.

[syscon]

Please don't open multiple threads for one problem. I have replied in your other thread.

 

Apology about it.

 

When I ninitially posted it I put it under different subject as I didn't know that this was a bug in backup.php; so I post a new message reflecting correct subject.

If I could just change the subject I wouldn't need to post a new thread.

I wanted the subject to reflect the real problem.