从12.0升到了12.5.3后zt_user没有clientStatus列已解决悬赏5积分

提问者杨华茂答案数1 阅读数576 发表时间2021-06-24 09:19:12

从12.0正常升级到12.5.3，升级日志检查SQL都正常，但是在指派任务功能中出现界面卡死，后台日志显示：

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 |