IPBan stopped working

Posted: Tue Feb 27, 2007 10:48 am

All of a sudden the IP Ban (Site Admin IPBan) in the RavenNuke 7.6 has stopped working. I can't add anything to it. What I get, after a long wait, is a 404 message which is pointing to "http://www.mysite.org/admin.php?op=ipban". Any idea why this is happening?

I have about 31000 IP addresses entered into the SQL table. Should I maybe clear out the SQL table and start over???

As far as I can tell, Nuke Sentinel is working fine. However, I am concerned about the subdomains I have on my site.

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Quote:

I have about 31000 IP addresses entered into the SQL table. Should I maybe clear out the SQL table and start over???

Ya THINK?

More than likely it's an sql error that you can't see. Empty it out and then see what happens.

Posted: Thu Mar 01, 2007 9:40 am

Okay, I did just that and it is okay now. I just didn't want to go that route until I had another opinion. Thanks.

Funny, I tried the SQL repair, and that didn't help. No matter, it is working now. Smile

Posted: Thu Mar 01, 2007 9:49 am

Did you happen to check your server error log? Also, is it possible that you are/were running out of space?

Posted: Thu Mar 01, 2007 12:07 pm

Space is one thing I don't have a problem with. I have unlimitied space, bandwidth and sql databases. The one advantage to running my site on a host run by a friend. Wink

Plus I don't find anything in the error log. It's working now, so that's what counts.

Posted: Fri Mar 02, 2007 6:06 am

I have always wonder, is there a default limit in mySql to the storage size of a table? The DB will hold so much information till this limit is reached? Trying to learn.... Smile

registered · Posted: Fri Mar 02, 2007 3:20 pm

Well...

Quote:

There is a limit of 232 (~4.295E+09) rows in a MyISAM table.

http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html

InnoDB

A table cannot contain more than 1000 columns.
the maximum row length is about 8000 bytes
The minimum tablespace size is 10MB. The maximum tablespace size is four billion database pages (64TB). This is also the maximum size for a table.

http://dev.mysql.com/doc/refman/5.0/en/innodb-restrictions.html

Posted: Sat Mar 03, 2007 9:22 am

ty sir..... Smile

that is a lot of space....lol