Categories
View Replies (2)

Resolved SQL error

  1. easypony
    easypony
  2. RO CSVI
  3. Wednesday, 30 September 2015
  4.  Subscribe via email
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
0
Responses (2)
easypony
easypony
Accepted Answer Pending Moderation
Thank you.

Steve
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
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
  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!