Problems accessing IP banlist. Fatal Error.

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Get Involved

Problems accessing IP banlist. Fatal Error.

Postby krisboro » Thu Aug 06, 2009 3:55 pm

Hi,

I'm trying to access the IP ban list in the admin control panel, but I get this message when I click on the link "fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 24 bytes) in /home2/jackbloo/public_html/phpBB3/includes/acp/acp_ban.php on line 222"

Before we switched to phpBB3, we had a pretty huge IP banlist, which banned entire IP ranges from Eastern Europe and China. I've never been able to access the list since we switched.
Could it be that our list is too large?
I'm actually wanting to just delete all the banned IP's and start again.
I can see the IP's when I use phpMyAdmin, but don't see a way to delete all of the IP's without doing them individually, which would take hours.

Any ideas?
Last edited by krisboro on Thu Aug 06, 2009 4:06 pm, edited 1 time in total.
krisboro
Registered User
 
Posts: 12
Joined: Fri Jul 21, 2006 8:33 am

Re: Probelms accessing IP banlist. Fatal Error.

Postby narqelion » Thu Aug 06, 2009 3:59 pm

krisboro wrote:Could it be that our list is too large?
That is exactly the problem. You will need to delete them from the db. Just empty the table, do not drop, empty. :)
I offer free private support, you can contact me directly via email.
Finally, the Definitive American English Language Pack for phpBB3 - Available December 2010
“She who angers you conquers you." - Elizabeth Kenny :D
# of Styles in Style Database = 165 169 / # of GPL Styles in Style Database = 0
User avatar
narqelion
I've Been Banned!
 
Posts: 7235
Joined: Sat Dec 13, 2008 5:00 pm

Re: Problems accessing IP banlist. Fatal Error.

Postby krisboro » Thu Aug 06, 2009 4:07 pm

Thank you, sir!
krisboro
Registered User
 
Posts: 12
Joined: Fri Jul 21, 2006 8:33 am

Re: Problems accessing IP banlist. Fatal Error.

Postby daroPL » Thu Aug 06, 2009 4:10 pm

Or increase the memory size for running scripts. If you use a hosting you should contact with your provider.
User avatar
daroPL
Registered User
 
Posts: 512
Joined: Tue Mar 27, 2007 11:58 am
Location: Poznan, Poland
Name: Darek

Re: Problems accessing IP banlist. Fatal Error.

Postby narqelion » Thu Aug 06, 2009 4:12 pm

Welcome. You might want to investigate alternatives to banning via phpBB, in a shared hosting environment when you start defining large ranges you hit the PHP memory limit as you have now discovered. It's not really the most effective tool for the job. If it's even necessary, which in most cases it is not. :)
I offer free private support, you can contact me directly via email.
Finally, the Definitive American English Language Pack for phpBB3 - Available December 2010
“She who angers you conquers you." - Elizabeth Kenny :D
# of Styles in Style Database = 165 169 / # of GPL Styles in Style Database = 0
User avatar
narqelion
I've Been Banned!
 
Posts: 7235
Joined: Sat Dec 13, 2008 5:00 pm


Return to 3.0.x Support Forum

Who is online

Users browsing this forum: Bing [Bot], kacper3355, Oyabun1, roger12, s1mona, venux, xiaolu and 74 guests