The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
threads awaiting moderation Crash!
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. |
#2
|
|||
|
|||
Maybe the easiest thing would be to edit the file modcp/moderate.php and around line 353 change it like this (red added):
Code:
$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). |
#3
|
|||
|
|||
Quote:
I have done the limit to 1000 and it works fantasticly, thank you very very much I appreciate your help. see: Code:
$moderated = $db->query_read(" SELECT * FROM " . TABLE_PREFIX . "moderation WHERE type IN ('thread', 'reply') LIMIT 1000 "); 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 |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|