VM 3
Joomla 3.4
CSVI Pro
Hey Rolandd,
I am having problems to import new products including a price. A couple days ago, with other products, it worked but now I am receiving an error. Would you please translate the error?
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 aw2hd_virtuemart_product_prices WHERE virtuemart_product_id = 461 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' Thanks!!
I am using product_sku and product_price
Hello Julius,
See this announcement SQL error on price import.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
worked! Thank you!!
Log in to reply to this topic.