已解决 在用户使用过程中重启了禅道服务器,导致无法新创建项目

一个用户在创建项目过程中,服务器重启,导致该项目点击后会直接提示:

15:54:13 ERROR: SQLSTATE[HY000]: General error: 1032 Can't find record in 'zt_task'<p>The sql is: SELECT
SUM(estimate) AS totalEstimate,
SUM(consumed) AS totalConsumed,
SUM(`left`) AS totalLeft FROM `zt_task` wHeRe project = '14' AND status != 'cancel' AND deleted = '0' AND parent = '0'</p> in /home/wwwroot/default/lib/base/dao/dao.class.php on line 1392, last called by /home/wwwroot/default/lib/base/dao/dao.class.php on line 706 through function sqlError.
in  /home/wwwroot/default/framework/base/router.class.php  on line  2196  when visiting  project-task-14

在问题项目出现后,发现创建新项目都会报如下错误:

15:51:32 ERROR: SQLSTATE[HY000]: General error: 1032 Can't find record in 'zt_task'<p>The sql is: SELECT
SUM(estimate) AS totalEstimate,
SUM(consumed) AS totalConsumed,
SUM(`left`) AS totalLeft FROM `zt_task` wHeRe project = '14' AND status != 'cancel' AND deleted = '0' AND parent = '0'</p> in /home/wwwroot/default/lib/base/dao/dao.class.php on line 1392, last called by /home/wwwroot/default/lib/base/dao/dao.class.php on line 706 through function sqlError.
in  /home/wwwroot/default/framework/base/router.class.php  on line  2196  when visiting  project-create

不知是否可以通过服务器端手动删除掉那个问题项目来解决?

禅道版本 10.0 RPM包
操作系统 CentOS
客户端浏览器 Chrome

提问者: 李晋 悬赏: 5 日期: 2019-10-15 15:55:27 答案:1 点击:90
设置备注
答案列表
2019/10/15

可以访问数据库,看下zt_task表中有数据吗?查询提示什么?

2019/10/15
抱歉,因为事出紧急,临时决定还原会上一版的备份了。下次再遇到后试一下。