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 11 SQL=SELECT `order_number` 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 ()
I have flushed the browser's cache, because that seemed to help at first; the odd thing is if I create a new export add 2 fields it will run, but going in and only changing the name of the export will cause it to fail.
I and exporting the order number and a user custom field