fix invalid flags for attachments on bmo database

RESOLVED FIXED

Status

RESOLVED FIXED
6 years ago
4 years ago

People

(Reporter: glob, Assigned: fox2mike)

Tracking

Details

Attachments

(1 attachment)

(Reporter)

Description

6 years ago
Created attachment 691537 [details]
fix-invalid-flags.sql

bugzilla's sanity check reports:

Invalid flag 510653 for attachment 615722 [details] [diff] [review] in bug 746156.
Invalid flag 510979 for attachment 616074 [details] [diff] [review] in bug 746156.
Invalid flag 511284 for attachment 616482 [details] [diff] [review] in bug 746156.
Invalid flag 511519 for attachment 616777 [details] [diff] [review] in bug 746213.
Invalid flag 511842 for attachment 617102 [details] [diff] [review] in bug 747451.
Invalid flag 511854 for attachment 616975 [details] [diff] [review] in bug 746213.
Invalid flag 512567 for attachment 618053 [details] [diff] [review] in bug 748379.
Invalid flag 512899 for attachment 618485 [details] [diff] [review] in bug 748085.
Invalid flag 513157 for attachment 618756 [details] [diff] [review] in bug 732631.
Invalid flag 513172 for attachment 618772 [details] [diff] [review] in bug 707836.
Invalid flag 513213 for attachment 618751 [details] [diff] [review] in bug 729853.
Invalid flag 513255 for attachment 618850 [details] [diff] [review] in bug 707836.
Invalid flag 513429 for attachment 619074 [details] [diff] [review] in bug 707836.
Invalid flag 513908 for attachment 619649 [details] [diff] [review] in bug 749047.
Invalid flag 514073 for attachment 619828 [details] [diff] [review] in bug 747990.
Invalid flag 514362 for attachment 620203 [details] [diff] [review] in bug 750568.
Invalid flag 514497 for attachment 620371 [details] [diff] [review] in bug 750568.
Invalid flag 514587 for attachment 620475 [details] [diff] [review] in bug 751375.
Invalid flag 515729 for attachment 619829 [details] [diff] [review] in bug 747990.
Invalid flag 516590 for attachment 622838 [details] [diff] [review] in bug 748967.
Invalid flag 517643 for attachment 624134 [details] [diff] [review] in bug 749459.

these are all attachments with the generic 'review' flag instead of the firefox specific one.

please run the attached sql, which should fix this problem.
(Assignee)

Updated

6 years ago
Assignee: server-ops-database → shyam
(Assignee)

Comment 1

6 years ago
Done.

mysql> UPDATE flags
    ->    SET type_id=748
    ->  WHERE id IN (510653,510979,511284,511519,511842,511854,512567,512899,513157,513172,
    ->               513213,513255,513429,513908,514073,514362,514497,514587,515729,516590,517643)
    ->        AND type_id=4;
Query OK, 21 rows affected (0.00 sec)
Rows matched: 21  Changed: 21  Warnings: 0
Status: NEW → RESOLVED
Last Resolved: 6 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.