Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Bug in OSC 2.2rc2 - backup.php


syscon

Recommended Posts

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?

#Joseph

Link to comment
Share on other sites

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

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

 

Virus Threat Scanner

My Contributions

Basic install answers.

Click here for Contributions / Add Ons.

UK your site.

Site Move.

Basic design info.

 

For links mentioned in old answers that are no longer here follow this link Useful Threads.

 

If this post was useful, click the Like This button over there ======>>>>>.

Link to comment
Share on other sites

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.

#Joseph

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...