Welcome to Geeklog Wednesday, September 26 2018 @ 02:32 am EDT

Geeklog Forums

bulk comments delete


dbsmall

Anonymous
cheerful
I've neglected my Geeklog site for a while, during which time the Spammers overtook the comments.

Assuming I'm going to upgrade and maintain it, going forward...

I'll want to do some bulk deletion of comments, based on a date range. (I'm not worried about losing some valid comments duiring that same period.)

I'll go dig into the structure, this weekend. But if someone can suggest an easy 'oh, look in the following tables and delete records which match on X', or a simple SQL query to execute, boy, that would be helpful.

Thanks.

dbsmall

Anonymous
Ummm... https://www.geeklog.net/forum/viewtopic.php?showtopic=81330&highlight=delete%20comments#81330

Will look into the bulk comments delete, and whether it can be done on a per-date basis.

(Identifying strings that are used by the spammers might....take a lot longer.)

Status: offline

Laugh

Site Admin
Admin
Registered: 27/09/05
Posts: 1305
Geeklog does come with an admin tool for comments now. So if you upgrade to the latest version (v2.2.0) you will be able to sort comments by the date and then multi select to delete them.

You can check out the feature on the Demo site. Log in as the admin and then look for the Comments under Admins Only Block. https://www.softaculous.com/softaculous/demos/Geeklog

If you are worried about comment spam in the future you can turn on comment submissions which means the admin will have to approve the comment before it goes live.

Tom



One of the Geeklog Core Developers.

All times are EDT. The time is now 02:32 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content