how to delete comment

[cajoe]

hi!

how do you delete a comment for a certain bug?

thanks!

Send instant messages to your online friends http://uk.messenger.yahoo.com

[Gregary Hendricks]

On Thu, 2008-02-28 at 14:50 -0800, cajoe wrote:
> hi!
>
> how do you delete a comment for a certain bug?
>

There is no supported mechanism for this in the tool itself. It requires
direct manipulation of the database. You may also try marking an
offending comment as private if you have an insidergroup set.

Greg

[xanad...@gmail.com]

That really needs to be a feature added.
Many times, a developer or QA dude (or Dudette) will enter a comment into a bug.

[Dave Miller]

[[ resisting the urge to make a comment about preventing developers and QA from communicating via Bugzilla ]]

This appears to be https://bugzilla.mozilla.org/show_bug.cgi?id=282657

Easy to implement, but appears mired in debate over the ethics behind the feature. When we have to delete a comment on bugzilla.mozilla.org we usually have a DBA go manually nuke it from the back end. That way it requires work to do it, and multiple people in on the decision to do so, and they're not just deleted on a whim. This is pretty much reserved for spam and users inadvertently posting personal information in public.
--
Dave Miller http://www.justdave.net/
IT Infrastructure Engineer, Mozilla http://www.mozilla.org/
Project Leader, Bugzilla Bug Tracking System http://www.bugzilla.org/

[baptiste...@gomoob.com]

If somebody searches how to delete a comment from the Bugzilla Database here is what I've done to do it :

- Connects to the Bugzilla Database

'mysql -u root -pxxxxxxxx bugzilla'

- Lists the comments attached to your bug

'select * from longdescs where bug_id = 338;'

- Delete the comment you want to delete using its identifier

'delete from longdescs where comment_id = 519;'

Hope this helps,

Baptiste

[Gervase Markham]

On 19/10/13 18:15, baptiste...@gomoob.com wrote:
> - Delete the comment you want to delete using its identifier
>
> 'delete from longdescs where comment_id = 519;'

This is not good; it will renumber the other comments. You are better
off doing:

update longdescs set thetext = "" where comment_id = 519;

Gerv