Categories
View Replies (2)

Resolved SQL error on product import

  1. bydomino
    bydomino
  2. RO CSVI
  3. Thursday, 05 November 2015
  4.  Subscribe via email
Im suing the following:
CSVI Pro 6.3.0
Joomla 3.4.5
When i try and import products i get the following error.

An error has occured during the import. Below the information received from the server.

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

What am i doing wrong?

From what im reading your missing a ( to surround the section `virtuemart_shoppergroup_id` IS NULL) so it looks like (`virtuemart_shoppergroup_id` IS NULL)
THANKS!
0
Responses (2)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Did you also update the VirtueMart add-on? This is already fixed in the 6.3.0 version of the VirtueMart add-on.
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
bydomino
bydomino
Accepted Answer Pending Moderation
I'm sorry i totally forgot to handle that upgrade! it seems to be working now. thank you.
  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!