Closed
Bug 399655
Opened 17 years ago
Closed 17 years ago
Migrate existing AMO categories to new list
Categories
(addons.mozilla.org Graveyard :: Administration, defect)
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: baz, Assigned: fligtar)
References
()
Details
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.
Assignee | ||
Comment 1•17 years ago
|
||
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.
Assignee: nobody → fligtar
Assignee | ||
Updated•17 years ago
|
Status: NEW → ASSIGNED
Component: Add-ons → Administration
OS: Mac OS X → All
QA Contact: add-ons → administration
Hardware: PC → All
Assignee | ||
Comment 2•17 years ago
|
||
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)
Keywords: push-needed
Reporter | ||
Comment 3•17 years ago
|
||
Justin, this is awesome and so quick - thank you!
Reporter | ||
Comment 4•17 years ago
|
||
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 ?
Assignee | ||
Comment 5•17 years ago
|
||
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•17 years ago
|
||
Pushed with 400178
Updated•8 years ago
|
Product: addons.mozilla.org → addons.mozilla.org Graveyard
You need to log in
before you can comment on or make changes to this bug.
Description
•