Advertisement:

Author Topic: How to remove all posts of one user  (Read 1441 times)

Offline lucadanieli

  • Semi-Newbie
  • *
  • Posts: 16
How to remove all posts of one user
« on: January 11, 2019, 10:00:59 AM »
Hello,

I have a spam user. I removed it, but it didn't ask me to remove all its posts. Now I have just the posts and not the user. How can I solve the issue?

Best
Luca

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,488
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: How to remove all posts of one user
« Reply #1 on: January 11, 2019, 10:29:21 AM »
If there are lots of those posts around probably easiest if you create a dummy user, reattribute posts to that user, then delete the dummy user and posts at once.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline lucadanieli

  • Semi-Newbie
  • *
  • Posts: 16
Re: How to remove all posts of one user
« Reply #2 on: January 11, 2019, 12:03:20 PM »
Thank you Aleksi.
How can I? In my Administrator -> Members, I do not have an option to create a dummy user.

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,488
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: How to remove all posts of one user
« Reply #3 on: January 11, 2019, 12:13:00 PM »
Admin -> Members -> Registration -> Register new member :)

You can create a "dummy" user account from there.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline lucadanieli

  • Semi-Newbie
  • *
  • Posts: 16
Re: How to remove all posts of one user
« Reply #4 on: January 11, 2019, 12:32:10 PM »
Great, done!
Where should I go to reattribute the posts to the user?

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,488
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: How to remove all posts of one user
« Reply #5 on: January 11, 2019, 12:35:07 PM »
Admin -> Maintenance -> Forum maintenance -> Members :)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Owdy

  • SMF Fossil
  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,627
  • Gender: Male
  • W00t!
    • janoloferiksson on LinkedIn
    • @@jaoler on Twitter
Re: How to remove all posts of one user
« Reply #6 on: July 23, 2019, 03:04:49 AM »
If there are lots of those posts around probably easiest if you create a dummy user, reattribute posts to that user, then delete the dummy user and posts at once.
Seems that feature is broken. Removed user,, with all posts and topics, posts didnt get removed
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

Offline Owdy

  • SMF Fossil
  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,627
  • Gender: Male
  • W00t!
    • janoloferiksson on LinkedIn
    • @@jaoler on Twitter
Re: How to remove all posts of one user
« Reply #7 on: July 23, 2019, 03:19:05 AM »
Any SQL query for this?
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,488
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: How to remove all posts of one user
« Reply #8 on: July 23, 2019, 03:43:04 AM »
If there are lots of those posts around probably easiest if you create a dummy user, reattribute posts to that user, then delete the dummy user and posts at once.
Seems that feature is broken. Removed user,, with all posts and topics, posts didnt get removed
How did you remove the user? It should work, but there are multiple ways to delete an account and if I remember correctly not all of them give the option. (Which is illogical, I know)
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Owdy

  • SMF Fossil
  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,627
  • Gender: Male
  • W00t!
    • janoloferiksson on LinkedIn
    • @@jaoler on Twitter
Re: How to remove all posts of one user
« Reply #9 on: July 24, 2019, 02:18:28 AM »
User profile -> delete user -> delete user with all content
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,488
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: How to remove all posts of one user
« Reply #10 on: July 24, 2019, 02:23:34 AM »
Okay, that's odd - last time I've used it I'm pretty sure it worked. Any errors anywhere for clues?
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Owdy

  • SMF Fossil
  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,627
  • Gender: Male
  • W00t!
    • janoloferiksson on LinkedIn
    • @@jaoler on Twitter
Re: How to remove all posts of one user
« Reply #11 on: July 24, 2019, 02:27:14 AM »
Any errors anywhere for clues?
No, it just didnt do anything but removes profile. Content stays.
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,488
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: How to remove all posts of one user
« Reply #12 on: July 24, 2019, 03:02:34 AM »
Just tried, and it worked for me - at least for posts. The test account I used didn't have any topics.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Illori

  • Project Manager
  • SMF Legend
  • *
  • Posts: 51,046
Re: How to remove all posts of one user
« Reply #13 on: July 24, 2019, 05:04:47 AM »
Any errors anywhere for clues?
No, it just didnt do anything but removes profile. Content stays.

i dont think deleting posts/topics works that way when the account was re-attributed. i think it has been this way for years.

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,488
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: How to remove all posts of one user
« Reply #14 on: July 24, 2019, 05:06:05 AM »
I wonder, why wouldn't it?
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 71,252
    • StoryBB/StoryBB on GitHub
Re: How to remove all posts of one user
« Reply #15 on: July 24, 2019, 05:14:00 AM »
Because it doesn’t reattribute correctly, posts are, but the topic starter isn’t set up properly in the topics table.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Online Aleksi "Lex" Kilpinen

  • A Peculiar Finn
  • Lead Support Specialist
  • SMF Super Hero
  • *
  • Posts: 18,488
  • Gender: Male
  • Don't worry, I'm n00b friendly
    • Aleksi.Kilpinen on Facebook
    • LexArma on GitHub
    • aleksi-kilpinen on LinkedIn
    • There's No Place Like 127.0.0.1
Re: How to remove all posts of one user
« Reply #16 on: July 24, 2019, 06:03:03 AM »
Alright, a bug then.
A Finnish Support Specialist
 Happily running multiple SMF 2.0 installations.
  Fooling around with an i7 990X @ 3,47Ghz / 12Gb / Win 10 x64 / 3840x2160


How you can help SMF

"Before you allow people access to your forum, especially in an administrative position, you must be aware that that person can seriously damage your forum.
 Therefore, you should only allow people that you trust, implicitly, to have such access." -Douglas

Offline Owdy

  • SMF Fossil
  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 15,627
  • Gender: Male
  • W00t!
    • janoloferiksson on LinkedIn
    • @@jaoler on Twitter
Re: How to remove all posts of one user
« Reply #17 on: July 26, 2019, 03:22:37 AM »
Just tried, and it worked for me - at least for posts. The test account I used didn't have any topics.
Dont know what to say, doesnt work for me. CAnt remove spammers all posts at once
Former Lead Support Specialist

Tarvitsetko apua SMF foorumisi kanssa? Otan työtehtäviä vastaan, lue:http://www.simplemachines.org/community/index.php?topic=375918.0

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,084
  • Gender: Male
    • Macedonian electronics forum
Re: How to remove all posts of one user
« Reply #18 on: July 26, 2019, 09:13:35 AM »
Dont know what to say, doesnt work for me. CAnt remove spammers all posts at once

Number of posts? If it's not that big, you could do it manually, at least as a temporary solution :).
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline RFD

  • Jr. Member
  • **
  • Posts: 287
  • They're coming to take me away, hah hah ....
Re: How to remove all posts of one user
« Reply #19 on: July 26, 2019, 09:25:11 AM »