Request Entity Too Large

[14kvision]

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]

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

	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]

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

Any other ideas?

[kh99]

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

   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]

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]

Great info. Saved me a struggle!