@JRW-910
Well that was a pain in the ***. After some very tedious debugging I isolated the source of the memory usage. You have 80,000 items in moderation. When an admin or mod logs in it counts all of those records.
For you I suggest one of these two things:
http://xenforo.com/community/resources/approve-all-moderated-posts-queries.373/
http://xenforo.com/community/resources/soft-delete-all-moderated-posts-queries.371/
That will clear out the queue and fix the memory problem.
I'd call this a memory issue or a vulnerability.... It wouldn't take much for myself or someone to write bot that joined X site and just report every post.@JRW-910
Well that was a pain in the ***. After some very tedious debugging I isolated the source of the memory usage. You have 80,000 items in moderation. When an admin or mod logs in it counts all of those records.
For you I suggest one of these two things:
http://xenforo.com/community/resources/approve-all-moderated-posts-queries.373/
http://xenforo.com/community/resources/soft-delete-all-moderated-posts-queries.371/
That will clear out the queue and fix the memory problem.
@JRW-910
Well that was a pain in the ***. After some very tedious debugging I isolated the source of the memory usage. You have 80,000 items in moderation. When an admin or mod logs in it counts all of those records.
For you I suggest one of these two things:
http://xenforo.com/community/resources/approve-all-moderated-posts-queries.373/
http://xenforo.com/community/resources/soft-delete-all-moderated-posts-queries.371/
That will clear out the queue and fix the memory problem.
@JRW-910
Well that was a pain in the ***. After some very tedious debugging I isolated the source of the memory usage. You have 80,000 items in moderation. When an admin or mod logs in it counts all of those records.
For you I suggest one of these two things:
http://xenforo.com/community/resources/approve-all-moderated-posts-queries.373/
http://xenforo.com/community/resources/soft-delete-all-moderated-posts-queries.371/
That will clear out the queue and fix the memory problem.
Hello Jake!
What will be the query to hard-delete all moderated posts ?
Thank you!
The data spans multiple tables as well as the file system (attachments). I don't recommend trying to hard-delete with queries. Soft-delete is easier.
1.2 may have better options for this.
Yes, but still i don't want as an admin browsing forums with lots of soft-deleted
UPDATE xf_thread
SET node_id = 2
WHERE discussion_state = 'deleted'
You could move those threads with a query:
Code:UPDATE xf_thread SET node_id = 2 WHERE discussion_state = 'deleted'
Great!
That will move moderated posts and moderated threads? are they treated the same?
UPDATE xf_thread
SET node_id = 2
WHERE discussion_state = 'moderated'
@JRW-910
Well that was a pain in the ***. After some very tedious debugging I isolated the source of the memory usage. You have 80,000 items in moderation. When an admin or mod logs in it counts all of those records.
For you I suggest one of these two things:
http://xenforo.com/community/resources/approve-all-moderated-posts-queries.373/
http://xenforo.com/community/resources/soft-delete-all-moderated-posts-queries.371/
That will clear out the queue and fix the memory problem.
We use essential cookies to make this site work, and optional cookies to enhance your experience.