293927 - IDs with null version.URI

Status: RESOLVED FIXED

(addons.mozilla.org Graveyard :: Administration, defect)

Description

[Colin Ogilvie [:cso]]

<alanjstr> Colin: do me a favor.  file a bug and list any extensions that show
up like ID=707 does.  the easiest way is to run a query in your sandbox.  do a
left join between main and version where uri is null

mysql> SELECT main.id from main left join version on main.id=version.id where
version.uri is null;
+-----+
| id  |
+-----+
|   3 |
| 218 |
| 331 |
| 233 |
| 276 |
| 372 |
| 407 |
| 430 |
| 579 |
| 606 |
| 654 |
| 656 |
| 659 |
| 707 |
| 714 |
+-----+
15 rows in set (0.01 sec)

Comment 1

[alanjstr]

Please delete these from main.

Comment 2

[Dave Miller [:justdave]]

There are legal reasons for URI to be NULL, however, I gather what you're really
looking for here are entries where there is an extension or theme defined with
no versions.  So what we really want to look for is rows with vID being NULL on
that left join.

mysql> delete main from main left join version on main.id=version.id where
version.vID is null;
Query OK, 18 rows affected (0.05 sec)

Comment 3

[Dave Miller [:justdave]]

For the record, the matched rows were:

+-----+-----------------------+------+------+
| id  | name                  | vID  | URI  |
+-----+-----------------------+------+------+
|   3 | Mostly Crystal        | NULL | NULL |
| 218 | Noia-Cute Ver 1.4.4   | NULL | NULL |
| 233 | 3iemPost              | NULL | NULL |
| 276 | I'm Feeling Lucky     | NULL | NULL |
| 331 | Flash Click to View   | NULL | NULL |
| 372 | Rot13 Encoder/Decoder | NULL | NULL |
| 407 | bioFOX                | NULL | NULL |
| 430 | What is a cookie?     | NULL | NULL |
| 579 | Signature             | NULL | NULL |
| 606 | Copy Links            | NULL | NULL |
| 654 | BBCodeXtra            | NULL | NULL |
| 656 | View Rendered Source  | NULL | NULL |
| 659 | gtafcode              | NULL | NULL |
| 685 | AIMfire               | NULL | NULL |
| 707 | BBCode                | NULL | NULL |
| 714 | Morning Coffee        | NULL | NULL |
| 729 | BBCode                | NULL | NULL |
| 730 | BBCode                | NULL | NULL |
+-----+-----------------------+------+------+
18 rows in set (0.01 sec)