Difference between revisions of "Bugzilla"
Jump to navigation
Jump to search
(Created page with "==Database Manipulation== ===Mark a bug closed=== To mark a bug closed without having any notices go out, perform the following action in the database: <pre> UPDATE bugs SET b...") |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 3: | Line 3: | ||
To mark a bug closed without having any notices go out, perform the following action in the database: | To mark a bug closed without having any notices go out, perform the following action in the database: | ||
<pre> | <pre> | ||
| − | UPDATE bugs SET bug_status = 'CLOSED' WHERE bug_id = #####; | + | UPDATE bugs SET bug_status = 'CLOSED', resolution = 'FIXED' WHERE bug_id = #####; |
</pre> | </pre> | ||
This will set the bug status to closed without sending any emails or other notifications out to those who have references to the bug. | 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: | ||
| + | <pre> | ||
| + | SELECT bug_when, thetext, comment_id FROM longdescs WHERE bug_id = 68890; | ||
| + | </pre> | ||
| + | * Next, update the bug with revised language for the specific bug ID: | ||
| + | <pre> | ||
| + | update longdesc set thetext = "<TEXT HERE>" where comment_id = "COMMENTID"; | ||
| + | </pre> | ||
Latest revision as of 08:42, 1 November 2024
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";
