-- 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.