94374
迭代-批量导入(报错)
回帖数 7
阅读数 1967
发表时间 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
7个回复
可以访问下数据库,执行下 select * from zt_config where `key` = "version"; 看下结果是什么?
2019-03-04 18:13:35 禅道-李锡碧 回帖
7个回复
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)
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)
2019-03-05 13:59:39 暗队长 回帖
7个回复
ALTER TABLE `zt_user` CHANGE `status` `clientStatus` enum('online', 'away', 'busy', 'offline') NOT NULL DEFAULT 'offline'; 数据库中执行下这段SQL,然后试试呢? 2019-03-05 14:10:17 禅道-李锡碧 回帖
联系我们
联系人
魏中显/高级客户经理
电话(微信)
18561939726
QQ号码
1746749398
联系邮箱
weizhongxian@chandao.com

相关帖子
李大善人李大恶人 | 最后回帖 2019-02-11 18:06 qq_5c60f1a2ecb96
任敏 | 最后回帖 2019-07-15 13:13 石洋洋
杜磊 | 最后回帖 2018-10-29 11:18 石洋洋
分享是一种力量 | 最后回帖 2017-12-22 09:16 石洋洋
范杰 | 最后回帖 2020-03-17 08:20 禅道-李锡碧
胜果科技-郭辉 | 最后回帖 2024-07-29 17:54 孔令茂
禅道-Bee

精品资料包
1V1产品演示
免费试用增强功能
专属顾问答疑支持


