标题: mantis统计报表报错 [打印本页] 作者: 追逐幸福 时间: 2010-7-17 11:54 标题: mantis统计报表报错 APPLICATION ERROR #401
数据库查询失败。数据库返回的错误信息是：#1194: Table 'mantis_bug_history_table' is marked as crashed and should be repaired 查询语句：SELECT COUNT(h.id) as count, b.id, b.summary, b.view_state
FROM mantis_bug_table AS b, mantis_bug_history_table AS h
WHERE h.bug_id = b.id
AND b.status < ?
AND project_id IN (7,1,6,16,17,3,14,4,13,2,5,11,15,9,8,10,12)
GROUP BY h.bug_id, b.id, b.summary, b.last_updated, b.view_state
ORDER BY count DESC, b.last_updated DESC