I am running mantis at a hosted site.
I am getting the an 'out of memory' error when attempting to view bugs. The
error is as follows:
APPLICATION ERROR #401: ERROR: Database query failed.
(database_api.php: line 86)
Out of memory (Needed 8388580 bytes)
SELECT COUNT( DISTINCT ( mantis_bug_table.id ) ) as count FROM
mantis_bug_table, mantis_project_table WHERE mantis_project_table.enabled =
1 AND mantis_project_table.id = mantis_bug_table.project_id AND
(mantis_bug_table.project_id='3') AND (mantis_bug_table.status<>'90')
I don't know enough about mantis and MySQL to diagnosis this error.
I played around with the query and it succeeds if I remove the count()
I also tried adding some indexes to the columns that are in the where
I have only 4 projects and 16 bugs.
If it helps to diagnosis the problem, I can send you login info.
Parafora Software/Care Data Systems