Mysql: Change status of posts waiting moderation

[postcd]

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?

[ForceHSS]

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

[Lynne]

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

[postcd]

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

[Lynne]

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.

[postcd]

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.