vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=251)
-   -   Request Entity Too Large (https://vborg.vbsupport.ru/showthread.php?t=275459)

14kvision 12-14-2011 12:21 AM

Request Entity Too Large
 
Hi, When trying to delete hundreds of spam posts which are under "Moderated Posts" in the CP I get the following message:

----------------------------------------

Request Entity Too Large

The requested resource
/forum/modcp/moderate.php
does not allow request data with POST requests, or the amount of data provided in the request exceeds the capacity limit.

----------------------------------------

Anyone know how to fix this so I can delete all these posts at once? Thanks

kh99 12-14-2011 02:50 PM

You could try this: edit the file modcp/moderate.php, and around line 385 make this change (add the part in red):

Code:

        WHERE $sql AND thread.threadid IN ($threadids)
        ORDER BY thread.lastpost LIMIT 100
");


then you won't see them all at the same time, but once you delete a batch you should be able to go back and see the next batch. Also, I just picked 100 arbitrarily, you may be able to increase it and still have it work.

14kvision 12-14-2011 04:30 PM

Thanks for the suggestion but I tried it and it didn't work! :( (I even increased the number over 100)

Any other ideas?

kh99 12-14-2011 04:34 PM

Hmm...that may have been the wrong place. Try this, around line 355:

Code:

  FROM " . TABLE_PREFIX . "moderation
  WHERE type IN ('thread', 'reply') LIMIT 100");


and if it still happens maybe try reducing the number to less than 100.

Is the error happening when you submit the page after selecting the psts to delete?

14kvision 12-14-2011 05:08 PM

Correct, the error is happening when I submit the page after selecting the posts I want to delete.

--------------- Added [DATE]1323886504[/DATE] at [TIME]1323886504[/TIME] ---------------

IT'S WORKING!!!!

THANK YOU THANK YOU THANK YOU!!!!

It basically is bringing up 100 at a time and then allowing me to delete them... this is def. better then going through each one individually... thank you !!

BoostedK20 05-13-2013 02:14 PM

Great info. Saved me a struggle!


All times are GMT. The time now is 08:15 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.00973 seconds
  • Memory Usage 1,717KB
  • 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
  • (2)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (6)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