![](/theme/default/default/images/main/icon-menu.png)
一键安装包
597453
升级至20.1.1后,备份再windows一键安装,恢复报数据库错已解决
升级至20.1.1后,备份再windows一键安装,恢复报数据库错已解决
悬赏5积分
提问者英俊的香烟
答案数1
阅读数113
发表时间2024-07-09 15:18:46
数据库还原失败,错误:SQLSTATE[01000]: Warning: 1265 Data truncated for column 'left' at row 1 ,the sql is: 'INSERT INTO `zt_block`(`id`,`account`,`dashboard`,`module`,`code`,`width`,`height`,`left`,`top`,`title`,`params`,`hidden`,`vision`,`block`) VALUES ('1','admin','my','welcome','welcome','2','0','','0','欢迎',null,'0','rnd',''), ('2','admin','my','dynamic','dynamic','1','0','','0','最新动态',null,'0','rnd',''), ('6','admin','my','project','recentproject','2','0','','0','我近期参与的项目',null,'0','rnd',''), ('7','admin','my','assigntome','assigntome','2','0','','0','待处理','{\"count\":\"20\"}','0','rnd',''), ('9','','my','welcome','welcome','2','0','','0','欢迎',null,'0','rnd',''), ('10','','my','dynamic','dynamic','1','0','','0','最新动态',null,'0','rnd',''), ('14','','my','project','recentproject','2','0','','0','我近期参与的项目',null,'0','rnd',''), ('15','','my','assigntome','assigntome','2','0','','0','待处理','{\"count\":\"20\"}','0','rnd',''), ('17','admin','my','guide','guide','2','0','','0','使用帮助',null,'0','rnd',''), ('21','system','zentaopublicclass','2024-07-09','','1','0','','0','','[]','0','rnd',''), ('22','admin','qa','qa','statistic','2','0','','0','测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('23','admin','qa','qa','bug','1','0','','0','指派给我的Bug','{\"count\":15,\"orderBy\":\"id_desc\",\"type\":\"assignedTo\"}','0','rnd',''), ('24','admin','qa','qa','case','1','0','','0','指派给我的用例','{\"count\":15,\"orderBy\":\"id_desc\",\"type\":\"assigntome\"}','0','rnd',''), ('25','admin','qa','qa','testtask','2','0','','0','待测版本列表','{\"count\":15,\"orderBy\":\"id_desc\",\"type\":\"wait\"}','0','rnd',''); '
禅道版本:禅道开源版 20.1.1
安装包类型:Windows安装包
操作系统:Other
客户端浏览器:Chrome
答案列表
🍟 这个问题是在插入 zt_block 表数据时, left 的值不合法导致的(left 接受 0,1,2 ,但是传递的是 '')。 可以尝试以下方式修复,选其中一条即可 1,在执行这条语句前使用 set @@sql_mode=''; 2,在数据库文件中找到 zt_block 表的建表语句,就 left 的枚举值设置为 enum('0','1','2','') 3,设置将 insert 语句中的 left 对应的值,设置为 ‘0’
如果不能解决你的问题,可以联系官网商务QQ,邀请加入技术交流群沟通,即时性会更好一些。 感谢您的反馈,我们内部也记录 (内部反馈id:6297),让测试同时做更进一步的测试。
![]() |
联系我们
![](https://cdn.easycorp.cn/web/data/contact/avatar/2082428410.png)
联系人
张淑钧/高级客户经理
![](/theme/default/default/images/main/icon-contact-split.png)
电话(微信)
13156280939
![](/theme/default/default/images/main/icon-contact-split.png)
QQ号码
2082428410
![](/theme/default/default/images/main/icon-contact-split.png)
联系邮箱
zhangshujun@chandao.com
![](https://cdn.easycorp.cn/web/data/contact/13156280939.png)