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

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
by

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

...