Re: [Savannah-hackers-public] savannah statistics

[Sylvain Beucler]

On Thu, Dec 11, 2008 at 07:38:10PM +0100, Sylvain Beucler wrote:
> On Wed, Dec 10, 2008 at 08:22:06PM -0500, Nicodemo Alvaro wrote:
> > >From the Savannah front page, I find there are + 171 registrations
> > pending. I took a look at the pending tasks in Savannah Administration
> > and found that there are 127 tasks pending not all of them are
> > registration submissions. I am curious if are there extra submissions
> > that I am not seeing.
> 
> This means that a few projects were closed in the tracker, but not
> closing in the system.
> 
> We'll have to search for them in the database :)

Instead of manually checking, I went ahead and coded the SQL query
that does it for us:

mysql> 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;
+--------+------------------+
| bug_id | unix_group_name  |
+--------+------------------+
|   7107 | shrigamdha       | 
|   7432 | gpagescholar     | 
|   7922 | cia              | 
|   7932 | lilisp           | 
|   8089 | bal              | 
|   8154 | testplan         | 
|   8190 | nxhtml           | 
|   8191 | ocelote          | 
|   8192 | loadebackup      | 
|   8353 | sptg             | 
|   8218 | ophtagnu         | 
|   8220 | extendedutils    | 
|   8221 | extutils         | 
|   8237 | resampler57      | 
|   8238 | shelagh          | 
|   8248 | phasis           | 
|   8255 | dbused           | 
|   8257 | fjmss            | 
|   8267 | opensmskummee    | 
|   8267 | osmskummeeplugin | 
|   8275 | wann             | 
|   8301 | libv3d           | 
|   8354 | kidle            | 
|   8355 | jabuticaba       | 
|   8357 | audioerp         | 
|   8377 | sexpreader       | 
|   8382 | nvsts            | 
|   8394 | key-manager      | 
|   8399 | gmatch           | 
|   8402 | snake            | 
|   8408 | smartres         | 
|   8410 | extendedutils    | 
|   8419 | pds              | 
|   8434 | ssug-ponnani     | 
|   8449 | usrmgnt          | 
|   8455 | jarhunt          | 
|   8462 | vertex           | 
|   8486 | simplerowlog     | 
|   8493 | abclp            | 
|   8496 | freeacc          | 
|   8510 | pyunit2          | 
|   8520 | grafer           | 
|   8524 | fastcgipp        | 
|   8558 | rpgnu            | 
|   8564 | mathlib          | 
|   8580 | rpgnu            | 
|   8581 | taz              | 
|   8582 | tte              | 
|   8591 | hamexam          | 
|   8594 | wmfcs            | 
|   8596 | facturier        | 
|   8598 | doc              | 
|   8600 | alterapciechdma  | 
|   8602 | dircproxy        | 
|   8610 | sysres           | 
|   8612 | facturier        | 
|   8648 | lpices           | 
|   8660 | noteland         | 
|   8686 | nachos-g2        | 
|   8692 | lse              | 
|   8733 | parserplayground | 
|   8742 | dawn             | 
|   8746 | sparwe           | 
|   8747 | britain          | 
|   8781 | libexcept        | 
|   8802 | datasheetviewer  | 
|   8852 | hexcer           | 
|   8903 | mogreaudio       | 
+--------+------------------+
68 rows in set (0.00 sec)


Do you think this is correct?

If yes I'll automatically remove all these projects.

-- 
Sylvain