I have recently gotten a LOT of orders having problems checking out. I checked the error log and have a LOT of errors. I seem to remember a maintenance option awhile back that would rebuild the DB and correct any errors, but does not seem to do
1) File: [catbanners.class.php] Line: [38] "select * from Category_banners WHERE status = 1 AND cat_id = sale AND flash=1 order by priority ASC " - Unknown column 'sale' in 'where clause'
2) File: [filter.class.php] Line: [95] "SELECT max(I.price) as maxval from `CubeCart_inventory` as I INNER JOIN `CubeCart_category_index` as CI ON I.product_id = CI.product_id WHERE I.status=1 AND CI.cat_id = " - 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
3)
File: [filter.class.php] Line: [62] "Select OV.value_name, OV.value_id FROM CubeCart_option_assign AS OA INNER JOIN CubeCart_category_index as CI ON OA.product = CI.product_id INNER JOIN CubeCart_option_value AS OV ON OV.value_id = OA.value_id where CI.cat_id= AND OA.option_id=6 group by OV.value_name " - 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 'AND OA.option_id=6 group by OV.value_name' at line 1
When I look in the DB maintenance, there is also this error on the CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY.
Thank you for any advice or help,
Adam