Kevin360 Posted June 17, 2009 Posted June 17, 2009 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. -
playcraft Posted June 17, 2009 Posted June 17, 2009 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.
Jan Zonjee Posted June 17, 2009 Posted June 17, 2009 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.
Kevin360 Posted June 17, 2009 Author Posted June 17, 2009 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?
Kevin360 Posted June 17, 2009 Author Posted June 17, 2009 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.