markThomas Posted January 16, 2014 Share Posted January 16, 2014 We are having some long delays in confirmation/download emails and disappearing basket events. Checking the Sys Log I find this error repeated. Can someone translate and point me in the right direction? Database has not been altered outside of the the administrative panels. Thanks ------ File: [database.class.php] Line: [576] "SELECT COUNT(*) AS Count FROM `cc_`cc_CubeCart_inventory` AS `I` LEFT JOIN `cc_CubeCart_option_matrix` AS `M` on `I`.`product_id` = `M`.`product_id`` WHERE use_stock_level = 1 AND (((I.stock_warning > 0 AND M.stock_level <= I.stock_warning) OR (I.stock_warning <= 0 AND M.stock_level <= 5)) OR ((I.stock_warning > 0 AND I.stock_level <= I.stock_warning) OR (I.stock_warning <= 0 AND I.stock_level <= 5)));" - 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 '` AS `I` LEFT JOIN `cc_CubeCart_option_matrix` AS `M` on `I`.`product_id` = `M`.' at line 1 Link to comment Share on other sites More sharing options...
bsmither Posted January 16, 2014 Share Posted January 16, 2014 Bug. Please read: '?do=embed' frameborder='0' data-embedContent>> Link to comment Share on other sites More sharing options...
markThomas Posted January 16, 2014 Author Share Posted January 16, 2014 Most excellent. I am tracking down the code. You guys are really quite good. Thank you. Link to comment Share on other sites More sharing options...
Recommended Posts