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

I am facing problem with spam content, currently 27000 spam comments are showing in the modrate section.

Can someone please guide to delete all the post in modrate section from phpmyadmin, the spam users.

Thanks in advance.

1 Answer

0 votes

Comments in the moderation queue have the type C_QUEUED (A_QUEUED and Q_QUEUED for answers and questions respectively). To delete them directly from the database you could run

DELETE FROM qa_posts WHERE type = 'C_QUEUED';

Note, however, that deleting data directly from the database backend is usually not recommended and may result in data inconsistencies (see for example this post from pupi1985).