Question

ECshop商城程序进入我的订单，出现数据库代码

ECshop商城程序进入我的订单，出现这段代码，数据库哪方便有问题？MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT order_id, order_sn, order_status, shipping_status, pay_status, add_time, (goods_amount + shipping_fee + insure_fee + pay_fee + pack_fee + card_fee + tax - discount) AS total_fee FROM `ntmnxcrijv_yj`.`lense_order_info_old` WHERE user_id = '38978' ORDER BY add_time DESC LIMIT 10 ) [2] => Array ( [error] => Table 'ntmnxcrijv_yj.lense_order_info_old' doesn't exist ) [3] => Array ( [errno] => 1146 ) )

Answer 1

Table 'ntmnxcrijv_yj.lense_order_info_old' doesn't exist 这个表不存在。你检查下sql。

Answer 2

lense_order_info_old 这玩意不存在 是视图吗

Answer 3

EC是不是升级过或者修改过代码？