禅道使用
596618
添加用户时报错已解决 悬赏5积分
提问者李飞
答案数1
阅读数347
发表时间2023-07-27 00:16:38
添加用户时报如下错误,请问怎么解决?
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` = '0',`account` = 'ceshi',`visions` = 'rnd',`realname` = 'ceshi',`join` = '2023-07-27',`role` = '',`email` = '',`commiter` = '',`gender` = 'm',`password` = '47b8b781e12201826cfea1039c6b8452'</p> in lib/base/dao/dao.class.php on line 1412, last called by lib/base/dao/dao.class.php on line 792 through function sqlError.
in framework/base/router.class.php on line 2797 when visiting user-create-0
parsererrorSyntaxError: Unexpected token '<', "
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` = '0',`account` = 'ceshi',`visions` = 'rnd',`realname` = 'ceshi',`join` = '2023-07-27',`role` = '',`email` = '',`commiter` = '',`gender` = 'm',`password` = '47b8b781e12201826cfea1039c6b8452'</p> in lib/base/dao/dao.class.php on line 1412, last called by lib/base/dao/dao.class.php on line 792 through function sqlError.
in framework/base/router.class.php on line 2797 when visiting user-create-0
parsererrorSyntaxError: Unexpected token '<', "
禅道版本:禅道开源版 18.5
安装包类型:Linux安装包
操作系统:CentOS
客户端浏览器:Chrome
答案列表
禅道-阿龙
2023-07-27 15:32:56
可以检查下数据库中zt_user表id的最大值是多少,如果最大值没有满足字段类型的最大值,可以执行sql 修改自增列的取值,重新操作试试 ALTER TABLE id AUTO_INCREMENT = xxx(目前最大的id+1);
回复
|
联系我们
联系人
杨苗/高级客户经理
电话(微信)
13165050229
QQ号码
2692096539
联系邮箱
yangmiao@chandao.com