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)
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. # 1
easypony
easypony
Accepted Answer Pending Moderation
Thank you.

Steve
  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!