Need to remove all threads, posts and users

[Joe Blow]

I have an unused forum that I hadn't checked in a while. It now has thousands of spam users and threads.

How do I completely remove all the threads, and all the users (except admin) on the forum quickly and easily?

 

[Ramses]

Got the same, thousand users and posts...

 

[Joe Blow]

So can someone please tell me how to do this?

 

[Digital Doctor]

Maybe Jake has some magic phpmyadmin commands.

 

[Jake Bunce]

See manual cleanup:

http://xenforo.com/community/resources/dealing-with-forum-spam.980/

 

[Mendo]

Ugh. I was hoping there was an easy way to wipe the whole forum. This looks like a LOT of work doing it manually.

 

[Ramses]

You could do it via phpMyAdmin, removed ~ 900 accounts and ~ 3000 threads in a few seconds from the tables without running a query.

 

[Mendo]

You could do it via phpMyAdmin, removed ~ 900 accounts and ~ 3000 threads in a few seconds from the tables without running a query.

I tried that but I keep getting errors when trying to import and keep the topic numbers the same. It gives me something about duplicate entry error.

 

[Jake Bunce]

I tried that but I keep getting errors when trying to import and keep the topic numbers the same. It gives me something about duplicate entry error.

If you use that import option (to preserve source ids) then it must be a brand new installation with no content or you will get duplicate key errors.

Doing physical deletes with queries is problematic because there are many joined tables involved, and if your deletion isn't complete then you will still get duplicate key errors due to orphaned records that you failed to delete.

 

[Mendo]

Yeah it'd be nice if it told me what table was giving the dupe error.

 

[melbo]

If I were in your situation, I'd start from scratch with a fresh install. No need to preserve accounts of any Admins who let the forum get to that state anyway, right?

 

[Mendo]

If I were in your situation, I'd start from scratch with a fresh install. No need to preserve accounts of any Admins who let the forum get to that state anyway, right?

I think he meant admin as original admin account. And this would be a very handy feature if you want to keep all your usergroups permissions and template edits and whatnot.

 

[duderuud]

I remember Brogan posted a command to delete all content (for the import option Jake mentioned)

 

[Jake Bunce]

I remember Brogan posted a command to delete all content (for the import option Jake mentioned)

It has been done:

http://xenforo.com/community/threads/import-question-second-import-over-old-one.16663/#post-311819

But it's a dirty thing to do and may cause problems later.

 

[odingalt]

This is the reason I am ditching xenforo and going back to vbulletni.

 

[Jake Bunce]

New since this thread:

http://xenforo.com/community/threads/1-1-4-anti-spam-improvements-for-registration.45829/
http://xenforo.com/community/threads/spam-prevention-and-management.51091/