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

提问者Pssdouk 答案数1 阅读数335 发表时间2023-05-24 01:14:04

禅道版本：禅道开源版 18.3

安装包类型：Windows安装包

操作系统：Windows Server 2008

客户端浏览器：Chrome

备注

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

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

答案列表

🚢

王林 2023-05-24 16:31:18

可以看下xampp/mysql/目录下是否有什么报错日志吗？

1条回复

🎠

Pssdouk 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.

联系我们