Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+4 votes
in Q2A Core by
It's very annoying to manually hide and delete posts that are marked as spam by akismet spam filter. akismet just put the posts into the moderation queue. So my question is, can I simply delete those entries from the qa_posts table or are there correlations to other tables, that would cause problems?
Would be great if someone could post the SQL for this ;-)

1 Answer

0 votes

I think it is safe, but stats such as number of user's questions, user points, or number of category questions won't be updated. so you will have to visit "admin > stats" to recalculate them. *** backup your DB before doing this