399655 - Migrate existing AMO categories to new list

Status: RESOLVED FIXED

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

Description

[Basil Hashem [:baz]]

In support of AMO v3.2, the AMO Admin team decided that we should migrate the categories sooner than the release of AMO v3.2 (redesign). The URL above highlights exactly what the new categories are and the suggested migration.

Comment 1

[Justin Scott [:fligtar]]

All but one of the migrations can be done by just renaming the categories in the admin panel.

For the two eliminations, I would just rename Misc. to Other and then we can run SQL to change Site-specific to Other.

I'll work on this.

Comment 2

[Justin Scott [:fligtar]]

Categories renamed, but only for Firefox Extensions. The others (Firefox Themes, SeaMonkey Extensions, Thunderbird Themes, etc) are different and weren't touched.

The SQL for Site-specific -> Other is:

# Remove Site-specific from add-ons that have both site-specific and other to prevent duplicate entries
mysql> delete from addons_tags where tag_id=34 and addon_id in (827,959,3247,4039,4235,4286,4544,4724,4948,4977,4991,5095,5173,5185,5237,5310,5314,5374,5437,5487,5494,5526,5551,5552,5619,5709,5719,5733,5746,5771,5816);
Query OK, 31 rows affected (0.00 sec)

# Set Site-specific add-ons to Other
mysql> update addons_tags set tag_id=73 where tag_id=34;
Query OK, 841 rows affected (0.24 sec)
Rows matched: 841  Changed: 841  Warnings: 0

# Make sure all other Site-specific references are gone
mysql> delete from addons_tags where tag_id=34;
Query OK, 0 rows affected (0.00 sec)

# Delete Site-specific tag
mysql> delete from tags where id=34;
Query OK, 1 row affected (0.01 sec)

# Delete Site-specific name translations
mysql> delete from translations where id=1059;
Query OK, 21 rows affected (0.00 sec)

# Delete Site-specific description translations
mysql> delete from translations where id=1060;
Query OK, 20 rows affected (0.00 sec)

Comment 3

[Basil Hashem [:baz]]

Justin,

this is awesome and so quick - thank you!

Comment 4

[Basil Hashem [:baz]]

Has the SQL in comment 2 been run yet? I still see "Site Specific" in the categories list @ https://addons.mozilla.org/en-US/firefox/browse/type:1 ?

Comment 5

[Justin Scott [:fligtar]]

No - the push-needed keyword will be removed when it's been run. We haven't filed an update bug yet, but if this needs to be done soon I can.

Comment 6

[Wil Clouser [:clouserw]]

Pushed with 400178