TDLWebs Posted December 1, 2019 Share Posted December 1, 2019 I recently upgraded a store from v6.2.2 to 6.2.8 and now there are thousands of images not showing up, both in categories and products. The upgrade failed from the admin option so I had to manually upload the 6.2.8 files and perform a manual upgrade. The System Error Log is showing; File: [dashboard.index.inc.php] Line:  "SELECT I.name, I.product_code, I.stock_level AS I_stock_level, I.stock_warning AS I_stock_warning, I.product_id, M.stock_level AS M_stock_level, M.use_stock as M_use_stock, M.cached_name FROM `CubeCart_inventory` AS `I` LEFT JOIN `CubeCart_option_matrix` AS `M` on `I`.`product_id` = `M`.`product_id` WHERE use_stock_level = 1 AND ((M.status = 1 AND M.use_stock = 1 AND M.stock_level <= ) OR (I.stock_level <= )) ;" - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') OR (I.stock_level <= ))' at line 1 and on Database Maintenance there is; CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY. The site literally does feature thousands of products and the cache is huge, so I don't know if that has anything to do with it. Can anybody offer help? I will be happy to pay for a fix. T Link to comment Share on other sites More sharing options...
This topic is now archived and is closed to further replies.