Approval Queue Count

[Tom Irons]

I find this really strange that when I remove something from the approval queue, it updates the count. But when I refresh the page, it is incorrect.

Anyone else having these issues?

[W4L]

yes i am aswell i was told to

Run sql query 

UPDATE `forums_forums` SET queued_topics=0 WHERE id=X;

X - forum ID

thats were i see it all the time

[Tom Irons]

I don't see that anywhere, it just shows the wrong count in the approval queue.

[MADMAN32395]

Ive had the same thing, was able to reproduce for them. DanielF told me to not delete the video as its attached to an internal bug report.

-Tickets ;  935927   931056

[newbie LAC]

Hello,

On 08.03.2016 at 3:56 AM, Hulu said:

But when I refresh the page, it is incorrect.

You need wait 15 minutes.

applications/core/modules/front/modcp/modcp.php

		try
		{
			$approvalQueueCount = \IPS\Data\Cache::i()->getWithExpire( 'modCpApprovalQueueCount_' . \IPS\Member::loggedIn()->member_id, TRUE );
		}
		catch ( \OutOfRangeException $e )
		{
			$approvalQueueCount = \IPS\Content\Search\Query::init()->setHiddenFilter( \IPS\Content\Search\Query::HIDDEN_UNAPPROVED )->count();
			\IPS\Data\Cache::i()->storeWithExpire( 'modCpApprovalQueueCount_' . \IPS\Member::loggedIn()->member_id, $approvalQueueCount, \IPS\DateTime::create()->add( new \DateInterval( 'PT15M' ) ), TRUE );
		}

You can report as bug.

[Daniel F]

Yea, ticket 935927 was handled by me..

The issue was: 

Quote

When you create a new topic and you hide it via the moderation options checkbox on the right side of the create form,the approval count will be increased, but it won' t be shown on the approval modcp page and also not on the hidden content page. The issue is that the first post of the topic isn't set to queued=2

 

This was fixed for 4.1.9

[Tom Irons]

Oh, so when you hide something, it goes into the approval queue?

[bfarber]

If you are still experiencing issues, I'd recommend submitting a ticket. We identified a bug and resolved it that would explain what you are experiencing, so please be sure you upgrade to the latest version first.