Hello,
Configuration
Joomla: 3.4.1
MySQL: 5.5.42
VM: 3.0.7
CVSI Pro: 5.21.2
Hello, I am having issues exporting custom tables using CSVI Pro. I can export all standard VirtueMart fields just fine. If I try even a single Custom Field I get a mySQL syntax error. I have tried different custom fields and only the product_sku and one custom field. I have also updated my list of available fields and reset the field in CSVI. Nothing has helped. Below is the error message I am receiving. Do you have any suggestions?
Error: 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 4 SQL=SELECT p.customfield_value
FROM abcde_virtuemart_product_customfields p
LEFT JOIN abcde_virtuemart_customs c ON p.virtuemart_custom_id = c.virtuemart_custom_id
WHERE c.custom_title = 'Details' AND p.virtuemart_product_id =
Thanks!
--Gary
Hello Gary,
The error means that there is no field that triggered loading the virtuemart_product_id field. You can either add this field to your export so it will run or add for example the category_path. That should solve the SQL error you see.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Ahhh…
So simple. For some reason I was thinking that product_sku was the required field. virtuemart_product_id makes more sense. I made the change and my export is working as expected. Thanks for the help and quick reply.
Log in to reply to this topic.