jwdenzel Posted August 17, 2019 Share Posted August 17, 2019 I have nearly 7,000 entries in my approval queue. Most of them are very old (5 years+, before I realized the feature existed!) How can I manually clear those out in bulk? I don't want to sit there for hours/days manually clicking each one. Thoughts? Link to comment Share on other sites More sharing options...
Pete T Posted August 17, 2019 Share Posted August 17, 2019 58 minutes ago, jwdenzel said: I have nearly 7,000 entries in my approval queue. Most of them are very old (5 years+, before I realized the feature existed!) How can I manually clear those out in bulk? I don't want to sit there for hours/days manually clicking each one. Thoughts? Do want them removed if so you can change the period they have to validate the email, or are talking about making them all approved no real way now. Link to comment Share on other sites More sharing options...
jwdenzel Posted August 22, 2019 Author Share Posted August 22, 2019 On 8/17/2019 at 9:15 AM, Pete T said: Do want them removed if so you can change the period they have to validate the email, or are talking about making them all approved no real way now. This is the forum post Approval Queue, not member validation. (See screenshot) I have nearly 7,000 of these comments that have been needing approval since as as far back as 2010. Probably they were posts by people who had previously been put on temporary restriction. I don't see a way to bulk approval/delete these, but I'd like to know where in the database they're located. I can experiment with an SQL statement to maybe clear them? Anybody? Link to comment Share on other sites More sharing options...
Pete T Posted August 22, 2019 Share Posted August 22, 2019 7 hours ago, jwdenzel said: This is the forum post Approval Queue, not member validation. (See screenshot) I have nearly 7,000 of these comments that have been needing approval since as as far back as 2010. Probably they were posts by people who had previously been put on temporary restriction. I don't see a way to bulk approval/delete these, but I'd like to know where in the database they're located. I can experiment with an SQL statement to maybe clear them? Anybody? Oh sorry thought talking about sign up, i not seen any bulk tool for posts but i not sure if can be done via using MySQL command have you asked IPS in support topic as might know best method. Link to comment Share on other sites More sharing options...
jwdenzel Posted August 22, 2019 Author Share Posted August 22, 2019 I figured it out. I had to dig into the MySQL tables. Many the tables (post comments, blog comments, news comments, etc) all have some sort of "Approved" field. Some safe experiments showed you can flip those values and mark things to be hidden. 99% of my queue was from spam comments on my blog system. I no longer use the blog system so I bulk hid them and now I'm all set. Link to comment Share on other sites More sharing options...
tonyv Posted August 22, 2019 Share Posted August 22, 2019 4 hours ago, jwdenzel said: 99% of my queue was from spam comments on my blog system. Wow! I'm relieved. It would be a tragedy if your community missed out on 7,000 comments since 2010!!! 😮 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.