Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: Felix J on May 22, 2011, 07:47:40 AM

Title: Mass Delete a users post
Post by: Felix J on May 22, 2011, 07:47:40 AM
Hello

I have spammer issues.

Ok here is the deal... I deleted the account, but the posts is still there. So how can I now delete the posts of the user?? smf v2

Maybe someone could move this to v2 support board? Sorry for the wrong choice of board. A mistake from my side.
Title: Re: Mass Delete a users post
Post by: CapadY on May 22, 2011, 10:20:04 AM
Create a new account
Add all posts of the spammer to that new account via Amin - Maintenance - Forum Maintenance - Topics
Go to the new members profile
Choose Actions - Delete Account
Enable the option to also delete all posts and topics
Title: Re: Mass Delete a users post
Post by: Felix J on May 22, 2011, 11:51:51 AM
Quote from: CapadY on May 22, 2011, 10:20:04 AM
Create a new account
Add all posts of the spammer to that new account via Amin - Maintenance - Forum Maintenance - Topics
Go to the new members profile
Choose Actions - Delete Account
Enable the option to also delete all posts and topics

Ok, but I don't understand what to do while at the "Topics" page within admin?
Title: Re: Mass Delete a users post
Post by: Felix J on May 22, 2011, 12:01:44 PM
Why does this seems so 'complicated' to do??!!  ???
Title: Re: Mass Delete a users post
Post by: Felix J on May 22, 2011, 01:41:03 PM
Can someone please help me further with this issue?

Thanks!
Title: Re: Mass Delete a users post
Post by: CapadY on May 22, 2011, 01:52:57 PM
Please dont bump within 24 hours. It's because my message was finished before is saw it otherwise I would have ignored this topic.

Quote from: Felix J on May 22, 2011, 12:01:44 PM
Why does this seems so 'complicated' to do??!!  ???
I think because you didn't it the right way when you delete that member.

When you had delete that member the first time via Member profile - actions you should have the possibility to remove all his post/topics immediatly.

Quote
Ok, but I don't understand what to do while at the "Topics" page within admin?

Oke, my fold. It should be Admin - Maintenance - Forum Maintenance - Members.

Here you can reatribute User Posts.
Title: Re: Mass Delete a users post
Post by: Felix J on May 22, 2011, 01:57:08 PM
Quote from: CapadY on May 22, 2011, 01:52:57 PM
Please dont bump within 24 hours. It's because my message was finished before is saw it otherwise I would have ignored this topic.

Quote from: Felix J on May 22, 2011, 12:01:44 PM
Why does this seems so 'complicated' to do??!!  ???
I think because you didn't it the right way when you delete that member.

When you had delete that member the first time via Member profile - actions you should have the possibility to remove all his post/topics immediatly.

Quote
Ok, but I don't understand what to do while at the "Topics" page within admin?

Oke, my fold. It should be Admin - Maintenance - Forum Maintenance - Members.

Here you can reatribute User Posts.

Ok, but being at the member page I can read this - "Attribute posts to member: "

What to write in there?


Nwm... Got confused for some reason... but I understand now.


Ok, last but not least... Where do I find the delete posts thing? I am currently looking at the user profile.
Title: Re: Mass Delete a users post
Post by: CapadY on May 22, 2011, 02:05:49 PM
User profile - Actions - Delete this account.

There you will find an option to also delete all of the posts/topics of that specific user.
Title: Re: Mass Delete a users post
Post by: Felix J on May 22, 2011, 02:13:10 PM
Quote from: CapadY on May 22, 2011, 02:05:49 PM
User profile - Actions - Delete this account.

There you will find an option to also delete all of the posts/topics of that specific user.

Hmmmm, for some reason nothing happens when I choose the option - "Topics and Posts" and then press the "Delete" button.  ???

No kind of message either after pressing the Delete button. I just get back to the front-end page (Home page of site)

...and if checking - "Delete this member's account." too, then only the member account gets deleted and no threads or posts.


I still need help.
Title: Re: Mass Delete a users post
Post by: Sir Osis of Liver on May 22, 2011, 03:47:29 PM
You've already deleted the original account without deleting messages/topics, so the spammer's messages/topics are still on your board.  As per CapadY's first reply above, you have to register a new user and transfer the spam posts to the new user.  Then you can delete the new user and all of his (formerly the spammer's) messages/topics.



Title: Re: Mass Delete a users post
Post by: hcfwesker on May 22, 2011, 03:53:43 PM
You could also goto phpMyadmin (if you have that option) in your cPanel, under smf_messages and search for the posts made by that member id , then chose to remove them all at one click.
Title: Re: Mass Delete a users post
Post by: Felix J on May 22, 2011, 04:47:21 PM
Quote from: Krash. on May 22, 2011, 03:47:29 PM
You've already deleted the original account without deleting messages/topics, so the spammer's messages/topics are still on your board.  As per CapadY's first reply above, you have to register a new user and transfer the spam posts to the new user.  Then you can delete the new user and all of his (formerly the spammer's) messages/topics.

Exacly that is what I've been trying to do. However the threads or posts wont disapear after clicking the delete button. I am starting to believe this is a bug or anyone know if I am doing something wrong?

Quote from: hcfwesker on May 22, 2011, 03:53:43 PM
You could also goto phpMyadmin (if you have that option) in your cPanel, under smf_messages and search for the posts made by that member id , then chose to remove them all at one click.

Yes, I could. However, I would like to feel comfortable with the admin panel and I can't say I am at that stage yet most of all due to this issue...
Title: Re: Mass Delete a users post
Post by: Sir Osis of Liver on May 22, 2011, 05:02:43 PM

There are two places you can delete a member. 

Admin -> Members displays the member list, and you can delete a member from the list, but you don't have the option to delete the member's posts.  If you click on the username instead, you'll go to  Profile Info, with an Actions tab up top, which has the "Delete this account" option.  This gives you a dropmenu that allows you to delete all messages/topics.  You must transfer all of the spammer's posts to the new user account before you delete it.



Title: Re: Mass Delete a users post
Post by: CapadY on May 22, 2011, 05:39:41 PM
Did you do a check if all Spam messages where connected to the new user before deleting the new user ?

Quit simple by showing the new member profile and select "Show all messages".
When they where not connected they shouldn't be deleted too.
Title: Re: Mass Delete a users post
Post by: Felix J on May 22, 2011, 11:33:52 PM
Quote from: CapadY on May 22, 2011, 05:39:41 PM
Did you do a check if all Spam messages where connected to the new user before deleting the new user ?

Quit simple by showing the new member profile and select "Show all messages".
When they where not connected they shouldn't be deleted too.

Yes. The spam messages is/was connected to the new user.

The new user is called "test".

http://test.calculusforums.com
Title: Re: Mass Delete a users post
Post by: Sir Osis of Liver on May 23, 2011, 12:03:28 AM
Admin -> Members -> View All Members

Click on Username

Actions -> Delete this account

Remove posts made by this member: -> Topics and Posts

Check Delete this member's account

Delete

Title: Re: Mass Delete a users post
Post by: live627 on May 23, 2011, 12:38:51 AM
DELETE FROM smf_members
WHERE member_name = 'test'
Title: Re: Mass Delete a users post
Post by: Felix J on May 23, 2011, 01:39:36 AM
Quote from: Krash. on May 23, 2011, 12:03:28 AM
Admin -> Members -> View All Members

Click on Username

Actions -> Delete this account

Remove posts made by this member: -> Topics and Posts

Check Delete this member's account

Delete

As I stated earlier, that is exacly what I have done. All that happens is after clicking on the delete button is that I get back to home page (main page) of site. With the user and all the spam messages connected to that user still there...
Title: Re: Mass Delete a users post
Post by: CapadY on May 23, 2011, 02:41:38 AM
Quote from: live627 on May 23, 2011, 12:38:51 AM
DELETE FROM smf_members
WHERE member_name = 'test'

This query won't remove any spam message, while thats is what we are trying to do.
Title: Re: Mass Delete a users post
Post by: Sir Osis of Liver on May 23, 2011, 01:55:22 PM

IIRC, you have approx. 100 posts attached to "Test".  For the amount of time you've put into this, you'd probably be better off just deleting the posts one at a time.

Title: Re: Mass Delete a users post
Post by: Felix J on May 24, 2011, 05:04:27 AM
Quote from: Krash. on May 23, 2011, 01:55:22 PM

IIRC, you have approx. 100 posts attached to "Test".  For the amount of time you've put into this, you'd probably be better off just deleting the posts one at a time.

Yes I could, but that is not the point here. The point is that I can't delete all threads and posts together even though I should be able to do it regarding to the admin panel. This function won't however work.

Lastly, 100 posts well I guess I could delete one post at a time. However, what if the forum gets massive spam like thousands of spam messages. Then it's not that funny to remove each messages at a time...

CapadY, I can give you admin login via pm and then you could try for yourself if you like. Just to make sure I haven't missed to do anything. If I haven't then maybe this should be considered to be a bug?
Title: Re: Mass Delete a users post
Post by: Farjo on May 24, 2011, 02:38:19 PM
Quote from: Krash. on May 23, 2011, 12:03:28 AM
Remove posts made by this member: -> Topics and Posts

Did you definitely do this step as it defaults to 'None'.
Title: Re: Mass Delete a users post
Post by: mashby on May 26, 2011, 08:21:52 AM
Well, this is interesting. Here's the situation. You had a user named lorafrye who posted 102 messages who you likely deleted but didn't delete the messages (that's my theory anyway). So, I did this. Forum Maintenance > Members. Attribute guest posts made with "lorafrye" to "jasmin4628". Get this nice message "The maintenance task 'Reattribute User Posts' was executed successfully. " Now jasmin4628 is also a spammer. So I then next deleted jasmin4628.
Remove posts made by this member: Topics and Posts.
Delete!
Then all 102 posts were then sent back to lorafrye as a guest. Tried this on a couple of other spammer members you have changing the Remove posts made by this member to All Posts. Same results.

My next recommendation would be to simply delete the Quantification board, but that doesn't really explain why the above isn't working. Then I thought, hey, let's try this next:
Forum Maintenance > Topics
Remove Old Posts
Remove all topics not posted in for "2" days, which are:
Specific Boards (checked Quantization)
Any sort of topic.
Remove now
Get this:
QuoteUnable to verify referring url. Please go back and try again.

I'm scratching my head now too. Let's see if anyone else has more ideas/suggestions.
Title: Re: Mass Delete a users post
Post by: Illori on May 26, 2011, 08:35:46 AM
any mods installed? any manual edits to files?
Title: Re: Mass Delete a users post
Post by: Felix J on May 26, 2011, 08:45:25 AM
Quote from: Illori on May 26, 2011, 08:35:46 AM
any mods installed? any manual edits to files?

All the default mods (that is included with the software) is installed and one other which I uninstalled due to missunderstanding of it's feature... I don't remember currently it's name though...

Yes I've made edits mostly to index.css and some to the index template (forgot it's name) (removing logo and adding path to new logo). Changed image files..

I don't believe I've made any edits that would cause this, but of course I can be wrong. Maybe this should also be tried on a just default install too? If it's not already has and there is no doubt that this feature which won't work on my site is in reality working on for example a default installation of smf v2.
Title: Re: Mass Delete a users post
Post by: Deezel on May 26, 2011, 08:48:46 AM
Does anyone think it would be worth it to load it back to before the last mod was installed?
Just a thought...
Title: Re: Mass Delete a users post
Post by: Felix J on May 26, 2011, 09:07:17 AM
Maybe the strangest or the most interesting thing... with it all is that there is no visible errors or messages whatsoever. You just get back to the home page of the site after clicking the "Delete" button.
Title: Re: Mass Delete a users post
Post by: mashby on May 26, 2011, 11:25:39 AM
No real mods installed...
Remove Child Boards    2.2
That's listed but hasn't been Installed.

I know you were editing template files and such, but I doubt you edited anything in /Sources, did you?
Title: Re: Mass Delete a users post
Post by: Sir Osis of Liver on May 26, 2011, 03:10:08 PM

Had you given Admin privileges or FTP access to anyone (i.e., a mod author) prior to this problem appearing?

Title: Re: Mass Delete a users post
Post by: Illori on May 26, 2011, 03:11:02 PM
this issue has been looked into in the bug reports board, and found to be a valid bug.
Title: Re: Mass Delete a users post
Post by: Leo2 on February 11, 2012, 04:15:56 AM
How to mass delete messages of a user from the list of his posts without deleting the user? Just some of his posts. Checkboxes in the user posts list will be the the best (like the list of posts in the forum)

Is there a mod for that?

I found similar topic here http://www.simplemachines.org/community/index.php?topic=261380.msg1703194#msg1703194 but with no solution as well.
Title: Re: Mass Delete a users post
Post by: CapadY on February 11, 2012, 06:28:44 AM
Leo, maybe you can open an open, new, topic for your specific problem ?

This topic is nearly one year old and I suppose it will be solved allready.
Title: Re: Mass Delete a users post
Post by: bradl on May 30, 2014, 04:32:05 AM
Here is the solution, just had the same problem.



Before you're able to delete multiple posts at the same time, you'll have to enable checkboxes. Follow the directions below to enable checkboxes.

Profile > Modify profile >Look and Layout

at the bottom you will see "Show Quick-moderation as" there will be a drop down box, select checkboxes then click change profile (of save pending on your release)

Now you can go back to the board and click the top check box to select all and then go to the bottom and select remove posts in the drop down box.

Title: Re: Mass Delete a users post
Post by: Kindred on May 30, 2014, 05:55:27 PM
that only helps if he wants to delete entire threads... deleting posts within threads that he wants to keep is more problematic.