672575 - Few add-ons are having more than 2 categories

Status: VERIFIED FIXED

(addons.mozilla.org Graveyard :: Public Pages, defect)

Description

[Sai Krishna]

STR:
1.Load https://addons.allizom.org/z/en-US/firefox/i/addon/pearltrees/
2.Observe the Related categories section

Observed Behavior:
The add-on contains 3 categories which is not allowed

Comment 1

[Jeff Balogh (:jbalogh)]

There are two with three categories. => fligtar for a decision.    

mysql> select addon_id, application_id, count(*) as c from addons_categories inner join categories on category_id=categories.id group by addon_id,application_id having c > 2;
    +----------+----------------+---+
    | addon_id | application_id | c |
    +----------+----------------+---+
    |    11255 |              1 | 3 |
    |    62825 |              1 | 3 |
    +----------+----------------+---+
    2 rows in set (6.99 sec)

Comment 2

[Justin Scott [:fligtar]]

Jorge, can you please clear out an extra category from these?

Comment 3

[Jorge Villalobos [:jorgev] (he/him)]

Done.

Comment 4

[Pratibha]

Attachment: postfix screenshot

verified the two given add-ons:
https://addons-dev.allizom.org/en-US/firefox/addon/pearltrees/
https://addons-dev.allizom.org/en-US/firefox/addon/google-bing-ask-qrobeit-for-fi/

Only 2 categories are present