How to delete thread with 0 post

[skyyjet]

How can we delete threads that don't have any post in forum?

Actually my forum was spammed so IN PHPmyadmin I entered SPAM kewyords like uggs, wowgold, vigra etc and it searched and founded all those hundreds of posts which had those keywords and I deleted them all at once.

Now the problem is that many threads are still listed with their URL in forum but when you open them there is no post ie no content in tho se threads and also there is no method to delete.

I guess there must be some command that we can run in PHPmyadmin that could delete all threads with 0 post count?

Please help.

[Marco van Herwaarden]

First of all: NEVER DELETE RECORDS MANUALLY, unless you know 100% what you are doing.

Try running some of the update counters under Maintenance in the AdminCP:
- Remove Orphan Posts.
- Remove Orphan Threads
- REbuild Thread Information.

[skyyjet]

Thanks for the help..

Unfortunately this didn't worked.. Those thread urls are still there..

I believe this can be deleted only through phpmyadmin only.

[borbole]

Originally Posted by skyyjet

Thanks for the help..

Unfortunately this didn't worked.. Those thread urls are still there..

I believe this can be deleted only through phpmyadmin only.

Try to run the following query.

DELETE FROM thread WHERE replycount = 0;

If your db tables have a prefix you should include that as well in the query. ALso it would be best if you made first a backup of the thread table, just in case.