Question

ecshop 数据库这个提示是什么意思？

继续上面MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT a.attr_id, a.attr_name, a.attr_group, a.is_linked, a.attr_type, g.goods_attr_id, g.attr_value, g.attr_price ,v.img_id, v.thumb_url, v.img_original,a.is_show_img FROM `test1`.`ecs_goods_attr` AS g LEFT JOIN `test1`.`ecs_attribute` AS a ON a.attr_id = g.attr_id LEFT JOIN `test1`.`ecs_goods_gallery` AS v ON g.img_id = v.img_id WHERE g.goods_id = '1506' ORDER BY a.sort_order, g.attr_price, g.goods_attr_id ) [2] => Array ( [error] => Unknown column 'a.is_show_img' in 'field list' ) [3] => Array ( [errno] => 1054 ) )就是2.73 升级到3.0

Answer 1

ecs_attribute表缺少is_show_img字段，可以先安装个3.0的，然后到数据库里找到这个表里的这个字段类型，然后单独在2.7.3升3.0的数据库里加上就可以了