禅道升级
597848

20.1.1升级至20.7后,再通过全新安装20.7并恢复,提示数据库还原失败已解决 悬赏5积分

提问者英俊的香烟 答案数2 阅读数183 发表时间2024-09-27 17:40:20

20.1.1升级至20.7后,再通过全新安装20.7并恢复备份文件,提示数据库还原失败

数据库还原失败,错误: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',''), ('26','admin','doc','doc','docstatistic','2','3','0','0','文档统计',null,'0','rnd',''), ('27','admin','doc','doc','docmycollection','2','4','0','3','我收藏的文档',null,'0','rnd',''), ('28','admin','doc','doc','docrecentupdate','2','4','0','7','最近更新的文档',null,'0','rnd',''), ('29','admin','doc','doc','productdoc','2','6','0','11','产品文档','{\"count\":\"20\"}','0','rnd',''), ('30','admin','doc','doc','projectdoc','2','6','0','17','项目文档','{\"count\":\"20\"}','0','rnd',''), ('31','admin','doc','doc','docdynamic','1','8','2','0','文档动态',null,'0','rnd',''), ('32','admin','doc','doc','docviewlist','1','5','2','8','浏览排行榜',null,'0','rnd',''), ('33','admin','doc','doc','doccollectlist','1','5','2','13','收藏排行榜',null,'0','rnd',''), ('34','xinjia','my','welcome','welcome','2','3','0','0','欢迎总览',null,'0','rnd',''), ('35','xinjia','my','guide','guide','2','6','0','3','使用帮助',null,'0','rnd',''), ('36','xinjia','my','assigntome','assigntome','2','6','0','9','我的待处理','{\"todoCount\":\"20\",\"taskCount\":\"20\",\"bugCount\":\"20\",\"riskCount\":\"20\",\"issueCount\":\"20\",\"storyCount\":\"20\",\"reviewCount\":\"20\",\"meetingCount\":\"20\",\"feedbackCount\":\"20\"}','0','rnd',''), ('37','xinjia','my','project','recentproject','2','4','0','15','我近期参与的项目',null,'0','rnd',''), ('38','xinjia','my','project','project','2','6','0','19','未完成的项目列表','{\"type\":\"undone\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('39','xinjia','my','execution','statistic','2','5','0','25','未完成的执行统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('40','xinjia','my','project','statistic','2','5','0','30','未完成的项目统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('41','xinjia','my','product','statistic','2','5','0','35','未关闭的产品统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('42','xinjia','my','qa','statistic','2','5','0','40','未关闭产品的测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('43','xinjia','my','zentaodynamic','zentaodynamic','1','4','2','0','禅道动态',null,'0','rnd',''), ('44','xinjia','my','dynamic','dynamic','1','8','2','4','最新动态',null,'0','rnd',''), ('45','xinjia','my','teamachievement','teamachievement','1','6','2','12','团队成就',null,'0','rnd',''), ('46','xinjia','my','product','overview','1','3','2','18','产品总览',null,'0','rnd',''), ('47','xinjia','my','project','overview','1','3','2','21','项目总览',null,'0','rnd',''), ('48','xinjia','my','execution','overview','1','3','2','24','执行总览',null,'0','rnd',''), ('49','renbing','my','welcome','welcome','2','3','0','45','欢迎总览',null,'0','rnd',''), ('50','renbing','my','guide','guide','2','6','0','48','使用帮助',null,'0','rnd',''), ('51','renbing','my','assigntome','assigntome','2','6','0','54','我的待处理','{\"todoCount\":\"20\",\"taskCount\":\"20\",\"bugCount\":\"20\",\"riskCount\":\"20\",\"issueCount\":\"20\",\"storyCount\":\"20\",\"reviewCount\":\"20\",\"meetingCount\":\"20\",\"feedbackCount\":\"20\"}','0','rnd',''), ('52','renbing','my','project','recentproject','2','4','0','60','我近期参与的项目',null,'0','rnd',''), ('53','renbing','my','project','project','2','6','0','64','未完成的项目列表','{\"type\":\"undone\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('54','renbing','my','execution','statistic','2','5','0','70','未完成的执行统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('55','renbing','my','project','statistic','2','5','0','75','未完成的项目统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('56','renbing','my','product','statistic','2','5','0','80','未关闭的产品统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('57','renbing','my','qa','statistic','2','5','0','85','未关闭产品的测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('58','renbing','my','zentaodynamic','zentaodynamic','1','4','2','27','禅道动态',null,'0','rnd',''), ('59','renbing','my','dynamic','dynamic','1','8','2','31','最新动态',null,'0','rnd',''), ('60','renbing','my','teamachievement','teamachievement','1','6','2','39','团队成就',null,'0','rnd',''), ('61','renbing','my','product','overview','1','3','2','45','产品总览',null,'0','rnd',''), ('62','renbing','my','project','overview','1','3','2','48','项目总览',null,'0','rnd',''), ('63','renbing','my','execution','overview','1','3','2','51','执行总览',null,'0','rnd',''), ('64','admin','my','welcome','welcome','2','3','0','0','欢迎总览',null,'0','lite',''), ('65','admin','my','guide','guide','2','6','0','3','使用帮助',null,'0','lite',''), ('66','admin','my','assigntome','assigntome','2','6','0','9','我的待处理','{\"todoCount\":\"20\",\"taskCount\":\"20\",\"bugCount\":\"20\",\"riskCount\":\"20\",\"issueCount\":\"20\",\"storyCount\":\"20\",\"reviewCount\":\"20\",\"meetingCount\":\"20\",\"feedbackCount\":\"20\"}','0','lite',''), ('67','admin','my','project','recentproject','2','4','0','15','我近期参与的项目',null,'0','lite',''), ('68','admin','my','project','project','2','6','0','19','未完成的项目列表','{\"type\":\"undone\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','lite',''), ('69','admin','my','execution','statistic','2','5','0','25','未完成的项目看板统计','{\"type\":\"undone\",\"count\":\"20\"}','0','lite',''), ('70','admin','my','project','statistic','2','5','0','30','未完成的项目统计','{\"type\":\"undone\",\"count\":\"20\"}','0','lite',''), ('71','admin','my','product','statistic','2','5','0','35','未关闭的产品统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','lite',''), ('72','admin','my','qa','statistic','2','5','0','40','未关闭产品的测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','lite',''), ('73','admin','my','zentaodynamic','zentaodynamic','1','4','2','0','禅道动态',null,'0','lite',''), ('74','admin','my','dynamic','dynamic','1','8','2','4','最新动态',null,'0','lite',''), ('75','admin','my','teamachievement','teamachievement','1','6','2','12','团队成就',null,'0','lite',''), ('76','admin','my','product','overview','1','3','2','18','产品总览',null,'0','lite',''), ('77','admin','my','project','overview','1','3','2','21','项目总览',null,'0','lite',''), ('78','admin','my','execution','overview','1','3','2','24','项目看板总览',null,'0','lite',''), ('79','admin','my','execution','scrumlist','2','3','0','45','看板列表','{\"type\":\"doing\",\"orderBy\":\"id_desc\",\"count\":\"15\"}','0','lite',''), ('80','lxj01','my','welcome','welcome','2','3','0','90','欢迎总览',null,'0','rnd',''), ('81','lxj01','my','guide','guide','2','6','0','93','使用帮助',null,'0','rnd',''), ('82','lxj01','my','assigntome','assigntome','2','6','0','99','我的待处理','{\"todoCount\":\"20\",\"taskCount\":\"20\",\"bugCount\":\"20\",\"riskCount\":\"20\",\"issueCount\":\"20\",\"storyCount\":\"20\",\"reviewCount\":\"20\",\"meetingCount\":\"20\",\"feedbackCount\":\"20\"}','0','rnd',''), ('83','lxj01','my','project','recentproject','2','4','0','105','我近期参与的项目',null,'0','rnd',''), ('84','lxj01','my','project','project','2','6','0','109','未完成的项目列表','{\"type\":\"undone\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('85','lxj01','my','execution','statistic','2','5','0','115','未完成的执行统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('86','lxj01','my','project','statistic','2','5','0','120','未完成的项目统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('87','lxj01','my','product','statistic','2','5','0','125','未关闭的产品统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('88','lxj01','my','qa','statistic','2','5','0','130','未关闭产品的测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('89','lxj01','my','zentaodynamic','zentaodynamic','1','4','2','54','禅道动态',null,'0','rnd',''), ('90','lxj01','my','dynamic','dynamic','1','8','2','58','最新动态',null,'0','rnd',''), ('91','lxj01','my','teamachievement','teamachievement','1','6','2','66','团队成就',null,'0','rnd',''), ('92','lxj01','my','product','overview','1','3','2','72','产品总览',null,'0','rnd',''), ('93','lxj01','my','project','overview','1','3','2','75','项目总览',null,'0','rnd',''), ('94','lxj01','my','execution','overview','1','3','2','78','执行总览',null,'0','rnd',''), ('95','lxj01','qa','qa','statistic','2','5','0','0','测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('96','lxj01','qa','qa','testtask','2','6','0','5','待测测试单列表','{\"type\":\"wait\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('97','lxj01','qa','qa','bug','1','6','2','0','指派给我的Bug列表','{\"type\":\"assignedTo\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('98','lxj01','qa','qa','case','1','6','2','6','指派给我的用例列表','{\"type\":\"assigntome\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('99','zwk','my','welcome','welcome','2','3','0','135','欢迎总览',null,'0','rnd',''), ('100','zwk','my','guide','guide','2','6','0','138','使用帮助',null,'0','rnd',''), ('101','zwk','my','assigntome','assigntome','2','6','0','144','我的待处理','{\"todoCount\":\"20\",\"taskCount\":\"20\",\"bugCount\":\"20\",\"riskCount\":\"20\",\"issueCount\":\"20\",\"storyCount\":\"20\",\"reviewCount\":\"20\",\"meetingCount\":\"20\",\"feedbackCount\":\"20\"}','0','rnd',''), ('102','zwk','my','project','recentproject','2','4','0','150','我近期参与的项目',null,'0','rnd',''), ('103','zwk','my','project','project','2','6','0','154','未完成的项目列表','{\"type\":\"undone\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('104','zwk','my','execution','statistic','2','5','0','160','未完成的执行统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('105','zwk','my','project','statistic','2','5','0','165','未完成的项目统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('106','zwk','my','product','statistic','2','5','0','170','未关闭的产品统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('107','zwk','my','qa','statistic','2','5','0','175','未关闭产品的测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('108','zwk','my','zentaodynamic','zentaodynamic','1','4','2','81','禅道动态',null,'0','rnd',''), ('109','zwk','my','dynamic','dynamic','1','8','2','85','最新动态',null,'0','rnd',''), ('110','zwk','my','teamachievement','teamachievement','1','6','2','93','团队成就',null,'0','rnd',''), ('111','zwk','my','product','overview','1','3','2','99','产品总览',null,'0','rnd',''), ('112','zwk','my','project','overview','1','3','2','102','项目总览',null,'0','rnd',''), ('113','zwk','my','execution','overview','1','3','2','105','执行总览',null,'0','rnd',''), ('114','zwk','qa','qa','statistic','2','5','0','11','测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('115','zwk','qa','qa','testtask','2','6','0','16','待测测试单列表','{\"type\":\"wait\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('116','zwk','qa','qa','bug','1','6','2','12','指派给我的Bug列表','{\"type\":\"assignedTo\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('117','zwk','qa','qa','case','1','6','2','18','指派给我的用例列表','{\"type\":\"assigntome\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('118','renbing','singleproduct','singleproduct','singlestatistic','2','5','0','0','产品统计','{\"count\":\"20\"}','0','rnd',''), ('119','renbing','singleproduct','singleproduct','singlebugstatistic','2','5','0','5','产品的Bug统计','{\"count\":\"20\"}','0','rnd',''), ('120','renbing','singleproduct','singleproduct','roadmap','2','6','0','10','产品路线图',null,'0','rnd',''), ('121','renbing','singleproduct','singleproduct','singlestory','2','6','0','16','指派给我的研发需求','{\"type\":\"assignedTo\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('122','renbing','singleproduct','singleproduct','singleplan','2','6','0','22','产品计划列表','{\"count\":\"20\"}','0','rnd',''), ('123','renbing','singleproduct','singleproduct','singlerelease','2','6','0','28','产品发布统计','{\"count\":\"20\"}','0','rnd',''), ('124','renbing','singleproduct','singleproduct','singledynamic','1','8','2','0','最新动态',null,'0','rnd',''), ('125','renbing','singleproduct','singleproduct','singlemonthlyprogress','1','15','2','8','产品月度推进分析',null,'0','rnd',''), ('126','renbing','qa','qa','statistic','2','5','0','22','测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('127','renbing','qa','qa','testtask','2','6','0','27','待测测试单列表','{\"type\":\"wait\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('128','renbing','qa','qa','bug','1','6','2','24','指派给我的Bug列表','{\"type\":\"assignedTo\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('129','renbing','qa','qa','case','1','6','2','30','指派给我的用例列表','{\"type\":\"assigntome\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('130','renbing','doc','doc','docstatistic','2','3','0','23','文档统计',null,'0','rnd',''), ('131','renbing','doc','doc','docmycollection','2','4','0','26','我收藏的文档',null,'0','rnd',''), ('132','renbing','doc','doc','docrecentupdate','2','4','0','30','最近更新的文档',null,'0','rnd',''), ('133','renbing','doc','doc','productdoc','2','6','0','34','产品文档','{\"count\":\"20\"}','0','rnd',''), ('134','renbing','doc','doc','projectdoc','2','6','0','40','项目文档','{\"count\":\"20\"}','0','rnd',''), ('135','renbing','doc','doc','docdynamic','1','8','2','18','文档动态',null,'0','rnd',''), ('136','renbing','doc','doc','docviewlist','1','5','2','26','浏览排行榜',null,'0','rnd',''), ('137','renbing','doc','doc','doccollectlist','1','5','2','31','收藏排行榜',null,'0','rnd',''), ('138','xinjia','qa','qa','statistic','2','5','0','33','测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('139','xinjia','qa','qa','testtask','2','6','0','38','待测测试单列表','{\"type\":\"wait\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('140','xinjia','qa','qa','bug','1','6','2','36','指派给我的Bug列表','{\"type\":\"assignedTo\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('141','xinjia','qa','qa','case','1','6','2','42','指派给我的用例列表','{\"type\":\"assigntome\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('142','admin','singleproduct','singleproduct','singlestatistic','2','5','0','34','产品统计','{\"count\":\"20\"}','0','rnd',''), ('143','admin','singleproduct','singleproduct','singlebugstatistic','2','5','0','39','产品的Bug统计','{\"count\":\"20\"}','0','rnd',''), ('144','admin','singleproduct','singleproduct','roadmap','2','6','0','44','产品路线图',null,'0','rnd',''), ('145','admin','singleproduct','singleproduct','singlestory','2','6','0','50','指派给我的研发需求','{\"type\":\"assignedTo\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('146','admin','singleproduct','singleproduct','singleplan','2','6','0','56','产品计划列表','{\"count\":\"20\"}','0','rnd',''), ('147','admin','singleproduct','singleproduct','singlerelease','2','6','0','62','产品发布统计','{\"count\":\"20\"}','0','rnd',''), ('148','admin','singleproduct','singleproduct','singledynamic','1','8','2','23','最新动态',null,'0','rnd',''), ('149','admin','singleproduct','singleproduct','singlemonthlyprogress','1','15','2','31','产品月度推进分析',null,'0','rnd',''), ('150','xxc','my','welcome','welcome','2','3','0','180','欢迎总览',null,'0','rnd',''), ('151','xxc','my','guide','guide','2','6','0','183','使用帮助',null,'0','rnd',''), ('152','xxc','my','assigntome','assigntome','2','6','0','189','我的待处理','{\"todoCount\":\"20\",\"taskCount\":\"20\",\"bugCount\":\"20\",\"riskCount\":\"20\",\"issueCount\":\"20\",\"storyCount\":\"20\",\"reviewCount\":\"20\",\"meetingCount\":\"20\",\"feedbackCount\":\"20\"}','0','rnd',''), ('153','xxc','my','project','recentproject','2','4','0','195','我近期参与的项目',null,'0','rnd',''), ('154','xxc','my','project','project','2','6','0','199','未完成的项目列表','{\"type\":\"undone\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('155','xxc','my','execution','statistic','2','5','0','205','未完成的执行统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('156','xxc','my','project','statistic','2','5','0','210','未完成的项目统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('157','xxc','my','product','statistic','2','5','0','215','未关闭的产品统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('158','xxc','my','qa','statistic','2','5','0','220','未关闭产品的测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('159','xxc','my','zentaodynamic','zentaodynamic','1','4','2','108','禅道动态',null,'0','rnd',''), ('160','xxc','my','dynamic','dynamic','1','8','2','112','最新动态',null,'0','rnd',''), ('161','xxc','my','teamachievement','teamachievement','1','6','2','120','团队成就',null,'0','rnd',''), ('162','xxc','my','product','overview','1','3','2','126','产品总览',null,'0','rnd',''), ('163','xxc','my','project','overview','1','3','2','129','项目总览',null,'0','rnd',''), ('164','xxc','my','execution','overview','1','3','2','132','执行总览',null,'0','rnd',''), ('165','liuhan','my','welcome','welcome','2','3','0','225','欢迎总览',null,'0','rnd',''), ('166','liuhan','my','guide','guide','2','6','0','228','使用帮助',null,'0','rnd',''), ('167','liuhan','my','assigntome','assigntome','2','6','0','234','我的待处理','{\"todoCount\":\"20\",\"taskCount\":\"20\",\"bugCount\":\"20\",\"riskCount\":\"20\",\"issueCount\":\"20\",\"storyCount\":\"20\",\"reviewCount\":\"20\",\"meetingCount\":\"20\",\"feedbackCount\":\"20\"}','0','rnd',''), ('168','liuhan','my','project','recentproject','2','4','0','240','我近期参与的项目',null,'0','rnd',''), ('169','liuhan','my','project','project','2','6','0','244','未完成的项目列表','{\"type\":\"undone\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('170','liuhan','my','execution','statistic','2','5','0','250','未完成的执行统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('171','liuhan','my','project','statistic','2','5','0','255','未完成的项目统计','{\"type\":\"undone\",\"count\":\"20\"}','0','rnd',''), ('172','liuhan','my','product','statistic','2','5','0','260','未关闭的产品统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('173','liuhan','my','qa','statistic','2','5','0','265','未关闭产品的测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('174','liuhan','my','zentaodynamic','zentaodynamic','1','4','2','135','禅道动态',null,'0','rnd',''), ('175','liuhan','my','dynamic','dynamic','1','8','2','139','最新动态',null,'0','rnd',''), ('176','liuhan','my','teamachievement','teamachievement','1','6','2','147','团队成就',null,'0','rnd',''), ('177','liuhan','my','product','overview','1','3','2','153','产品总览',null,'0','rnd',''), ('178','liuhan','my','project','overview','1','3','2','156','项目总览',null,'0','rnd',''), ('179','liuhan','my','execution','overview','1','3','2','159','执行总览',null,'0','rnd',''), ('180','liuhan','qa','qa','statistic','2','5','0','44','测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','rnd',''), ('181','liuhan','qa','qa','testtask','2','6','0','49','待测测试单列表','{\"type\":\"wait\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('182','liuhan','qa','qa','bug','1','6','2','48','指派给我的Bug列表','{\"type\":\"assignedTo\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('183','liuhan','qa','qa','case','1','6','2','54','指派给我的用例列表','{\"type\":\"assigntome\",\"count\":\"15\",\"orderBy\":\"id_desc\"}','0','rnd',''), ('184','renbing','my','welcome','welcome','2','3','0','48','欢迎总览',null,'0','lite',''), ('185','renbing','my','guide','guide','2','6','0','51','使用帮助',null,'0','lite',''), ('186','renbing','my','assigntome','assigntome','2','6','0','57','我的待处理','{\"todoCount\":\"20\",\"taskCount\":\"20\",\"bugCount\":\"20\",\"riskCount\":\"20\",\"issueCount\":\"20\",\"storyCount\":\"20\",\"reviewCount\":\"20\",\"meetingCount\":\"20\",\"feedbackCount\":\"20\"}','0','lite',''), ('187','renbing','my','project','recentproject','2','4','0','63','我近期参与的项目',null,'0','lite',''), ('188','renbing','my','project','project','2','6','0','67','未完成的项目列表','{\"type\":\"undone\",\"count\":\"20\",\"orderBy\":\"id_desc\"}','0','lite',''), ('189','renbing','my','execution','statistic','2','5','0','73','未完成的项目看板统计','{\"type\":\"undone\",\"count\":\"20\"}','0','lite',''), ('190','renbing','my','project','statistic','2','5','0','78','未完成的项目统计','{\"type\":\"undone\",\"count\":\"20\"}','0','lite',''), ('191','renbing','my','product','statistic','2','5','0','83','未关闭的产品统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','lite',''), ('192','renbing','my','qa','statistic','2','5','0','88','未关闭产品的测试统计','{\"type\":\"noclosed\",\"count\":\"20\"}','0','lite',''), ('193','renbing','my','zentaodynamic','zentaodynamic','1','4','2','27','禅道动态',null,'0','lite',''), ('194','renbing','my','dynamic','dynamic','1','8','2','31','最新动态',null,'0','lite',''), ('195','renbing','my','teamachievement','teamachievement','1','6','2','39','团队成就',null,'0','lite',''), ('196','renbing','my','product','overview','1','3','2','45','产品总览',null,'0','lite',''), ('197','renbing','my','project','overview','1','3','2','48','项目总览',null,'0','lite',''), ('198','renbing','my','execution','overview','1','3','2','51','项目看板总览',null,'0','lite',''), ('199','renbing','my','execution','scrumlist','2','3','0','93','看板列表','{\"type\":\"doing\",\"orderBy\":\"id_desc\",\"count\":\"15\"}','0','lite',''); '

禅道版本:禅道开源版 20.1.1

安装包类型:Windows安装包

操作系统:Windows Server 2008

客户端浏览器:Chrome

设置备注
内容
答案列表
2024-09-29 08:20:48

您好,可以尝试在老的禅道数据库中手动导出一份SQL文件,然后登录新安装的禅道数据库中导入看下。

🍨
2024-09-30 15:07:17

把备份文件SQL导出,单独刷数据库脚本,zt_block 的 left width 等枚举字段,增加空枚举再刷就可以了,应该还有一个product表同样报错

2024/10/08
目前问题是否已经解决?需要我们协助处理的话欢迎再次联系我们:)
联系我们
联系人
刘金莲/高级客户经理
电话(微信)
17685742391
QQ号码
3784249187
联系邮箱
liujinlian@chandao.com
返回顶部
刘金莲
高级客户经理
17685742391
3784249187
统一服务热线 4006-8899-23
我要提问提问有任何问题,您都可以在这里提问。 问题反馈反馈点击这里,让我们聆听您的建议与反馈。