- Posts: 30
- Thank you received: 0
1064 error executing massaction
9 years 7 months ago - 9 years 7 months ago #262171
by Sennrox
1064 error executing massaction was created 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 ?
-- 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.
9 years 7 months ago #262173
by Jerome
Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.
Replied by Jerome on topic 1064 error executing massaction
Hi,
Can you please provide a screenshot of your mass-action configuration ?
Regards,
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.
9 years 7 months ago #262338
by Sennrox
Replied by Sennrox on topic 1064 error executing massaction
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
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