升级为2.72正式版后,订单详情出现问题。请问如何处理?

2016-07-07 15:19 来源:www.chinab4c.com 作者: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 `zghzpc71`.`ecs_order_goods` AS o LEFT JOIN `zghzpc71`.`ecs_products` AS p ON p.product_id = o.product_id LEFT JOIN `zghzpc71`.`ecs_goods` AS g ON o.goods_id = g.goods_id LEFT JOIN `zghzpc71`.`ecs_brand` AS b ON g.brand_id = b.brand_id WHERE o.order_id = '376' ) [2] => Array ( [error] => Table 'zghzpc71.ecs_products' doesn't exist ) [3] => Array ( [errno] => 1146 ) )

回答:
表不存在 是否修改表结构 查看自己的表前缀是否正确