Welcome, Guest
Username: Password: Remember me
Default product support category.
  • Page:
  • 1

TOPIC: error 1064

error 1064 3 years 4 days ago #186

  • pvladikov
  • pvladikov's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 1
  • Karma: 3
Hi eKerner,

Thank you for this great product!

I've the following error when importing the CSV file:

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=INSERT INTO sxa02_virtuemart_product_customfields (virtuemart_product_id, virtuemart_custom_id, customfield_value, customfield_price, created_on, created_by, modified_on, modified_by, ordering) VALUES (11, 6, '4', '0', '2015-02-16 23:38:33', 127, '2015-02-16 23:38:33', 127, 0++)

Do you have an idea what I'm doing wrong?

Best Regards
The administrator has disabled public write access.

error 1064 3 years 3 days ago #187

  • ekerner
  • ekerner's Avatar
  • OFFLINE
  • Administrator
  • Posts: 240
  • Thank you received: 24
  • Karma: 2
It was a bug accidentally created in a previous minor release.

The update is available to logged in buyers via
shop.ekerner.com/index.php/shop/com-vmproductscsv-detail

Iv also emailed it to you.

Thanks.
The administrator has disabled public write access.
The following user(s) said Thank You: pvladikov

error 1064 3 years 3 days ago #188

  • pvladikov
  • pvladikov's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Thank you received: 1
  • Karma: 3
Thank you very much for the quick support !

Now it works like a charm!

I'd recommend your product!

Best Regards
The administrator has disabled public write access.
The following user(s) said Thank You: ekerner
  • Page:
  • 1
Time to create page: 0.198 seconds

Receive Product Updates

Logged in members may subscribe to receive product updates. LOGIN

Select Currency

Featured Products

Contact Us

Call us at:
+61 415 607 770

Email us at:
shop@ekerner.com

Leave us feedback:
Feedback Form

Message Us:
Enquiry Form

facebook

twitter

rss