Support is online

SQL error #7665

Open easypony opened this topic Wednesday, 30 September 2015 · 2 replies
Author

Hi

Joomla version 3.4.4
CSVI Pro 6.2.0

I have added the log zip as well.

I am getting an error on import. When I analyse the csv all seems good. The error is:

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 = 9 AND product_price_publish_up = '0000-00-00 00:00:' at line 3 SQL=SELECT virtuemart_product_price_id FROM oens6_virtuemart_product_prices WHERE virtuemart_product_id = 22 AND price_quantity_start = 0 AND price_quantity_end = 0 AND virtuemart_shoppergroup_id IS NULL) AND product_currency = 9 AND product_price_publish_up = '0000-00-00 00:00:00' AND product_price_publish_down = '0000-00-00 00:00:00'

Your assistance is appreciated.
Steve

Support

Hello Steve,

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

Author

Thank you.

Steve

Log in to reply to this topic.