[email protected] Posted June 3, 2019 Share Posted June 3, 2019 Here is the error i am recieving in th eerror log File: [reports.index.inc.php] Line: [126] "SELECT `order_date`, `cart_order_id`, `status`, `subtotal`, `discount`, `shipping`, `total_tax`, `total`, `customer_id`, `title`, `first_name`, `last_name`, `company_name`, `line1`, `line2`, `town`, `state`, `country`, `postcode`, `title_d`, `first_name_d`, `last_name_d`, `company_name_d`, `line1_d`, `line2_d`, `town_d`, `state_d`, `country_d`, `postcode_d`, `phone`, `email`, `gateway` FROM `ccskmb_CubeCart_order_summary` WHERE order_date >= 1559347200 AND order_date <= 1559606399 AND `status` IN () ;" - 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 1 Can someone Please help Link to comment Share on other sites More sharing options...
bsmither Posted June 3, 2019 Share Posted June 3, 2019 There is a bug in the code. The code that builds this query is suppose to pre-select orders that are in the Processing and Complete status. Until this is fixed in the next version, you will need to first click the Filter tab and select the order statuses you want the report to contain (CTRL-click to select more than one status). Link to comment Share on other sites More sharing options...
havenswift-hosting Posted June 3, 2019 Share Posted June 3, 2019 This has already been reported - see https://github.com/cubecart/v6/issues/2314 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.