Im suing the following:
CSVI Pro 6.3.0
Joomla 3.4.5
When i try and import products i get the following error.
An error has occured during the import. Below the information received from the server.
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 = 144 AND product_price_publish_up = '0000-00-00 00:0' at line 3 SQL=SELECT virtuemart_product_price_id FROM gght_virtuemart_product_prices WHERE virtuemart_product_id = 29062 AND price_quantity_start = 0 AND price_quantity_end = 0 AND virtuemart_shoppergroup_id IS NULL) AND product_currency = 144 AND product_price_publish_up = '0000-00-00 00:00:00' AND product_price_publish_down = '0000-00-00 00:00:00'
What am i doing wrong?
From what im reading your missing a ( to surround the section virtuemart_shoppergroup_id IS NULL) so it looks like (virtuemart_shoppergroup_id IS NULL)
THANKS!
Hello,
Did you also update the VirtueMart add-on? This is already fixed in the 6.3.0 version of the VirtueMart add-on.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
I'm sorry i totally forgot to handle that upgrade! it seems to be working now. thank you.
Log in to reply to this topic.