Skip to main content

1064 error executing massaction

More
9 years 7 months ago - 9 years 7 months ago #262171 by Sennrox
-- 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 ?
Last edit: 9 years 7 months ago by Sennrox.

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

More
9 years 7 months ago #262173 by Jerome
Hi,

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

Regards,

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

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

More
9 years 7 months ago #262338 by Sennrox
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.187 seconds
Powered by Kunena Forum