Delete all posts in Modrate section

Question

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.

Answer 1

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