Error codes on check out

[adamfrey]

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

[bsmither]

I don't recognize 'catbanners.class.php' or 'filter.class.php'.

Might these files be in an extension?

 

[bsmither]

Please use an external database utility to view the indexes of CubeCart_order_summary. It may be the case that there is a regular KEY in addition to a UNIQUE KEY attached to that table for the column 'custom_oid'. You can delete the regular KEY, but do not delete the UNIQUE KEY for 'custom_oid'.