迭代-批量导入（报错）
2019-03-04 14:13:34
暗队长
|
你好，报错内容如下：
14:12:21 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 ('10')</p> in /app/zentaopms/lib/base/dao/dao.class.php on line 1394, last called by /app/zentaopms/lib/base/dao/dao.class.php on line 708 through function sqlError. in /app/zentaopms/framework/base/router.class.php on line 2215 when visiting task-batchCreate-7--0parsererrorSyntaxError: Unexpected token < in JSON at position 0 |
| 禅道-Bee |
现在的禅道版本是什么版本，有执行过升级操作吗？
|
暗队长
|
现在是11.3，原来是11.1，使用的是docker版本。有做过升级
|
| 禅道-Bee |
可以访问下数据库，执行下 select * from zt_config where `key` = "version"; 看下结果是什么？
|
暗队长
|
MariaDB [(none)]> use zentao
Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed MariaDB [zentao]> select * from zt_config where `key` = "version"; +-----+--------+--------+---------+---------+-------+ | id | owner | module | section | key | value | +-----+--------+--------+---------+---------+-------+ | 341 | system | common | global | version | 11.3 | +-----+--------+--------+---------+---------+-------+ 1 row in set (0.00 sec)
|
| 禅道-Bee |
ALTER TABLE `zt_user` CHANGE `status` `clientStatus` enum('online', 'away', 'busy', 'offline') NOT NULL DEFAULT 'offline';
数据库中执行下这段SQL，然后试试呢？ |
暗队长
|
执行完毕后已经恢复正常，非常感谢。
|
| 禅道-Bee |
 |
1/1
1
