SQL error when adding new products

  • Posts: 1
  • Thank you received: 0
9 years 11 months ago #213916

-- HikaShop version -- : 2.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 '),(12,4,)' at line 1 SQL=INSERT IGNORE INTO j8p1d_hikashop_product_category (category_id,product_id,ordering) VALUES (2,4,),(12,4,);

Dear Forummembers,

I installed Hikashop so far i like it and i want to buy the commercial version, but when i want to add new products i get an Sql 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 '),(12,4,)' at line 1 SQL=INSERT IGNORE INTO j8p1d_hikashop_product_category (category_id,product_id,ordering) VALUES (2,4,),(12,4,);

Can somebody help me to solve this error so i can add items to my webshop.

Thanks a lot

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

  • Posts: 26272
  • Thank you received: 4044
  • MODERATOR
9 years 11 months ago #213917

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.

Time to create page: 0.034 seconds
Powered by Kunena Forum