XF 2.2 Approval Queue shows unread message

[philmckrackon]

Approval Queue shows unread message, weird. Cannot get rid of the nag. Ideas?

 

[Paul B]

That could indicate a discrepancy in the database.

Are there any entries in the xf_approval_queue table?

Also run these queries:

SELECT * FROM `xf_post` WHERE message_state = 'moderated';

SELECT * FROM `xf_thread` WHERE discussion_state = 'moderated';

 

[philmckrackon]

That could indicate a discrepancy in the database.

Are there any entries in the xf_approval_queue table?

Also run these queries:

SELECT * FROM `xf_post` WHERE message_state = 'moderated';

SELECT * FROM `xf_thread` WHERE discussion_state = 'moderated';

There was one entry in the database xf_approval_queue table for the NixFifty Classifieds. I deleted it then ran the above queries with zero returns. Also rebuilt classified caches and all other caches including XFMG and XFRM. Still shows 1 on the forum page but none in the queue.