[connie]

I have tried to upgraded 4.0.3 pro to 4.0.12, big error occurs, anyone knows why it happened?

INVALID SQL: 1054 : Unknown column 'subscribe' in 'where clause'
SQL QUERY FAILURE: SELECT COUNT(*) FROM xcart_newslists WHERE avail = 'Y' AND subscribe = 'Y'
INVALID SQL: 1072 : Key column 'protocol' doesn't exist in table
SQL QUERY FAILURE: SELECT paymentid FROM xcart_payment_methods USE INDEX (protocol) WHERE protocol = 'https'

Warning: Cannot modify header information - headers already sent by (output started at /home/pictureh/public_html/store/include/func.php:137) in /home/pictureh/public_html/store/referer.php on line 61
INVALID SQL: 1072 : Key column 'code' doesn't exist in table
SQL QUERY FAILURE: SELECT xcart_languages.code, xcart_countries.*, lng_c.value as country, lng_l.value as language FROM xcart_languages USE INDEX (code), xcart_countries, xcart_languages as lng_c, xcart_languages as lng_l WHERE lng_c.name = CONCAT('country_', xcart_countries.code) AND lng_c.code = 'US' AND lng_l.code = 'US' AND lng_l.name = CONCAT('language_', xcart_countries.code) AND xcart_languages.code=xcart_countries.code GROUP BY xcart_languages.code ORDER BY xcart_languages.code
INVALID SQL: 1072 : Key column 'code' doesn't exist in table
SQL QUERY FAILURE: SELECT xcart_languages.code, xcart_countries.*, lng_c.value as country, lng_l.value as language FROM xcart_languages USE INDEX (code), xcart_countries, xcart_languages as lng_c, xcart_languages as lng_l WHERE lng_c.name = CONCAT('country_', xcart_countries.code) AND lng_c.code = 'US' AND lng_l.code = 'US' AND lng_l.name = CONCAT('language_', xcart_countries.code) AND xcart_languages.code=xcart_countries.code GROUP BY xcart_languages.code ORDER BY xcart_languages.code
INVALID SQL: 1146 : Table 'pictureh_store2.xcart_categories_subcount' doesn't exist
SQL QUERY FAILURE: SELECT xcart_categories.categoryid,xcart_categories.paren tid,xcart_categories.categoryid_path,xcart_categor ies.category,xcart_categories.product_count,xcart_ categories.avail,xcart_categories.order_by,IF(xcar t_categories_lng.category != '', xcart_categories_lng.category, xcart_categories.category) as category,xcart_categories_subcount.subcategory_cou nt, xcart_categories_subcount.product_count,IF(xcart_i cons.image != '','Y','') as is_icon FROM xcart_categories USE INDEX (am) LEFT JOIN xcart_categories_lng USE INDEX (PRIMARY) ON xcart_categories_lng.code='US' AND xcart_categories_lng.categoryid=xcart_categories.c ategoryid LEFT JOIN xcart_categories_subcount USE INDEX (PRIMARY) ON xcart_categories_subcount.categoryid = xcart_categories.categoryid AND xcart_categories_subcount.membership = xcart_categories.membership LEFT JOIN xcart_icons ON xcart_categories.categoryid = xcart_icons.categoryid WHERE xcart_categories.avail='Y' AND xcart_categories.membership IN('', '') GROUP BY xcart_categories.categoryid ORDER BY xcart_categories.order_by, xcart_categories.category
INVALID SQL: 1072 : Key column 'avail' doesn't exist in table
SQL QUERY FAILURE: SELECT * FROM xcart_manufacturers USE INDEX (avail) WHERE avail = 'Y' ORDER BY orderby LIMIT 10