Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

How to Make moderate section entries 0

+1 vote
78 views
asked Jan 4 in Q2A Core by Aras Ahmed

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
answered Jan 4 by Scott
selected Jan 5 by Aras Ahmed
 
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.
...