Hello Rolandd,
I have a problem with CSVI 6.2.0.(My previous version. 6.1.0 was ok) to import CSVI
"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 kvxys_virtuemart_product_prices WHERE virtuemart_product_id = 151 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'"
Thank you
Italo
CSVI Pro 6.2.0 setting:
Display errors Yes
Magic quotes runtime No
Magic quotes gpc No
PHP version 5.3.29
Joomla! version 3.4.4
Database schema version 6.2.0
All pluging CSVI Pro 6.2.0
Virtuemart: VirtueMart 3.0.10
Hello,
There is one ) too many. Attached is a patch that fixes this. Please load the patch file and then try your import again.
Let me know how it goes.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thank you! Problem solved
Worked for me too. Thanks Rolandd!
Same error - worked for me, too.
Log in to reply to this topic.