请专业的大侠帮助下-关于禅道BUG详情，为什么没有历史记录？-问答

我要提问

分类

禅道安装
禅道升级
- 一键安装包
- 源码包
禅道使用
- 地盘
- 项目集
- 产品
- 项目
- 执行
- 测试
- DevOps
- 文档
- 统计
- 组织
- 后台
- 通知功能
- 附件
- 导入导出
- 富文本编辑
- 搜索功能
- 客户端
- 数据备份
- 人员权限
- 其他
- 自动化测试
禅道扩展
企业版功能
旗舰版功能
- 资产库
- CMMI
禅道配置

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

禅道版本 8.2.4 源码包
操作系统 Windows 7
客户端浏览器 Chrome

提问者： 谢天顺 悬赏：5 日期： 2016-08-02 09:03:10 答案：1 点击：3813

获取技术支持

QQ：2679672214电话：17663982076

答案列表

石洋洋 2016/08/02

zentaopms/config/my.php 中debug的值改成true 重新操作一下看日志文件（zentaopms/tmp/log/php开头的今天的文件）有什么报错

回复 7条回复

谢天顺 2016/08/08

好的，谢谢

Cc 2016/12/16

我也遇到了一样的问题打开了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

石洋洋 2016/12/19

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

Cc 2016/12/20

@石洋洋执行了一下有报错如下：
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

石洋洋 2016/12/20

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

项锋 2017/04/21

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

石洋洋 2017/04/21

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