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
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
Thanks, It works
Log in to reply to this topic.