56,875
社区成员
发帖
与我相关
我的任务
分享ECSHOP安装登录后台就出现错误
下载的模板堂ECSHOP合集版，安装登录后台就出现错误，这个怎么解决？我登录数据库选择全部数据库表，执行修复也没有用。
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT SUM(money_paid) AS sales FROM `t`.`ecs_order_info` WHERE `add_time` BETWEEN 1456070400 AND 1456156799 AND supplier_id=0 AND order_status IN ('1','5','6') ) [2] => Array ( [error] => Unknown column 'supplier_id' in 'where clause' ) [3] => Array ( [errno] => 1054 ) )
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT SUM(money_paid) AS sales FROM `t`.`ecs_order_info` WHERE `add_time` BETWEEN 1456070400 AND 1456156799 AND supplier_id=0 AND order_status IN ('1','5','6') ) [2] => Array ( [error] => Unknown column 'supplier_id' in 'where clause' ) [3] => Array ( [errno] => 1054 ) )
...全文
请发表友善的回复…
发表回复
ACMAIN_CHM 2016-02-26
- 打赏
- 举报
Unknown column 'supplier_id' i
LongRui888 2016-02-26
- 打赏
- 举报
报的错误是：
[error] => Unknown column 'supplier_id' in 'where clause' ) [3] => Array ( [errno] => 1054 )
应该是少了字段，或者字段名称写错了导致的
ygctv 2016-02-22
- 打赏
- 举报
已经解决了，缺少字段，sql执行下面代码就好了
ALTER TABLE `ecs_order_info` ADD `supplier_id` INT( 10 ) NOT NULL DEFAULT 0;
ALTER TABLE `ecs_order_info` ADD `froms` CHAR( 10 ) NOT NULL DEFAULT 'pc' COMMENT 'pc:电脑,mobile:手机,app:应用';
