已解决 新增用户 NO RESPONSE
组织新增用户,输入完全部信息,提交报NO RESPONSE。之前没遇到已经添加20个用户了。
禅道版本 17.5 源码包
操作系统 Ubuntu
客户端浏览器 Chrome

提问者:悬赏:5 日期: 2023-05-04 15:09:29 答案:1 点击:518

获取技术支持

QQ: 电话:
设置备注
答案列表
2023/05/04
在禅道服务器上,代码目录zentao(ep/pro/pms)/config/my.php 中debug的值改成true  重新操作一下 看日志文件 zentao(ep/pro/pms)/tmp/log/php开头的今天的文件有什么报错。
2023/05/04
16:26:41 ERROR: SQLSTATE[22003]: Numeric value out of range: 167 Out of range value for column 'id' at row 1 <p>The sql is: INSERT INTO `zt_user` SET `type` = 'inside',`company` = '0',`dept` = '4',`account` = 'Test123',`visions` = 'rnd',`realname` = 'Test123',`join` = '2023-05-04',`role` = 'td',`email` = '',`commiter` = 'admin',`gender` = 'm',`password` = '68eacb97d86f0c4621fa2b0e17cabd8c'</p> in lib/base/dao/dao.class.php on line 1381, last called by lib/base/dao/dao.class.php on line 761 through function sqlError.

in framework/base/router.class.php on line 2728 when visiting user-create-0?tid=6mx6svxc

parsererrorSyntaxError: Unexpected token '<', "
2023/05/04
这是什么原因。Numeric value out of range: 167 Out of range value for column 'id' at row 1
2023/05/04
之前容器安装的
2023/05/04
看提示是插入的数据id这个字段值长度超出了限制长度,方便登录禅道数据库,看下zt_user表的表结构发一下吗?
另外,可以添加下页面上方QQ,邀请进群后截图下相关问题,方便沟通。
2023/05/04
ZT_USER的ID字段,类型我看了也没问题啊。长度为8
类 型:mediumint
长 度:8
占用字节:3字节
有 符 号:-8388608~8388607
无 符 号:0~16777215
不指定长度时的长度为:9(实际长度还是8)
2023/05/04
MariaDB [zentao]> desc zt_user;
+--------------+--------------------------------------------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------------------------------------------+------+-----+---------------------+----------------+
| id | mediumint(8) unsigned | NO | PRI | NULL | auto_increment |
| company | mediumint(8) unsigned | NO | | NULL | |
| type | char(30) | NO | | inside | |
| dept | mediumint(8) unsigned | NO | MUL | 0 | |
| account | char(30) | NO | UNI | | |
| password | char(32) | NO | | | |
| role | char(10) | NO | | | |
| realname | varchar(100) | NO | | | |
| pinyin | varchar(255) | NO | | | |
| nickname | char(60) | NO | | | |
| commiter | varchar(100) | NO | MUL | NULL | |
| avatar | text | NO | | NULL | |
| birthday | date | NO | | 0000-00-00 | |
| gender | enum('f','m') | NO | | f | |
| email | char(90) | NO | MUL | | |
| skype | char(90) | NO | | | |
| qq | char(20) | NO | | | |
| mobile | char(11) | NO | | | |
| phone | char(20) | NO | | | |
| weixin | varchar(90) | NO | | | |
| dingding | varchar(90) | NO | | | |
| slack | varchar(90) | NO | | | |
| whatsapp | varchar(90) | NO | | | |
| address | char(120) | NO | | | |
| zipcode | char(10) | NO | | | |
| nature | text | NO | | NULL | |
| analysis | text | NO | | NULL | |
| strategy | text | NO | | NULL | |
| join | date | NO | | 0000-00-00 | |
| visits | mediumint(8) unsigned | NO | | 0 | |
| visions | varchar(20) | NO | | rnd,lite | |
| ip | char(15) | NO | | | |
| last | int(10) unsigned | NO | | 0 | |
| fails | tinyint(5) | NO | | 0 | |
| locked | datetime | NO | | 0000-00-00 00:00:00 | |
| feedback | enum('0','1') | NO | | 0 | |
| ranzhi | char(30) | NO | | | |
| ldap | char(30) | NO | | NULL | |
| score | int(11) | NO | | 0 | |
| scoreLevel | int(11) | NO | | 0 | |
| resetToken | varchar(50) | NO | | NULL | |
| deleted | enum('0','1') | NO | MUL | 0 | |
| clientStatus | enum('online','away','busy','offline','meeting') | NO | | offline | |
| clientLang | varchar(10) | NO | | zh-cn | |
+--------------+--------------------------------------------------+------+-----+---------------------+----------------+
44 rows in set (0.00 sec)
2023/05/04
MariaDB [zentao]> select id from zt_user;
+----+
| id |
+----+
| 1 |
| 4 |
| 5 |
| 6 |
| 7 |
| 8 |
| 9 |
| 11 |
| 12 |
| 13 |
| 14 |
| 15 |
| 16 |
| 17 |
| 18 |
| 19 |
| 20 |
| 21 |
| 22 |
| 23 |
| 24 |
| 25 |
| 2 |
| 3 |
| 10 |
+----+
25 rows in set (0.00 sec)
2023/05/04
方便的话可以添加下页面上方QQ,邀请进群后咨询下问题呢
2023/06/01
如何解决的 能发出相应的步骤或者结果吗?
2023/06/01
这个错误是表示当前ID列的最大长度已经超过了mediumint字段类型允许的最大长度,导致的原因可能是数据库在insert数据时,ID赋值超出了长度范围,对应的解决方案是,先确认目前数据库中zt_user表中的ID最大值是多少,通过手动指定ID列的开始长度,ALTER TABLE zt_user AUTO_INCREMENT = XXX; 注意操作前做好数据表备份。
2023/06/01
使用这个ALTER TABLE zt_user AUTO_INCREMENT = XXX;修改还是不行