Claudia M Posted February 15, 2019 Share Posted February 15, 2019 I got this several times in my system error log in admin. What does it mean and how do I fix it? Thanks in advance for any comments and help. File: [catalogue.class.php] Line: [1930] " " - Query was empty Today, 09:39 File: [catalogue.class.php] Line: [1932] "SELECT I.* FROM CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price, MAX(sale_price) as sale_price FROM CubeCart_pricing_group WHERE group_id = 0 GROUP BY product_id) as G ON G.product_id = I.product_id WHERE I.product_id IN (SELECT product_id FROM `CubeCart_category_index` as CI INNER JOIN CubeCart_category as C where CI.cat_id = C.cat_id AND C.status = 1) AND I.status = 1 AND " - 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 And this was in the error log I created: [15-Feb-2019 09:39:38 America/Louisville] PHP Warning: Invalid argument supplied for foreach() in /home/claudias/public_html/classes/catalogue.class.php on line 258 Link to comment Share on other sites More sharing options...
bsmither Posted February 15, 2019 Share Posted February 15, 2019 Looks like bug when asking for Sale Items when the store is in a Non-Sale Global Sale mode. Link to comment Share on other sites More sharing options...
Claudia M Posted February 15, 2019 Author Share Posted February 15, 2019 I have the sales mode disabled. When I list an item on eBay or Etsy I put my price in in the sale price box of that product so I know what to charge for it if it doesn't sell on eBay or Etsy. Should I not do that? Link to comment Share on other sites More sharing options...
bsmither Posted February 15, 2019 Share Posted February 15, 2019 A visitor (perhaps Google or similar) is making a request for sale items when the store is not in sale mode. This bug manifests in such a combination. The fix is in CC623: https://github.com/cubecart/v6/issues/2130 Link to comment Share on other sites More sharing options...
Claudia M Posted February 15, 2019 Author Share Posted February 15, 2019 Thanks Brian! Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.