8,081 messages in moderation queue. What now?

[Shay Atik]

So I haven't touched my forum for couple of weeks and now I got 8,081 (!!) messages in moderation queue.

Clicking on the moderation list - OBVIOUSLY - stucks up my computer, and gives me the php "out of memory message": Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 29887934 bytes)

Without going deeply into the DB, how am I gonna clean all the messages?

 

[Jake Bunce]

http://xenforo.com/community/resources/approve-all-moderated-posts-queries.373/

or

http://xenforo.com/community/resources/soft-delete-all-moderated-posts-queries.371/

 

[Jake Bunce]

Thanks, but it says " You need to change the red pieces to attribute these deletions to a user_id and username".

It's only for a specific user. What if I want to delete the whole moderation list, for all users?

It does the whole queue. But soft-deletes are attributed... meaning who is doing the deleting. When you view a soft-deleted post it says who deleted it and for what reason.

 

[Shay Atik]

http://xenforo.com/community/resources/approve-all-moderated-posts-queries.373/

or

http://xenforo.com/community/resources/soft-delete-all-moderated-posts-queries.371/

Thanks, but your solution is for specific user, as it says " You need to change the red pieces to attribute these deletions to a user_id and username".

What if I want to delete the whole list, with all users?

 

[Shay Atik]

It does the whole queue. But soft-deletes are attributed... meaning who is doing the deleting. When you view a soft-deleted post it says who deleted it and for what reason.

Oh, Thanks. Gonna try it!

 

[Shay Atik]

It does the whole queue. But soft-deletes are attributed... meaning who is doing the deleting. When you view a soft-deleted post it says who deleted it and for what reason.

Just like a magic. Thanks dude!