Welcome to Geeklog, Anonymous Monday, May 27 2024 @ 05:11 am EDT

Geeklog Forums

bulk comments delete


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.



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


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


One of the Geeklog Core Developers.

All times are EDT. The time is now 05:11 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