821051 - fix invalid flags for attachments on bmo database

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[:glob ✱]

Attachment: 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.

Comment 1

[Shyam Mani [:fox2mike]]

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