loveacrossborders Posted December 18, 2004 Posted December 18, 2004 I hope that someone more familiar with MySQL can help us figure this out. My hosting company provides us with one MySQL database (100megs). Normally I backup osCommerce before I make any changes to it. The other day we installed Invision Power Board and Mambo open source content management software. It's all sharing this one database. I'm sure that's what's causing the error, I'd just like to have some idea about how to fix it. When I go to backup the database from the database backup management in osCommerce I get the following error: 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 'option,ordering,admin_menu_img,iscore,params from mos_component select id,name,link,menuid,parent,admin_menu_link,admin_menu_alt,option,ordering,admin_ menu_img,iscore,params from mos_components [TEP STOP] Can someone please be insightful and tell us what's causing this error?
Guest Posted December 18, 2004 Posted December 18, 2004 Try using HPHMyAdmin to restore the database, not osCommerce. TJ I hope that someone more familiar with MySQL can help us figure this out. My hosting company provides us with one MySQL database (100megs). Normally I backup osCommerce before I make any changes to it. The other day we installed Invision Power Board and Mambo open source content management software. It's all sharing this one database. I'm sure that's what's causing the error, I'd just like to have some idea about how to fix it. When I go to backup the database from the database backup management in osCommerce I get the following error: Can someone please be insightful and tell us what's causing this error? <{POST_SNAPBACK}>
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.