Categories
View Replies (4)

Resolved Trying to import...[SOLVED]

  1. infogate
    infogate
  2. RO CSVI
  3. Friday, 09 October 2015
  4.  Subscribe via email
IN logs i get

1 Updated Success Product updated
1 Updated Success Product language updated

When i import the CSV file i get the following error

[code type=mysql]
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` = 47 AND `product_price_publish_up` = '0000-00-00 00:00' at line 3 SQL=SELECT `virtuemart_product_price_id` FROM `jos_virtuemart_product_prices` WHERE `virtuemart_product_id` = 112 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'[/code]
0
Responses (4)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Please see this post with the patch file.
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
infogate
infogate
Accepted Answer Pending Moderation
Yes that worked and the import seemed to work normally but i get another error while importing and interupts it

[code type=sql]
An error has occured during the import. Below the information received from the server.
Duplicate entry 'dell-notebook-latitude-e5550-15-6-i5-5300u-win-7-8-1-pro-eng-5-y' for key 'slug' SQL=INSERT INTO `jos_virtuemart_products_el_gr` (`virtuemart_product_id`,`slug`) VALUES (667, 'dell-notebook-latitude-e5550-15-6-i5-5300u-win-7-8-1-pro-eng-5-years-fhd')
[/code]
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Please apply this patch to see if that solves the issue for you.
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. # 3
infogate
infogate
Accepted Answer Pending Moderation
Yes. Everything worked fine for 2679 products and no errors.

Thank you once again for fast and reliable support! :)
  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!