1. ctrouillas
  2. RO CSVI
  3. Wednesday, 25 February 2015
  4.  Subscribe via email
Hi Roland,

I am running J 3.3.6 / CSV 5.17 / VM3.0.2 turning on OVH.

I try to import a former CSV file from my J2.5 site.(enclosed).
The CSVI template has been created identically.

Now I get this 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 '' at line 3 SQL=DELETE FROM e4h67_virtuemart_product_customfields WHERE virtuemart_product_id = 91 AND virtuemart_custom_id =


Thanks for you support,

Christophe
Accepted Answer Pending Moderation
Hello Christophe,

Either remove (if you use column headers as configuration) or skip (if you use the template fields) the empty custom_title, custom_value and custom_param fields. You should be OK to go.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 21
  • Page :
  • 1
  • 2


There are no replies made for this post yet.
Be one of the first to reply to this post!