the following bugs have malformed utf-8 characters and require fixing: bug 39501 bug 764295 bug 279078 thanks!
What exactly is the fix? (Sorry, haven't done this before).
Assignee: server-ops-devservices → shyam
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).
Preferably done by a DBA because it's raw data editing...
Assignee: shyam → server-ops-database
Component: Server Operations: Developer Services → Server Operations: Database
QA Contact: shyam → cshields
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... :(
Taking for triage purposes, but I'm asking justdave for help to figure out what table I need to look at.
Assignee: server-ops-database → scabral
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.
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 /.
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.