Hi, I messed up my database.
I tried to approve 7k+ posts after converting from phpBB 2. Somehow they weren’t approved. Doing it by hand would take terrible amount of time, so I tried to edit those posts properties directly in the database.
In forum_posts_approved and forum_topics_approved I set exact number of posts and topics in each forum. In forum_topics_unapproved and forum_posts_unapproved I just set 0.
I also altered every problematic post in phpbb_posts, changing „post_visibility” from „3” to „1”. The result is that I can see all the posts (I’m an administrator) without need for approving them, but users don’t see them, like the posts weren’t approved at all.
What else do I need to change in my database to make all posts approved?