Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error when doing database backup


Kevin360

Recommended Posts

I get this error when running a database backup from admin

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from CubeCart_Modules' at line 1

 

select moduleId,module,folder,status,default from CubeCart_Modules

 

[TEP STOP]

 

I dont know much of anything about SQL. Any ideas on what this is?? When I close out, I see a backup file in the backup section of admin. Everything other aspect of my cart and admin seem to be working properly.

 

Help is always appreciated.

-

Link to comment
Share on other sites

I get this error when running a database backup from admin

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from CubeCart_Modules' at line 1

 

select moduleId,module,folder,status,default from CubeCart_Modules

 

[TEP STOP]

 

I dont know much of anything about SQL. Any ideas on what this is?? When I close out, I see a backup file in the backup section of admin. Everything other aspect of my cart and admin seem to be working properly.

 

Help is always appreciated.

-

That looks like something from Cube Cart not OScommerce. You can try deleting that table from your database.

Link to comment
Share on other sites

I get this error when running a database backup from admin

 

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from CubeCart_Modules' at line 1

 

select moduleId,module,folder,status,default from CubeCart_Modules

 

[TEP STOP]

 

I dont know much of anything about SQL. Any ideas on what this is?? When I close out, I see a backup file in the backup section of admin. Everything other aspect of my cart and admin seem to be working properly.

This is the osCommerce forum.....

 

Default is a reserved word in MySQL, it shouldn't be used as a column name.

You could try the Database backup manager contribution but no guarantee that that will work.

Link to comment
Share on other sites

I dont use cube cart.... I may have played around with it before I installed oscommerce... maybe I installed over the database and the cube cart tables stayed. Should I just delete all tables that say cube cart?

Link to comment
Share on other sites

Ok... fixed it. THanks!! I just dropped all the tables that started with cube_cart. OsCommerce now backups as expected. Thanks for the insight! I wouldn't have figured that out on my own.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...