Deleted user - now I need to delete all posts and threads!

[Racing Sim]

I know I have messed up and that I should have deleted the threads and posts before deleting the user but its too late - I feel so silly.

Do I have to run an SQL Query?

If so how do I delete all the deleted users posts and threads?


I am running vBulletin 3.6.1

[Jake Bunce]

See this thread.

There are also attachment, deletionlog, subscribethread, etc records to consider. This is all done automatically if you do it before deleting the user.

[Racing Sim]

Hey Jake thanks for responding.

Becasue I deleted the user beofore are you saying that I cant now remove all their posts and threads?

[Jake Bunce]

You can remove them with those queries, but it will leave some junk behind. It shouldn't affect anything.

[Racing Sim]

Just tried:

DELETE FROM post WHERE username='user';

And I get this:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'tommy_vBulletin.post' doesn't exist

[Jake Bunce]

You are probably using a table prefix. You need to change "post" to include that prefix.

[Racing Sim]

OK I added the prefix and get another error!

An error occurred while attempting to execute your query. The following information was returned.

error number: 1142

error desc: DELETE command denied to user: 'thumper@localhost' for table 'post'

[Steve Machol]

Your db user 'thumper' does not have full permissions to this database. You need to set those permissions. You cna do this through the MySQL section of cPanel if your host provides this.

[Racing Sim]

It says in my host admin cpannel: thumper (Privileges: ALL PRIVILEGES) for my VB database.


****** USERS WITH QUERY RUNNING PERMISSIONS ******
Also in my config.php I have myself listed as '1'

[Steve Machol]

Strange. If you have ALL permissions then I don't understand why this does not include DELETE.

I think I read that this is a server issue. You might want to try contacting your host.

[Racing Sim]

k Steve thanks for your help... I will keep you guys up to date ;-)

[Racing Sim]

I found out what I did wrong...


I typed a decimal incorrectly:


'tommy_vBulletin.post' - should have been 'tommy_vBulletinpost'


Also I had to rebuild the counters.


Thanks for your help guys.