已解决 禅道更新为InnoDB后报错,关闭卸载服务后无法再次启动mysqlzt,更换端口后也无法启动

禅道版本 18.3 Windows安装包
操作系统 Windows Server 2008
客户端浏览器 Chrome

提问者: Pssdouk 悬赏:15 日期: 2023-05-24 01:14:04 答案:1 点击:210

获取技术支持

QQ: 电话:
备注

下方启动端口失败的报错通过mysql官网的解决方式删除了xampp\mysql\data\zentao 目录下的*.idb文件,再次卸载服务可以启动成功



图一(上方)是登录禅道时产生的报错,更新为innodb提示表在引擎中不存在


设置备注
答案列表
2023/05/24
可以看下xampp/mysql/目录下是否有什么报错日志吗?
2023/05/24
已添加在备注中,图片好像上传失败了,我把部分内容贴在下面了:
2023-05-24 16:34:27 8088 [Warning] InnoDB: Cannot open table zentao/zt_config from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-05-24 16:34:42 7456 [Warning] InnoDB: Cannot open table zentao/zt_config from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-05-24 16:34:42 8088 [Warning] InnoDB: Cannot open table zentao/zt_config from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-05-24 16:35:04 1668 [ERROR] feedback plugin: ssl failed for url 'https://mariadb.org/feedback_plugin/post' unknown error number
2023-05-24 16:35:27 8088 [Warning] InnoDB: Cannot open table zentao/zt_config from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-05-24 16:35:42 7456 [Warning] InnoDB: Cannot open table zentao/zt_config from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-05-24 16:36:05 1668 [ERROR] feedback plugin: ssl failed for url 'https://mariadb.org/feedback_plugin/post' unknown error number
2023-05-24 16:37:05 1668 [ERROR] feedback plugin: ssl failed for url 'https://mariadb.org/feedback_plugin/post' unknown error number
2023-05-24 16:37:25 2736 [Warning] InnoDB: Cannot open table zentao/zt_config from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-05-24 16:37:46 2736 [Warning] InnoDB: Cannot open table zentao/zt_config from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.