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
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'
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
Yes that worked and the import seemed to work normally but i get another error while importing and interupts it
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')
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
Yes. Everything worked fine for 2679 products and no errors.
Thank you once again for fast and reliable support! :)
Log in to reply to this topic.