Arrowhead123 Posted February 21, 2006 Posted February 21, 2006 Hello, I backed up a database to my local drive. I added a module locally, then uploaded the changes and tried restoring the database I saved locally. I then get the following message: 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 ''Top quality 25 piece 11.5 gram "Suited" design poker insert into products_description (products_id, language_id, products_name, products_description, products_url, products_viewed) values ('29', '1', '\"Suited\" Poker Chip Set', 'Top quality 25 piece 11.5 gram "Suited" design poker chip set. These quality poker chips are made of top quality composite resin(ABS) with a metal [TEP STOP] 1146 - Table 'db152386534.sessions' doesn't exist select count(*) as total from sessions where sesskey = 'e58764aab7310b717c78b32c2784a9fa' [TEP STOP] How can this be, and how can I solve it? Thanks!
AlanR Posted February 21, 2006 Posted February 21, 2006 Edit the file in a text editor and change "Suited" to \"Suited\" Local: Mac OS X 10.5.8 - Apache 2.2/php 5.3.0/MySQL 5.4.10 • Web Servers: Linux Tools: BBEdit, Coda, Versions (Subversion), Sequel Pro (db management)
Arrowhead123 Posted February 21, 2006 Author Posted February 21, 2006 It seems that if I upload the file via the admin/tools interface, it doesn't work. But if I upload via my server, it solves the problem. Thanks though. Edit the file in a text editor and change "Suited" to \"Suited\"
Recommended Posts
Archived
This topic is now archived and is closed to further replies.