How to Make moderate section entries 0

Question

Hello,

I did remove all entries in the moderate section  using the SQL command :

DELETE FROM qa_posts

 WHERE type=Q_QUEUED;

the method succeeded but the number of the entries beside moderate section in the admin panel refer to there are 22259 entries waiting to approve , and there is no entries in the moderate section 

How to make that number 0

Answer 1

Try the recalc button at the bottom of Admin>Stats, the first one that recounts posts may do it.

Otherwise, wait for the next post to come in for moderation and it should update the count.

If that still doesn't work check in the database as it will be cached in there somewhere, probably qa_options. Change from 22259 to 0.