CSV Import - MySQL Error

By theclicklab - April 14, 2012 - edited: April 14, 2012

Hi there, trying to import a simple Test CSV and getting the following error on every row:

Import Row #1 - MySQL 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 'case = DEFAULT , category = DEFAULT' at line 13

Have tried deleting any data which has a comma in it from the csv

See attached files

PHP v5.2.17
MySQL v5.1.56
CSV Import 1.04
CMS Builder 2.14

Any suggestions?

Thanks!

Re: [Tom P] CSV Import - MySQL Error

By theclicklab - April 16, 2012

Ok thanks tom, done.