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


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

DELETE FROM qa_posts


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
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.