Bugzilla

Database Manipulation

Mark a bug closed

To mark a bug closed without having any notices go out, perform the following action in the database:

UPDATE bugs SET bug_status = 'CLOSED', resolution = 'FIXED' WHERE bug_id = #####;

This will set the bug status to closed without sending any emails or other notifications out to those who have references to the bug.

Edit a Comment

• First, find the comment ID:

SELECT bug_when, thetext, comment_id FROM longdescs WHERE bug_id = 68890;

• Next, update the bug with revised language for the specific bug ID:

update longdesc set thetext = "<TEXT HERE>" where comment_id = "COMMENTID";