SMF Support > SMF 1.1.x Support
How to delete all the messages of one member
ulrrike:
Hallo,
That's quite nice, to have somebody from smf !!!
Well then, as you could see, the problem wasn't solved...I only think there isn't any solution - is there......... ?
Thank you
JimM:
--- Quote from: ulrrike on June 05, 2009, 03:37:21 PM ---Hallo,
That's quite nice, to have somebody from smf !!!
Well then, as you could see, the problem wasn't solved...I only think there isn't any solution - is there......... ?
Thank you
--- End quote ---
quiteperplexed gave you the solution. If you delete the member from their profile, you will be given the option to delete all messages. If you selected that and it didn't delete all the messages, then you have some other issue that we will need more information in order to suggest a solution. Were there any errors in the log? Have you already deleted this person?
Spyd:
Sorry to bump this old thread, but my problem is that I already deleted the user... and all the posts remained.
I guess I missed the delete messages option.
So I looked at a possible solution, and as I didn't find one, I invented one myself.
Execute this using the "MySQL Query Browser":
--- Code: ---DELETE FROM smf_messages WHERE poster_name='spammer';
--- End code ---
Note that the "smf_" prefix is something you put as you config the forum, this is the default prefix, but yours may be different.
Obviously the name 'spammer' is where you put the member name.
Then use the routine mantainance tools to 1. Find & repair errors (do it and fix until there are no more errors reported) 2. Recount all forum totals and statistics (because stastics will be wrong)
I wont give more details using this solution; if you need more, clearly this is not the solution for you. And that's because the following warning:
WARNING!: Using data-modifiyng queries on your database can destroy all your forum (and other things you may have on the database), so proceed with extreme caution. This worked for me, but I can't be sure if it'll work for you. Backup your database befory trying this.
Illori:
in the future please do not bump old topics you are best to create a new one for your issue
ziycon:
What Spyd said will work, but your better narrowing it down to the specific user incase there are other occurrences of the username associated to other posts, you can use the below query to base it off the user with the assigned name in your members table.
--- Code: ---DELETE FROM smf_messages WHERE ID_MEMBER=(SELECT ID_MEMBER FROM smf_members WHERE memberName='<username>');
--- End code ---
Once this is done just delete the user.
**As always make sure to backup the database before making any changes.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version