1. codeingenia
  2. RO CSVI
  3. Thursday, 01 October 2015
  4.  Subscribe via email
JOOMLA 3.4.4
CSVI 6.2.0
VIRTUEMART 3.0.10

If I try to import a csv file with product_price field I receive this 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 ') AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00' at line 3 SQL=SELECT `virtuemart_product_price_id` FROM `wer9i_virtuemart_product_prices` WHERE `virtuemart_product_id` = 25 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` IS NULL) AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'

If I try to import without product_price all works ok.

My template fields are:

product_sku
product_name
product_s_desc
product_price
product_in_stock
category_path
file_title
file_url
published
file_url_thumb
custom_title
custom_value
product_desc
product_gtin

Attachments: Log of import with error

It seems that error is in SQL SINTAX: there is ') AND and there isn't ( in the SQL when I use price field.

Thanks
Accepted Answer Pending Moderation
Hello,

Issue has been mentioned on the forum a few times.

Please use the patch provided in this thread. That will fix it until the next release is out.
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. # 1
Accepted Answer Pending Moderation
Thanks, It works
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


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