Support is online

Error 1064 product import #7182

Open TONLOCK opened this topic Monday, 02 March 2015 · 2 replies
Author

Hi

I´m trying to configure an example file to do a product import on virtuemart.
I get this error message:

**1064 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 '' at line 3 SQL=SELECT virtuemart_product_id FROM hkyug_virtuemart_products_es_es WHERE virtuemart_product_id = **

Joomla! 3.3.6
Virtuemart 3.0.2
PHP version 5.4.4-14+deb7u12
Csvi Pro 5.20
Magic quotes off

Attached is the example file.

Thanks for help

Best regards

Support

Hello,

Looking at your CSV file, that look s all good. Can you post me the debug log of your import?

Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory

Author

Hi Roland

It´s great to be in contact with you again.

I solved the issue

There was a problem with the data that the quickstart of the template contained. Fixed it doing a maintenance cleaning the database and reinstalling the virtuemart example data in the migration tools.

Thanks for support anyway.

You can check this topic as solved.

Best regards!!

Log in to reply to this topic.