threads awaiting moderation Crash!

[SᴩiDᴇЯ]

I have over 5000+ threads awaiting to be moderated and Firefox and IE and Chrome all crashes trying to load all the threads on the one page in ACP, and all the browser crash, so how can i get the threads moderated without the browser crashing?

I am running vB 3.8,4 on my site.

The reason i got 5000+ threads awaiting to be moderated is because in Usergroup Manager, Elite Uploaders under Follow Forum Moderation Rules i forgot to select YES.

So can anyone tell me how i can get around this problem please.

Thank you in advance.

[kh99]

Maybe the easiest thing would be to edit the file modcp/moderate.php and around line 353 change it like this (red added):

$moderated = $db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "moderation
WHERE type IN ('thread', 'reply')
LIMIT 100
");


I just picked 100 arbitrarily, I have no idea how much larger you could make it (or even if it would have to be smaller than 100).

[SᴩiDᴇЯ]

Maybe the easiest thing would be to edit the file modcp/moderate.php and around line 353 change it like this (red added):

$moderated = $db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "moderation
WHERE type IN ('thread', 'reply')
LIMIT 100
");


I just picked 100 arbitrarily, I have no idea how much larger you could make it (or even if it would have to be smaller than 100).

Hi kh99,

I have done the limit to 1000 and it works fantasticly, thank you very very much I appreciate your help.

see:
$moderated = $db->query_read("
SELECT *
FROM " . TABLE_PREFIX . "moderation
WHERE type IN ('thread', 'reply')
LIMIT 1000
");

--------------- Added 1315759426 at 1315759426 ---------------

This was my thread count 15 min ago before i did the moderating: http://screensnapr.com/v/KenboP.png

This is my thread count now after moderating 1000 threads at a time with over 5000+ threads and only took 12 min: http://screensnapr.com/v/XpNbFk.png