支付问题

2016-07-07 14:55 来源:www.chinab4c.com 作者:ecshop专家

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT s.shipping_id, s.shipping_code, s.shipping_name, s.shipping_desc, s.insure, s.support_cod, a.configure FROM `quanzhouecshop`.`ec037_shipping` AS s, `quanzhouecshop`.`ec037_shipping_area` AS a, `quanzhouecshop`.`ec037_area_region` AS r WHERE r.region_id IN ('1','6','79','716') AND r.shipping_area_id = a.shipping_area_id AND a.shipping_id = s.shipping_id AND s.enabled = 1 ORDER BY s.shipping_order ) [2] => Array ( [error] => Unknown column 's.shipping_order' in 'order clause' ) [3] => Array ( [errno] => 1054 ) )


点击结算的时候出现这一行不知道什么回事

菜鸟跪求大神解决!

回答:


ec037_shipping这个表里少一个字段 'shipping_order'

你应该是刚刚升级了ECSHOP,但是你只升级了程序,没有升级相应的数据库结构

2L OK。。。。。。。。。。

数据库错误