Categories
View Replies (4)

Resolved Error in your SQL syntax-Import Product

  1. Tecnologic
    Tecnologic
  2. RO CSVI
  3. Monday, 28 September 2015
  4.  Subscribe via email
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
0
Responses (4)
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Attachments (1)
patch_productprice_20150928.zip
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
Tecnologic
Tecnologic
Accepted Answer Pending Moderation
Thank you! Problem solved
  1. more than a month ago
  2. RO CSVI
  3. # 2
devteam
devteam
Accepted Answer Pending Moderation
Worked for me too. Thanks Rolandd!
  1. more than a month ago
  2. RO CSVI
  3. # 3
seagul
seagul
Accepted Answer Pending Moderation
Same error - worked for me, too.
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!