What's the best way...
 
Notifications
Clear all

What's the best way to clean up spam?

6 Posts
3 Users
1 Likes
212 Views
(@charl)
Posts: 17
Active Member
Topic starter
 

Hi there,

I've recently updated my fanfic site https://www.transformersfanfic.com to the latest version of eFiction but I have a lot of spam comments and authors.

Does anyone know the best way to clean up spam? I was planning to use phpMyAdmin and go on a deletion frenzy, but if anyone has cleaned up their spam in a different way, could you please let me know?Β 

Regards,

Charl

 
Posted : 20/01/2022 7:28 pm
Topic Tags
Ariane
(@ariane)
Posts: 23
Eminent Member
 

It's been 3-4 years since the last time but I used to do it via phpmyadmin before I had to disable new registrations because of spammers and spam reviews. I don't believe a better method has been released since then.

 
Posted : 24/01/2022 12:46 pm
(@ladama)
Posts: 57
Trusted Member
 

When I took over the my archive a few years ago I also had to delete tons of spam and yeah phpmyadmin was the way I had to do it. For future spam, I added a spam test question to the registration page and it’s helped immensely. I posted the coding changes here: https://efiction.org/community/postid/20736/

 
Posted : 24/01/2022 2:13 pm
(@charl)
Posts: 17
Active Member
Topic starter
 
Posted by: @ariane

It's been 3-4 years since the last time but I used to do it via phpmyadmin before I had to disable new registrations because of spammers and spam reviews. I don't believe a better method has been released since then.

Thanks. Do you have any recommendations on how to do it? Just get phpMyAdmin to list all the authors, reviews, and so on. Then delete anything that's spam?

 
Posted : 29/01/2022 10:36 pm
(@charl)
Posts: 17
Active Member
Topic starter
 
Posted by: @ladama

When I took over the my archive a few years ago I also had to delete tons of spam and yeah phpmyadmin was the way I had to do it. For future spam, I added a spam test question to the registration page and it’s helped immensely. I posted the coding changes here: https://efiction.org/community/postid/20736/

This is great! Thank you!

 
Posted : 29/01/2022 10:38 pm
Ariane
(@ariane)
Posts: 23
Eminent Member
 
Posted by: @charl
Posted by: @ariane

It's been 3-4 years since the last time but I used to do it via phpmyadmin before I had to disable new registrations because of spammers and spam reviews. I don't believe a better method has been released since then.

Thanks. Do you have any recommendations on how to do it? Just get phpMyAdmin to list all the authors, reviews, and so on. Then delete anything that's spam?

My memory isn't what it used to be due to my chronic illnesses, and I don't remember the specifics of what I did, sorry! Only that I had to putter around quite a lot in phpMyAdmin in at least _reviews, _authors, _authorinfo and _authorprefs tables. I don't seem to have notes about the process saved anywhere πŸ™ I hope someone else can better help you!

Β 

 
Posted : 31/01/2022 7:06 am
Charl reacted
Share: