Author |
Message |
azism
Worker
Joined: Feb 02, 2005
Posts: 145
Location: Tucson, AZ
|
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. |
_________________ Webmaster
TI99ers On-Line User Group
[ Only registered users can see links on this board! Get registered or login! ] |
|
|
|
Raven
Site Admin/Owner
Joined: Aug 27, 2002
Posts: 17088
|
Posted:
Wed Feb 28, 2007 10:04 pm |
|
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. |
|
|
|
|
azism
|
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. |
|
|
|
|
Raven
|
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? |
|
|
|
|
azism
|
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.
Plus I don't find anything in the error log. It's working now, so that's what counts. |
|
|
|
|
FireATST
RavenNuke(tm) Development Team
Joined: Jun 12, 2004
Posts: 654
Location: Ohio
|
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.... |
|
|
|
|
evaders99
Former Moderator in Good Standing
Joined: Apr 30, 2004
Posts: 3221
|
Posted:
Fri Mar 02, 2007 3:20 pm |
|
Well...
Quote: |
There is a limit of 232 (~4.295E+09) rows in a MyISAM table.
[ Only registered users can see links on this board! Get registered or login! ]
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.
[ Only registered users can see links on this board! Get registered or login! ]
|
|
_________________ - Star Wars Rebellion Network -
Need help? Nuke Patched Core, Coding Services, Webmaster Services |
|
|
|
FireATST
|
Posted:
Sat Mar 03, 2007 9:22 am |
|
ty sir..... that is a lot of space....lol |
|
|
|
|
|