764382 - please fix bugs with malformed utf-8 characters

Status: RESOLVED FIXED

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

Description

[:glob ✱]

the following bugs have malformed utf-8 characters and require fixing:

bug 39501
bug 764295
bug 279078

thanks!

Comment 1

[Shyam Mani [:fox2mike]]

What exactly is the fix? (Sorry, haven't done this before).

Comment 2

[:glob ✱]

you need to edit the comment and remove the invalid character.
i believe justdave uses mysql workbench to edit the blob.
(you may have notes about this from 2012-05-21 regarding bug 756947).

Comment 3

[Dave Miller [:justdave]]

Preferably done by a DBA because it's raw data editing...

Comment 4

[Sheeri Cabral [:sheeri]]

I took a stab at this, but the bugs_fulltext table, comments and comments_noprivate fields, are not the problem. (now I have to go to breakfast, then to a meeting with most likely no internet... :(

Comment 5

[Sheeri Cabral [:sheeri]]

Taking for triage purposes, but I'm asking justdave for help to figure out what table I need to look at.

Comment 6

[Sheeri Cabral [:sheeri]]

longdescs table.

Comment 7

[Dave Miller [:justdave]]

If you look at the bugs listed above, 99% of the time it'll be the last comment on the bug, because someone had a buggy browser and Bugzilla didn't catch it during the submit.  And once that comment was there, everyone's locked out of the bug until it's fixed.

Comment 8

[Sheeri Cabral [:sheeri]]

fixed bug 764295. That bug had malformed UTF-8 in the text because someone copy/pasted the exact error string, which had / followed by x00 a lot. I changed the text to get rid of the /.

Comment 9

[Sheeri Cabral [:sheeri]]

fixed https://bugzilla.mozilla.org/show_bug.cgi?id=39501

Comment 10

[Sheeri Cabral [:sheeri]]

fixed https://bugzilla.mozilla.org/show_bug.cgi?id=279078