SQL Query to clear comments please

[NC Software]

As you have yet to provide a feature to disable comments, please provide a SQL Query I can run that removes ALL comments from my database please.

[eiden]

Have you tried disabling the comments in the code?
Deleting comments in batch

The comments are stored in the swcommentdata and swcomments tables.

[bear]

Had my answer done....board is still flipping back to the closed older version and I couldn't reply. Here is what I wrote:

Yes, it needs fixing so it's optional or locked to registered users. Meanwhile, just use PHPmyadmin to truncate two tables: `swcomments` and `swcommentdata`.

[AllureHost]

Originally Posted by NC Software

As you have yet to provide a feature to disable comments, please provide a SQL Query I can run that removes ALL comments from my database please.

This feature should have been added in 3.10. I am sorry but why was it not? Disable and comment pruner would have been great features and have been discussed multiple times on these forums and in feature tracker. Is there anyone willing to create a mod for this particular purpose. I would have a friend of mine make one, but I do not have an owned license :-(.

- John

[handsonweb]

Here's some SQL code for you, we run it every night;

DELETE FROM swcommentdata, swcomments USING swcommentdata, swcomments
WHERE swcomments.commentid = swcommentdata.commentid
AND
swcommentdata.contents like '%http%'
AND
swcomments.isapproved = 0

Basically the code above checks the COMMENTS section for any unapproved comments with an http link in them and if it does, it blows it out.

One of my staff memebers at Hands-on Web Hosting wrote the code for me - works like a charm.

[atDev]

Originally Posted by handsonweb

Here's some SQL code for you, we run it every night;

DELETE FROM swcommentdata, swcomments USING swcommentdata, swcomments
WHERE swcomments.commentid = swcommentdata.commentid
AND
swcommentdata.contents like '%http%'
AND
swcomments.isapproved = 0

Basically the code above checks the COMMENTS section for any unapproved comments with an http link in them and if it does, it blows it out.

One of my staff memebers at Hands-on Web Hosting wrote the code for me - works like a charm.

This still leaves the comments count the same.

[bear]

I made a post about how to disable comments completely:
Disabling comments and stopping comment spam

If you want them completely disabled as I did, this post's for you.

[tjbaker]

Originally Posted by atDev

This still leaves the comments count the same.

sorry... don't understand...what does that mean?

Does this query work or no, please?

I would really like to delete the 2000+ spam entries - and I really don't want to have to disable comments as I think it a nice feature....

[bear]

Originally Posted by tjbaker

sorry... don't understand...what does that mean?
Does this query work or no, please?

The query should remove the actual comments, but not the "counter" that says how many there are. I'd disabled mine completely, then truncated the comment spams, but it still shows me as having a few hundred comments, when there are definitely none.

[NC Software]

It's a shame Kayako can't build in a simple switch to disable comments! I'm sure their help desk has a gazillion of them, assuming they use Kayako!

[craigbrass]

I think it is planned for V4.