1223528 - Add-ons should never be unlisted and inactive at the same time

Status: RESOLVED INCOMPLETE

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

Description

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

From bug 641864 comment #15, the Capture for JIRA add-on (https://addons.mozilla.org/developers/addon/capture-for-jira/versions) is stuck in an inconsistent state. It's both unlisted and inactive, which means it doesn't show up in the review queue and there's no way to correct its status.

It's possible that this happens when an inactive (hidden) add-on is switched to Unlisted, and the inactive flag isn't flipped, though that's just my best guess.

We should fix the cause of this inconsistency, but also correct the status of the affected add-ons. So far, it looks like there are only three:

576454
656164
663876

Comment 1

[Atlassian]

Hi Jorge,

Can someone please have a look on this. The issue blocking us from starting the next round of the review.
Thanks a lot!

--
Cheers,
Ignat.

Comment 2

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

Jason, can you please set inactive = 0 for add-ons with ID 576454, 656164, 663876?

Comment 3

[Jason Thomas [:jason]]

:magopian r?

UPDATE addons set inactive = 0 WHERE id IN (576454,656164,663876) ?

Comment 4

[Jason Thomas [:jason]]

MySQL [addons_mozilla_org]> UPDATE addons set inactive = 0 WHERE id IN (576454,656164,663876);
Query OK, 3 rows affected (0.02 sec)
Rows matched: 3  Changed: 3  Warnings: 0

Comment 5

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

@Ignat: I see your add-on in the queue now. It should be reviewed soon.

Comment 6

[Ignat Alexeyenko]

Jorge, Jason, thanks a lot! I can see the add-on in the queue.

Comment 7

[Mathieu Agopian [:magopian]]

Sorry for the late answer, yes Jason this looks good to me ;)