Mysql: Change status of posts waiting moderation
 

Hi,

i have several thousand posts awaiting moderation ("Threads to Moderate"), please can anyone share mysql command to turn all these posts into approved/deleted?

If you do it from the admincp you can do many at the same time it would be the best way

Most shared hosting servers will not let you process more than 1000 at a time. So, you will need to approve them in batches of only 1000. (Maybe, that is. It could be your host doesn't have it set like that.)

3.8.4, shared host, memory exhausted, blank screen. please anyone can share mysql command to achieve that? or any alternative way to achieve?

Did you try doing this in smaller batches?

If you do it via mysql, you could screw other things up, which is why anyone is reluctant to give the command. I mean, the *exact* command you ask for is to just change post.visible from 0 to 1 in the post table. But there are other tables this could affect and so I don't know that anybody wants to go through and figure all those out.

This can be done from frontend of the forum when loged in as admin, there is moderator panel and one can do 200 threads on page..

A way to delete all awaiting moderation at once is to go to AdminCP/Threads & Posts / Prune and select to prune only awaiting moderation.