[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Savannah-cvs] [For administrators] (edit) zombie projects (+ markup)
From: |
Beuc |
Subject: |
[Savannah-cvs] [For administrators] (edit) zombie projects (+ markup) |
Date: |
Thu, 11 Dec 2008 19:38:41 +0000 |
??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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Savannah-cvs] [For administrators] (edit) zombie projects (+ markup),
Beuc <=