禅道php报错已解决悬赏5积分

提问者Cc 答案数1 阅读数3538 发表时间2016-12-20 13:55:46

打开禅道页面发现如下报错：

Warning: fopen(/opt/zbox/app/zentao/tmp/log/php.20161220.log.php): failed to open stream: Permission denied in /opt/zbox/app/zentao/framework/base/router.class.php on line 1977

由于之前禅道崩溃，然后将之后rsync备份的文件夹，整个拷贝过来以恢复，通过zbox start启动后发现如上报错

禅道版本：8.4.1

安装包类型：源码包

操作系统：CentOS

客户端浏览器：Chrome

备注

tmp/log/php.20161220.log.php内报错如下

00:18:47 ERROR: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '8957' for key 'PRIMARY'The sql is: INSERT INTO `zt_action` SET `objectType` = 'bug',`objectID` = '1791',`actor` = 'duerqiang',`action` = 'resolved',`date` = '2016-12-20 00:18:47',`comment` = '',`extra` = 'notrepro',`product` = ',9,',`project` = '0' 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-1791

-----------------------已经修复----------------------------

查明原因为自增列冲突

可以进入数据库使用以下语句

alter table zt_action AUTO_INCREMENT=9000;