Question

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => UPDATE `my6395545`.`ecs_goods` SET buymax='0', buymax_start_date = '0' , buymax_end_date = '0' WHERE `goods_id`='1' ) [2] => Array ( [error] => Unknown column 'buymax' in 'field list' ) [3] => Array ( [errno] => 1054 ) )
我用的是ecshop程序，今天一发文章后台就是这样，什么原因？

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励10（财富值+成长值）+提问者悬赏5（财富值+成长值）

Answer 1

原本点击留言填表页面本测试错传服务器错MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT g.goods_id , o.user_id, o.city FROM `zbg0618`.`ecs_order_goods` AS g RIGHT JOIN `zbg0618`.`ecs_order_info` AS o ON o.order_id = g.order_id ORDER BY O.add_time DESC LIMIT 0,10 ) [2] => Array ( [error] => Unknown column 'O.add_time' in 'order clause' ) [3] => Array ( [errno] => 1054 ) )