Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL problems


Arrowhead123

Recommended Posts

Posted

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!

Posted

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)

Posted

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\"

Archived

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

×
×
  • Create New...