CSV Import - MySQL Error

3 posts by 2 authors in: Forums > CMS Builder: Plugins & Add-ons
Last Post: April 16, 2012   (RSS)

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!
Attachments:

test2.csv 1K

product_database-sql.php 3K

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