URGENT ISSUE !Syntax Error When Creating Manual Order

  • Posts: 81
  • Thank you received: 0
7 years 7 months ago #265897

-- url of the page with the problem -- : shop.justducks.co.uk
-- HikaShop version -- : 3.0.0 BUSINESS
-- Joomla version -- : 3
-- PHP version -- : 5.6.3
-- Browser(s) name and version -- : all
-- 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 ')' at line 3 SQL=SELECT `p`.`product_id`,`p`.`product_name`,`p`.`product_code` FROM `#__hikashop_product` AS `p` WHERE `product_id` IN ()

In HikaShop Admin > Orders > New - we are attempting to manually create a new order.

However, the following error is displayed:

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 ')' at line 3 SQL=SELECT `p`.`product_id`,`p`.`product_name`,`p`.`product_code` FROM `#__hikashop_product` AS `p` WHERE `product_id` IN ()

Please advise as to corrective action so as to allow "New" orders to be created manually by admin.

Thank you.

Last edit: 7 years 7 months ago by herb200mph.

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

  • Posts: 82866
  • Thank you received: 13373
  • MODERATOR
7 years 7 months ago #265898

Hi,

Update to HikaShop 3.0.1 and that should fix the problem.

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

Time to create page: 0.055 seconds
Powered by Kunena Forum