禅道7.2版本升级到9.2.1
第一次升级失败,提示:
升级结果
升级失败
SQLSTATE[HY000]: General error: 1194 Table 'zt_file' is marked as crashed and should be repaired
The sql is:
ALTER TABLE `zt_file` ADD INDEX `file` (`objectType`, `objectID`), DROP INDEX `objectType`, DROP INDEX `objectID`
SQLSTATE[HY000]: General error: 1194 Table 'zt_file' is marked as crashed and
should be repaired
The sql is:
ALTER TABLE `zt_file` DROP INDEX `objectType`
SQLSTATE[HY000]: General error: 1194 Table 'zt_file' is marked as crashed and
should be repaired
The sql is:
ALTER TABLE `zt_file` DROP INDEX `objectID`
SQLSTATE[HY000]: General error: 1194 Table 'zt_file' is marked as crashed and
should be repaired
The sql is:
ALTER TABLE `zt_file` ADD INDEX `file` (`objectType`, `objectID`)
SQLSTATE[HY000]: General error: 1194 Table 'zt_file' is marked as crashed and
should be repaired
The sql is: ALTER TABLE `zt_file` CHANGE `size` `size` int unsigned NOT NULL DEFAULT '0' AFTER `extension`
还有第一次升级的问题应如何处理。
获取技术支持
石洋洋
2017/06/26
报错是数据库受损导致的,需要登录禅道数据库执行sql : repair table `zt_file`; 升级的时候根据提示创建相应的ok.txt 然后点击 继续更新 进行升级。
回复
2条回复
|