Database Error after deleting a user

[thenags]

Originally Posted by Paul M

You do not need to delete posts belonging to a member, and thats not the issue.

This line in the query is completely wrong ;

AND userid NOT IN (usernameofdeleteduser)

First of all its expecting a userid, not a username, secondly, the name isnt escaped, so mysql thinks its a column name.

Looking that query up, it appears you have put their username in the "Send to Coventry" option rather than the userid.

You just nailed it. When I first went to delete the user I got a DB error and didn't think he was deleted. I then added him to global ignore. Later in the day I noticed he actually DID get deleted but now I had the DB errors. I just went and removed him from global ignore and all seems to be perfect again.

Thanks a ton for the help.