1064 error executing massaction

  • Posts: 30
  • Thank you received: 0
7 years 9 months ago #262171

-- url of the page with the problem -- : www.bandenservice-lelystad.nl
-- HikaShop version -- : 3.0.0
-- Joomla version -- : 3.6.5
-- Error-message(debug-mod must be tuned on) -- : 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 '(9103777,9103077,'options'),(9103779,9103077,'options'),(9103781,9103077,'option' at line 1 SQL=INSERT INTO #__hikashop_product_related (product_id, product_related_id, product_related_type) VALUES (9103078,9103077,'options'),(9103079,9103077,'options'),(9103080,9103077,'options'),(9103081,9103077,'options'),

Hello,

i am trying to add a product option through massaction, but it gives me this 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 '(9103777,9103077,'options'),(9103779,9103077,'options'),(9103781,9103077,'option' at line 1 SQL=INSERT INTO #__hikashop_product_related (product_id, product_related_id, product_related_type) VALUES (9103078,9103077,'options'),(9103079,9103077,'options'),(9103080,9103077,'options'),(9103081,9103077,'options'),

he doesnt add the options to all products, same problem i have when i trie to add them at steps of 500 at a time.
Ive added a printscreen as attachments, what am i doing wrong ?

Attachments:
Last edit: 7 years 9 months ago by Sennrox.

Please Log in or Create an account to join the conversation.

  • Posts: 26159
  • Thank you received: 4028
  • MODERATOR
7 years 9 months ago #262173

Hi,

Can you please provide a screenshot of your mass-action configuration ?

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 30
  • Thank you received: 0
7 years 9 months ago #262338

Hello,

I have tried it again and it works just fine.
Before i tried i removed the massaction i had, and made a new one.

thanks for the quick reply.

Kevin

Please Log in or Create an account to join the conversation.

Time to create page: 0.051 seconds
Powered by Kunena Forum