Welcome to Geeklog, Anonymous Saturday, August 31 2024 @ 11:50 pm EDT
Geeklog Forums
bulk comments delete
dbsmall
Anonymous
![cheerful cheerful](https://www.geeklog.net/forum/image_set/moods/cheerful.gif)
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.
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.
15
13
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.)
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.)
20
12
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.
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.
8
15
Quote
All times are EDT. The time is now 11:50 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