??changed:
-<b>Pinged message:</b>
-<br><br>
Pinged message
==============
++added:
Zombie projects
===============
When projects are removed from the tracker but not from the database, they stay
there and increase the "pending projects" frontpage statistics.
To find such projects, a good heuristic is::
SELECT bug_id, unix_group_name FROM groups, task WHERE groups.status='P' AND
task.summary LIKE CONCAT("Submission of ", groups.group_name) AND
task.status_id=3
It only fails if the task summary or group name was changed after the
submission.
A better solution would be to add a 'task_id' field in the 'groups' table,
filled in at registration time.
--
forwarded from
https://savannah.gnu.org/maintenance/foradministrators#msg20081211193841+0...@https://savannah.gnu.org/maintenance
_______________________________________________
Savannah-cvs mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/savannah-cvs
