禅道12.1.stable 创建任务报错已解决 悬赏15积分
在创建任务后,点击保存,提示如下错误,但是任务创建成功了,并且不能自动跳转到任务首页
错误信息: <html><head><meta http-equiv='Content-Type' content='text/html; charset=utf-8' /></head><body><br /> 11:14:02 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 ('4')</p> in lib\base\dao\dao.class.php on line 1394, last called by lib\base\dao\dao.class.php on line 708 through function sqlError.<br /> in <strong>framework\base\router.class.php</strong> on line <strong>2224</strong> when visiting <strong>task-create-2--0</strong><br /> </body></html>parsererrorSyntaxError: Unexpected token < in JSON at position 0
禅道版本:12.0
安装包类型:Windows安装包
操作系统:Windows Server 2008
客户端浏览器:Chrome
石洋洋
2020/03/16
是升级过程有sql没有执行导致的,可以登录一下数据库(如何登录数据库:http://www.zentao.net/book/zentaopmshelp/76.html)执行一下sql:ALTER TABLE `zt_user` CHANGE `status` `clientStatus` enum('online', 'away', 'busy', 'offline') NOT NULL DEFAULT 'offline';
回复
|