CnPack Forum


 
Subject: '|ec_salt'| in '|field list'| ) 3 =&gt|1054数据库_511
cshiji003
新警察
Rank: 1



UID 346234
Digest Posts 0
Credits 8
Posts 2
点点分 8
Reading Access 10
Registered 2016-9-9
Status Offline
Post at 2016-9-23 20:37  Profile | Site | Blog | P.M. 
'|ec_salt'| in '|field list'| ) 3 =&gt|1054数据库_511

'ec_salt' in 'field list' ) [3] =>1054数据库
'ec_salt' in 'field list' ) [3] =>1054数据库
MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT `ec_salt` FROM `qdm0240194_db`.`jindong_admin_user`WHERE user_name = 'admin' ) [2] => Array ( [error] => Unknown column 'ec_salt' in 'field list' ) [3] => Array ( [errno] => 1054 ) )
出现报错原因程序是2.7.3而数据库是2.7.2,那么需要升级下数据库
在后台SQL查询或者在数据库管理面板最好有phpmyadmin管理工具里点击SQL查询

这样的查询区域查询以下语句:
-- `ecs_shipping`修改
ALTER TABLE `ecs_shipping` ADD `shipping_order` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0';
--`ecs_virtual_card`修改
ALTER TABLE `ecs_virtual_card` CHANGE `crc32` `crc32` VARCHAR( 12 )  NOT NULL DEFAULT '0';
--`ecs_users`修改
ALTER TABLE `ecs_users` ADD `ec_salt` VARCHAR( 10 )  NULL AFTER `salt` ;
--`ecs_admin_user`修改
ALTER TABLE `ecs_admin_user` ADD `ec_salt` VARCHAR( 10 ) NULL AFTER `user_name` ;
如果有类似于下图报错则不需要执行该语句
Top
 




All times are GMT++8, the time now is 2021-2-25 04:24

    本论坛支付平台由支付宝提供
携手打造安全诚信的交易社区 Powered by Discuz! 5.0.0  © 2001-2006 Comsenz Inc.
Processed in 0.009552 second(s), 7 queries , Gzip enabled

Clear Cookies - Contact Us - CnPack Website - Archiver - WAP