请专业的大侠帮助下-关于禅道BUG详情，为什么没有历史记录？已解决 悬赏5积分

好的，谢谢

我也遇到了一样的问题 打开了debug好像是mysql有重复主键 不知道怎么处理？之前磁盘满过之后清理了然后重启，是否于此有关？
20:52:14 ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8957' for key 'PRIMARY'The sql is: INSERT INTO `zt_action` SET `objectType` = 'bug',`objectID` = '1788',`actor` = 'admin',`action` = 'resolved',`date` = '2016-12-16 20:52:14',`comment` = '',`extra` = 'bydesign',`product` = ',1,',`project` = '1' in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1301, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 759 through function sqlError.
in /opt/zbox/app/zentao/framework/base/router.class.php on line 1919 when visiting bug-resolve-1788

20:52:30 ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8957' for key 'PRIMARY'The sql is: INSERT INTO `zt_action` SET `objectType` = 'bug',`objectID` = '1788',`actor` = 'admin',`action` = 'closed',`date` = '2016-12-16 20:52:30',`comment` = '',`extra` = '',`product` = ',1,',`project` = '1' in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1301, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 759 through function sqlError.
in /opt/zbox/app/zentao/framework/base/router.class.php on line 1919 when visiting bug-close-1788

20:53:31 ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8957' for key 'PRIMARY'The sql is: INSERT INTO `zt_action` SET `objectType` = 'bug',`objectID` = '1788',`actor` = 'admin',`action` = 'deleted',`date` = '2016-12-16 20:53:31',`comment` = '',`extra` = '1',`product` = ',1,',`project` = '1' in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1301, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 759 through function sqlError.
in /opt/zbox/app/zentao/framework/base/router.class.php on line 1919 when visiting bug-delete-1788-yes

@Cc：登录数据库执行sql：REPAIR TABLE `zt_action`;

@石洋洋 执行了一下有报错 如下：
mysql> REPAIR TABLE `zt_action`;
+------------------+--------+----------+---------------------------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
+------------------+--------+----------+---------------------------------------------------------------------------------------------+
| zentao.zt_action | repair | error | 1 when fixing table |
| zentao.zt_action | repair | Error | Can't change ownership of the file '/opt/zbox/data/mysql/zentao/zt_action.MYD' (Errcode: 1) |
| zentao.zt_action | repair | status | Operation failed |
+------------------+--------+----------+---------------------------------------------------------------------------------------------+
3 rows in set (0.15 sec)
重启后登录禅道有如下动态：
10:59:06 ERROR: SQLSTATE[HY000]: General error: 144 Table './zentao/zt_action' is marked as crashed and last (automatic?) repair failed

The sql is: SELECT * FROM `zt_action` wHeRe 1 AND date > '2016-12-20' AND date < '2016-12-21' AND (1) oRdEr bY `date` desc,`id` desc
in /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 1301, last called by /opt/zbox/app/zentao/lib/base/dao/dao.class.php on line 386 through function sqlError.
in /opt/zbox/app/zentao/framework/base/router.class.php on line 1919 when visiting company-dynamic

加QQ: 1492153927，他会邀请加入禅道官方QQ群，在群里提问一下。

请问@Cc你这个问题是怎么解决的？

@项锋：加QQ: 1492153927，他会邀请加入禅道官方QQ群，在群里提问一下。