Critical error after upgrade to 1.2.12... PLEASE HELP!

[pixel]

I am getting the following error when I updated to 1.2.12

There has been a critical error processing your request

SQL Error: Unknown column 'stock_checkout' in 'field list'
Error No: 1054
SQL: SELECT DISTINCT *, pd.name AS name, m.name AS manufacturer, ss.name AS stock_status, stock_checkout, lcd.unit as length_class_name, ( SELECT AVG(r.rating) FROM abpc_reviews r WHERE p.product_id = r.product_id AND status = 1 GROUP BY r.product_id ) AS rating , COALESCE( ( SELECT p2sp.price FROM abpc_product_specials p2sp WHERE p2sp.product_id = p.product_id AND p2sp.customer_group_id = '1' AND ((p2sp.date_start = '0000-00-00' OR p2sp.date_start < NOW()) AND (p2sp.date_end = '0000-00-00' OR p2sp.date_end > NOW())) ORDER BY p2sp.priority ASC, p2sp.price ASC LIMIT 1 ) , p.price) as final_price FROM abpc_products p LEFT JOIN abpc_product_descriptions pd ON (p.product_id = pd.product_id AND pd.language_id = '1') LEFT JOIN abpc_products_to_stores p2s ON (p.product_id = p2s.product_id) LEFT JOIN abpc_manufacturers m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN abpc_stock_statuses ss ON (p.stock_status_id = ss.stock_status_id AND ss.language_id = '1') LEFT JOIN abpc_length_class_descriptions lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') WHERE p.product_id = '125' AND p2s.store_id = '0' AND p.date_available <= NOW() AND p.status

[abantecart]

Did you get any errors during upgrade?

Looks like stock_checkout column is missing

You can try add missing column with

ALTER TABLE ac_products ADD COLUMN `stock_checkout` CHAR(1) NULL DEFAULT '';

[pixel]

no errors. Added this line and it works, thank you so much. I now have one other issue I cannot seem to figure out... I have slowly been getting this wire code displaying on the home page and then on the products pages it gets worse. I have tried playing with extensions and tried to find places to later code but have not been successful, can you possibly assist with this?

[Basara]

Hi.
First check for the 3rd party extension you have installed. You need uninstall one by one to make sure they did not broke template

[pixel]

I have... no luck!

[Basara]

Uninstall addthis if you have it but please post a link so we can check too

[pixel]

UGH!! I totally skipped over that one! That was my problem! Thank you so much!

[llegrand]

Did you have the latest version of Addthis installed?  v 1.2.7.10 is latest

http://marketplace.abantecart.com/addthis?keyword=addthis&category_id=0

third-party extension get updated too!