2.60升级2.70出错!求解

2016-07-07 15:39 来源:www.chinab4c.com 作者:ecshop专家

MySQL server error report:Array ( [0] => Array ( [message] => MySQL Query Error ) [1] => Array ( [sql] => SELECT userid, adminid, user_name, user_rank, discount, email, data, expiry FROM `ecshop`.`ecs_sessions` WHERE sesskey = 'b230c6f711ba477534c4ff19b1f154db' ) [2] => Array ( [error] => Unknown column 'user_name' in 'field list' ) [3] => Array ( [errno] => 1054 ) )

2.60升级2.70出错!
求解!谢谢了
按照官方步骤来的
UC为1.0版本

回答:
这个问题还是等版主解答吧!

可以登录后台吗?可以的话在SQL查询里执行以下语句,不能登录后台就用phpmyadmin。
DROP TABLE IF EXISTS `ecs_sessions`;
CREATE TABLE `ecs_sessions` (
`sesskey` char(32) binary NOT NULL default '',
`expiry` int(10) unsigned NOT NULL default '0',
`userid` mediumint(8) unsigned NOT NULL default '0',
`adminid` mediumint(8) unsigned NOT NULL default '0',
`ip` char(15) NOT NULL default '',
`user_name` varchar(60) NOT NULL,
`user_rank` tinyint(3) NOT NULL,
`discount` decimal(3,2) NOT NULL,
`email` varchar(60) NOT NULL,
`data` char(255) NOT NULL default '',
PRIMARY KEY(`sesskey`),
KEY `expiry` (`expiry`)
) TYPE=HEAP;