Categories
View Replies (2)

Resolved Error 1064 when trying to export custom field

  1. millermultimedia
    millermultimedia
  2. RO CSVI
  3. Tuesday, 30 June 2015
  4.  Subscribe via email
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
0
Responses (2)
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
millermultimedia
millermultimedia
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!