vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   threads awaiting moderation Crash! (https://vborg.vbsupport.ru/showthread.php?t=270061)

SᴩiDᴇЯ 09-11-2011 06:32 AM
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.

kh99 09-11-2011 12:10 PM
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).

SᴩiDᴇЯ 09-11-2011 02:52 PM
Quote:
Originally Posted by kh99 (Post 2244562)
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).
Hi kh99,

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
        ");
--------------- Added [DATE]1315759426[/DATE] at [TIME]1315759426[/TIME] ---------------

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


All times are GMT. The time now is 01:12 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01021 seconds
  • Memory Usage 1,719KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete