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: [theclicklab] CSV Import - MySQL Error

By (Deleted User) - April 16, 2012

Hi Jan,

Could you send in a second level support request so I can test this further? https://www.interactivetools.com/support/email_support_form.php

We'll need the full ftp/cmsAdmin details

Thanks,

Tom