Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+2 votes
424 views
in Q2A Core by

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

Q2A version: 1.7.4

1 Answer

+2 votes
by
selected by
 
Best answer
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.
...