Problem with a deleted User and his postings

[ROTPAR]

Hi,

I have user on my board who wished to delete his account because his name was visible to everybody. Ok, so I deleted the user...the problem is, that all his postings still remain in the boards...the even worse problem is, now his status is Guest but you can still see his username bellow the "Guest" what is a big problem right now.

Is there any solution?

[ForceHSS]

You should of deleted his posts first or why did you not just rename his account name so it would remove his real name
As to the posts in admincp/threads & posts/prune
You can use this option

[ROTPAR]

You are right and it makes sense, but it's too late for that next time i will be smarter but right now I need a solution for the current problem

[Simon Lloyd]

In phpmyadmin run this

PHP Code:

DELETE FROM `post` WHERE `username`="DELETED GUEST NAME HERE" 


change the username and change `post` to include your databse prefix if any so if your prefix is vb_ then it would be `vb_post` if your prefix was vb then it would be `vbpost` if you have no prefix then it will be `post`

If you want to keep the posts but change the username let me know and i'll give you the query for that.

[ROTPAR]

awesome, i think it worked. THX man

[Digital Jedi]

Just to avoid this issue, I have a strict rule on my forum that Usernames cannot be changed without good reason, and that posts cannot be deleted without good reason. It really disrupts the flow of a thread if replies are just missing from the overall flow. If people agree to join, then not only will they think twice about what name they want to use, but also think twice about what they say. One of the biggest complaints about the internet is that people say whatever they want because anonymity means no consequences. This makes it more like the real world, where you don't put out there what you don't want coming back to you.