Welcome to Geeklog, Anonymous Monday, March 18 2024 @ 10:16 pm 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.
 Quote

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.)
 Quote

Status: offline

Laugh

Site Admin
Admin
Registered: 09/27/05
Posts: 1468
Location:Canada
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.
 Quote

All times are EDT. The time is now 10:16 pm.

  • 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