后台订单无法查看,似乎是数据库的问题...

2016-07-07 15:23 来源：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 `lkokk_19920211`.`ecs_order_goods` AS o LEFT JOIN `lkokk_19920211`.`ecs_products` AS p ON p.product_id = o.product_id LEFT JOIN `lkokk_19920211`.`ecs_goods` AS g ON o.goods_id = g.goods_id LEFT JOIN `lkokk_19920211`.`ecs_brand` AS b ON g.brand_id = b.brand_id WHERE o.order_id = '4' ) [2] => Array ( [error] => Table 'lkong_19920211.ecs_products' doesn't exist ) [3] => Array ( [errno] => 1146 ) )

这怎改回来呢? 高手帮我解答吧,谢谢^^

回答：
你是不是没升级好？
数据库表不完善