i have an Error No: 1064

Avatar
Macmarice
  • Answered
Notice: Error: 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 ''20150401',0,'Black 3 strap sandals PRICE-(7,000)-(66).jpg',1,7000.00,0,'2015-05' at line 1
Error No: 1064
i imported into opencart using and import/Export tool & i got this error.
Please how exactly do i solve this.
Replies 1
Avatar
0
Arn
Hello Macmarice,

Sorry to hear that you're having a problems with the Import/Export tool. The problem is that the SQL code used by OpenCart can't process the imported file names that you're trying to put into the database. You will need re-format your file names and data so that it does not cause that conflict. Primarily, I would get rid of the spaces, commas and parentheses in the file names. The example you're giving shows 'Black 3 strap sandals PRICE-(7,000)-(66).jpg'. That will definitely cause the database to choke as it can't identify that as a file name. Price should not be in the graphic name unless you want to incorporate it like this:

black3-strap-sandals-7000-66.jpg

The price for a product in an ecommerce database is generally a separate field, so it should not be part of the graphic name. I hope this helps to answer your question, please let us know if you require any further assistance.

Regards,
Arnel C.