Question

下面是我的ECSHOP模板里面下订单以后，查看订单的时候出现的代码，麻烦各位帮忙解决一下，在此表示重谢！

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT o.*, IF(o.product_id > 0, p.product_number, g.goods_number) AS storage, o.goods_attr, g.suppliers_id, IFNULL(b.brand_name, '') AS brand_name, p.product_sn FROM `ft7835035`.`bohe_order_goods` AS o LEFT JOIN `ft7835035`.`bohe_products` AS p ON p.product_id = o.product_id LEFT JOIN `ft7835035`.`bohe_goods` AS g ON o.goods_id = g.goods_id LEFT JOIN `ft7835035`.`bohe_brand` AS b ON g.brand_id = b.brand_id WHERE o.order_id = '44' ) [2] => Array ( [error] => Unknown column 'o.product_id' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

Answer 1

可能你的ecshop升过级吧，升级时你的数据库没有升级，所以数据库的表bohe_order_goods缺少product_id字段，找到升级的sql语句，执行一下