Created with MySQL 50077, now running 50158. Please use mysql_upgrade to fix this error.

1558: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50077, now running 50158. Please use mysql_upgrade to fix this error.

 

按照问题描述执行修复：

mysql_upgrade -h 192.168.1.2 -u root

 

shopnc.shopnc_p_bundling_goods OK
shopnc.shopnc_p_bundling_quota OK
shopnc.shopnc_p_mansong OK
shopnc.shopnc_p_mansong_quota OK
shopnc.shopnc_p_mansong_rule OK
shopnc.shopnc_p_xianshi OK
shopnc.shopnc_p_xianshi_goods OK
shopnc.shopnc_p_xianshi_quota OK
shopnc.shopnc_payment OK
shopnc.shopnc_pd_cash OK
shopnc.shopnc_pd_log OK
shopnc.shopnc_pd_recharge OK
shopnc.shopnc_points_cart OK
shopnc.shopnc_points_goods OK
shopnc.shopnc_points_log OK
shopnc.shopnc_points_order OK
shopnc.shopnc_points_orderaddress OK
shopnc.shopnc_points_ordergoods OK
shopnc.shopnc_rec_position OK
shopnc.shopnc_refund_return OK
shopnc.shopnc_salenum OK
shopnc.shopnc_seller OK
shopnc.shopnc_seller_group OK
shopnc.shopnc_seller_log OK
shopnc.shopnc_seo OK
shopnc.shopnc_setting
error : Table rebuild required. Please do "ALTER TABLE `shopnc_setting` FORCE" or dump/reload to fix it!
shopnc.shopnc_sns_albumclass OK
shopnc.shopnc_sns_albumpic OK
shopnc.shopnc_sns_binding OK
shopnc.shopnc_sns_comment OK
shopnc.shopnc_sns_friend OK
shopnc.shopnc_sns_goods OK
shopnc.shopnc_sns_membertag OK
shopnc.shopnc_sns_mtagmember OK
shopnc.shopnc_sns_setting OK
shopnc.shopnc_sns_sharegoods OK
shopnc.shopnc_sns_sharestore OK
shopnc.shopnc_sns_tracelog OK
shopnc.shopnc_sns_visitor OK
shopnc.shopnc_spec OK
shopnc.shopnc_spec_value OK
shopnc.shopnc_stat_member OK
shopnc.shopnc_store
error : Table rebuild required. Please do "ALTER TABLE `shopnc_store` FORCE" or dump/reload to fix it !
shopnc.shopnc_store_bind_class OK
shopnc.shopnc_store_class OK
shopnc.shopnc_store_cost OK
shopnc.shopnc_store_extend OK
shopnc.shopnc_store_goods_class OK
shopnc.shopnc_store_grade OK
shopnc.shopnc_store_joinin OK
shopnc.shopnc_store_navigation OK
shopnc.shopnc_store_plate OK