[Savannah-cvs] [For administrators] (edit) zombie projects (+ markup)

[Beuc]

??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/address@hidden://savannah.gnu.org/maintenance