We are running into an SQL error when running a Hikashop Order export. This is the error:
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 ') GROUP BY `order_number`,`order_created`,`order_status`,`user_email`,`order_pay' at line 34 SQL=SELECT `order_number`, `order_created`, `order_status`, `user_email`, `as`.`address_firstname` AS `shipping_address_firstname`, `as`.`address_lastname` AS `shipping_address_lastname`, `as`.`address_company` AS `shipping_address_company`, `as`.`address_street` AS `shipping_address_street`, `as`.`address_street2` AS `shipping_address_street2`, `as`.`address_city` AS `shipping_address_city`, `as`.`address_state` AS `shipping_address_state`, `as`.`address_post_code` AS `shipping_address_post_code`, `as`.`address_telephone` AS `shipping_address_telephone`, `as`.`address_country` AS `shipping_address_country`, `order_payment_method`, `order_product_name`, `order_product_quantity`, `order_product_price`, `order_shipping_method`, `order_shipping_price`, `order_product_tax`, `order_full_price`, `serial_number`, `order_discount_code` FROM `#__hikashop_order` AS `o` LEFT JOIN `#__hikashop_order_product` AS `p` ON `p`.`order_id` = `o`.`order_id` LEFT JOIN `#__hikashop_user` AS `u` ON `u`.`user_id` = `o`.`order_user_id` LEFT JOIN `#__hikashop_address` AS `ab` ON `ab`.`address_id` = `o`.`order_billing_address_id` LEFT JOIN `#__hikashop_address` AS `as` ON `as`.`address_id` = `o`.`order_shipping_address_id` LEFT JOIN `#__hikashop_product` AS `prod` ON `prod`.`product_code` = `p`.`order_product_code` LEFT JOIN `#__users` AS `user` ON `user`.`id` = `u`.`user_cms_id` LEFT JOIN `#__hikashop_product_category` AS `pc` ON `pc`.`product_id` = `prod`.`product_id` LEFT JOIN `#__hikashop_category` AS `cat` ON `cat`.`category_id` = `pc`.`category_id` WHERE `pc`.`category_id` IN () GROUP BY `order_number`,`order_created`,`order_status`,`user_email`,`order_payment_method`,`order_product_name`,`order_product_quantity`,`order_product_price`,`order_shipping_price`,`order_full_price`,`serial_number`,`order_discount_code`
Attached is our template backup
