Page 1 of 1

Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)

Posted: Wed Jun 05, 2019 5:17 pm
by arclight
I recently updated from 3.1 to 3.2 via command line and it appears not everything took correctly.

Now, all my old posts are unapproved and need to be approved via the MCP to appear.

I have tens of thousands of old posts so doing it via the MCP would take forever. Is there any way to approve them in bulk? i.e. can I go into Mysql and get it done all at once?

Thanks

Re: How to bulk approve posts? (Updated 3.1-3.2- All posts need approval)

Posted: Wed Jun 05, 2019 8:02 pm
by stevemaury
Executing SQL Queries in phpMyAdmin

Code: Select all

UPDATE phpbb_posts SET post_visibility = 1 WHERE post_visibility = 0;
UPDATE phpbb_topics SET topic_visibility = 1 WHERE topic_visibility = 0;
If your table prefix is not phpbb_ change accordingly and backup both tables first.

Re: How to bulk approve posts? (Updated 3.1-3.2- All posts need approval)

Posted: Wed Jun 05, 2019 8:06 pm
by 3Di
Please file a bug report at the tracker with as more details as you can.

https://tracker.phpbb.com/

Re: How to bulk approve posts? (Updated 3.1-3.2- All posts need approval)

Posted: Wed Jun 05, 2019 11:45 pm
by arclight
stevemaury wrote:
Wed Jun 05, 2019 8:02 pm
Executing SQL Queries in phpMyAdmin

Code: Select all

UPDATE phpbb_posts SET post_visibility = 1 WHERE post_visibility = 0;
UPDATE phpbb_topics SET topic_visibility = 1 WHERE topic_visibility = 0;
If your table prefix is not phpbb_ change accordingly and backup both tables first.
Ok thanks.

UPDATE: I ran the query and it fixed some of the problem but not all the way through.

While there are now no longer any posts in the MCP approval queue, now the newly approved posts are only visible when I'm logged in as admin. They're still invisible to everyone else.

If I log out and view as a guest/visitor, I can only see the posts that I had previously approved from the MCP, after this happened. i.e. my main forum shows only 160 topics to visitors even though it should have thousands (which I do see when logged in as admin).

Seems there's one last step to get all of those posts fully publicly visible as if they were approved via moderation...any ideas? Something in the MCP or in forum permissions? Or an additional field to attack via mysql query? Thanks.

Re: How to bulk approve posts? (Updated 3.1-3.2- All posts now need approval)

Posted: Sat Jun 08, 2019 10:13 pm
by arclight
Bump... Posts are still not visible to public or regular users when logged out of admin account. Thanks

Re: How to bulk approve posts? (Updated 3.1-3.2- All posts now need approval)

Posted: Mon Jun 17, 2019 8:45 pm
by arclight
Bumping this one again.

Still cant see all posts unless logged in as Admin so some flag still left to change for full public visibility.

Thanks.

Re: Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)

Posted: Mon Jun 17, 2019 9:32 pm
by Lumpy Burgertushie
make sure the anonymous user is in the guest group and that nobody else is in the guest group.

also, check permissions for the registered user group for the relevant posts/forums that are not showing up.

also, have you checked what the registered users can see other than yourself?

create a new account for you to test with. do not put that new user in anything but the registered user group.
also, see what users are in the newly registered user group.


robert

Re: Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)

Posted: Mon Jun 17, 2019 9:51 pm
by arclight
Ok, will do that, but first things to consider are:

1. Posts I approved manually, show up properly - publicly visible to all users incl anonymous/guest, which is what I want.

2. After running Stevemaury's MySQL query above in the thread to shortcut approval of the remaining
tens of thousands of posts that were suddenly placed in the moderation queue after updating to 3.2, all of the remaining pending posts were now no longer visible in the queue, and were now showing up properly when logged in as admin.

3. All of the posts that I approved manually, still show up properly, but the post approved via mysql query shortcut
In step 2 above, do not. They show up only for admin, regardless of forum or user access on the previous post. All of the original posts and forums all had the same access level, they were publicly visible to all.

again, the only difference between the two sets of posts are that I approved some manually, and the rest were affected by the MySQL query to try and bulk approve them.


Lumpy Burgertushie wrote:
Mon Jun 17, 2019 9:32 pm
make sure the anonymous user is in the guest group and that nobody else is in the guest group.

also, check permissions for the registered user group for the relevant posts/forums that are not showing up.

also, have you checked what the registered users can see other than yourself?

create a new account for you to test with. do not put that new user in anything but the registered user group.
also, see what users are in the newly registered user group.


robert

Re: Posts not publicly visible / bulk approve posts? (Updated 3.1-3.2- All posts need approval)

Posted: Tue Jun 18, 2019 5:33 pm
by stevemaury
The fact that you can see them and others cannot implies a permissions issue. Have you checked your permissions (admin) versus a registered users permissions using the permission masks?