新增用户 NO RESPONSE已解决 悬赏5积分

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 '<', "

这是什么原因。Numeric value out of range: 167 Out of range value for column 'id' at row 1

之前容器安装的

看提示是插入的数据id这个字段值长度超出了限制长度，方便登录禅道数据库，看下zt_user表的表结构发一下吗？
另外，可以添加下页面上方QQ，邀请进群后截图下相关问题，方便沟通。

ZT_USER的ID字段，类型我看了也没问题啊。长度为8
类 型：mediumint
长 度：8
占用字节：3字节
有 符 号：-8388608~8388607
无 符 号：0~16777215
不指定长度时的长度为：9(实际长度还是8)

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)

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)

方便的话可以添加下页面上方QQ，邀请进群后咨询下问题呢

如何解决的 能发出相应的步骤或者结果吗?

这个错误是表示当前ID列的最大长度已经超过了mediumint字段类型允许的最大长度，导致的原因可能是数据库在insert数据时，ID赋值超出了长度范围，对应的解决方案是，先确认目前数据库中zt_user表中的ID最大值是多少，通过手动指定ID列的开始长度，ALTER TABLE zt_user AUTO_INCREMENT = XXX; 注意操作前做好数据表备份。

使用这个ALTER TABLE zt_user AUTO_INCREMENT = XXX;修改还是不行