MyBB Community Forums
Awaiting Moderation Bug post-merge - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Merge System Support (https://community.mybb.com/forum-180.html)
+--- Thread: Awaiting Moderation Bug post-merge (/thread-230496.html)



Awaiting Moderation Bug post-merge - lawless314 - 2020-12-08

Hello,

I merged from IPB 3.4.x to myBB.  On the top of the forum display, it says:

Awaiting Moderation: 2 unapproved threads.

However, when I click on this, nothing is there in the moderation queue, either in the ModCP or ACP.

I am using the default theme and I tried rebuilding cache to see if that worked.  I also tried to unapprove a thread and then re-approve it, but it just added on to the existing count while it was under moderation.  

I can only think that perhaps it is an orphaned thread and thus I am having view permissions issues (even while on the admin account).  Is this something I can search for in the database...?


RE: Awaiting Moderation Bug post-merge - noyle - 2020-12-08

Try following queries:
SELECT * FROM mybb_threads WHERE visible = 0;
SELECT * FROM mybb_posts WHERE visible = 0 AND replyto = 0;



RE: Awaiting Moderation Bug post-merge - lawless314 - 2020-12-08

Ha! I forgot to mention that I had already done an SQL search on mybb_threads, but I had not done it for mybb_posts. They were hidden in there. Thank you!


RE: Awaiting Moderation Bug post-merge - noyle - 2020-12-08

It looks like there might be some inconsistency for thread visibility and the firstpost's visibility. We will check it later.

Thanks for your report!