从12.0升到了12.5.3后zt_user没有clientStatus列已解决 悬赏5积分
17:29:03 ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'clientStatus' in 'field list' <p>The sql is: SELECT id, account, realname, avatar, role, dept, clientStatus, gender, email, mobile, phone, qq, deleted FROM `zt_user` wHeRe 1 AND id IN ('162','9','119','63')</p> in /zentaoalm/lib/base/dao/dao.class.php on line 1381, request: http://www.pansoft.com/zentao/index.php, last called by /zentaoalm/lib/base/dao/dao.class.php on line 699 through function sqlError.
in /zentaoalm/framework/base/router.class.php on line 2235 when visiting /zentao/index.php?m=bug&f=assignTo&bugID=13525&onlybody=yes
17:30:49 ERROR: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'clientStatus' in 'field list' <p>The sql is: SELECT id, account, realname, avatar, role, dept, clientStatus, gender, email, mobile, phone, qq, deleted FROM `zt_user` wHeRe 1 AND id IN ('147')</p> in /zentaoalm/lib/base/dao/dao.class.php on line 1381, request: http://www.pansoft.com/zentao/index.php, last called by /zentaoalm/lib/base/dao/dao.class.php on line 699 through function sqlError.
in /zentaoalm/framework/base/router.class.php on line 2235 when visiting /zentao/index.php?m=bug&f=create&productID=14&branch=0&extra=moduleID=608
=============================================
| zt_user | CREATE TABLE `zt_user` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`dept` mediumint(8) unsigned NOT NULL DEFAULT 0,
`account` char(30) NOT NULL DEFAULT '',
`type` char(30) NOT NULL DEFAULT 'inside',
`password` char(32) NOT NULL DEFAULT '',
`realname` varchar(100) NOT NULL DEFAULT '',
`role` char(10) NOT NULL DEFAULT '',
`nickname` char(60) NOT NULL DEFAULT '',
`commiter` varchar(100) NOT NULL,
`avatar` char(30) NOT NULL DEFAULT '',
`birthday` date NOT NULL DEFAULT '0000-00-00',
`gender` enum('f','m') NOT NULL DEFAULT 'f',
`email` char(90) NOT NULL DEFAULT '',
`skype` char(90) NOT NULL,
`qq` char(20) NOT NULL DEFAULT '',
`yahoo` char(90) NOT NULL DEFAULT '',
`gtalk` char(90) NOT NULL DEFAULT '',
`wangwang` char(90) NOT NULL DEFAULT '',
`mobile` char(11) NOT NULL DEFAULT '',
`phone` char(20) NOT NULL DEFAULT '',
`weixin` varchar(90) NOT NULL,
`dingding` varchar(90) NOT NULL,
`slack` varchar(90) NOT NULL,
`whatsapp` varchar(90) NOT NULL,
`address` char(120) NOT NULL DEFAULT '',
`zipcode` char(10) NOT NULL DEFAULT '',
`join` date NOT NULL DEFAULT '0000-00-00',
`visits` mediumint(8) unsigned NOT NULL DEFAULT 0,
`ip` char(15) NOT NULL DEFAULT '',
`last` int(10) unsigned NOT NULL DEFAULT 0,
`fails` tinyint(5) NOT NULL DEFAULT 0,
`locked` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ranzhi` char(30) NOT NULL DEFAULT '',
`score` int(11) NOT NULL DEFAULT 0,
`scoreLevel` int(11) NOT NULL DEFAULT 0,
`deleted` enum('0','1') NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `account` (`account`),
KEY `dept` (`dept`),
KEY `email` (`email`),
KEY `commiter` (`commiter`),
KEY `deleted` (`deleted`)
) ENGINE=MyISAM AUTO_INCREMENT=411 DEFAULT CHARSET=utf8 |
禅道版本:12.5.3
安装包类型:源码包
操作系统:CentOS
客户端浏览器:Opera
禅道-李锡碧
2021-06-24 10:47:32
应该还是升级的问题,可以还原下备份,重新升级下试试。升级后,不要再执行还原操作了。
回复
|