Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ v2.5.x
Author Message
southern
Client


Joined: Jan 29, 2004
Posts: 591
Location: Texas

PostPosted: Mon Jan 29, 2007 10:37 pm Reply with quote

Well, I upgraded to Nukesentinel 2.5.05 and no errors were reported. I checked the Tracked IPs, just clicking around the upgrade, and it said no IPs in database. OK, so what? Then I clicked into Maintenance and ran the Optimize database and I noticed an error there
Quote:

nuke_nsnst_tracked_ips Table is marked as crashed and last repair failed

So I clicked Repair database and got
Quote:

nuke_nsnst_tracked_ips Table 'xxxxxxxx_nuke.EXTENDED' doesn't exist

Of course that doesn't exist but to make sure I went to phpmyadmin and looked at the structure and got
Quote:

Error
SQL query:

SHOW INDEX FROM `nuke_nsnst_tracked_ips` ;

MySQL said:

#1016 - Can't open file: 'nuke_nsnst_tracked_ips.MYI' (errno: 144)

I tried to drop the table but got that error again. Where is this s***t coming from? All the other Sentinel tables are proper, it is just this tracked_ips table that is off. I need some code to plug into phpmyadmin to drop the 2.5.05 tracked_ips table and create it again. Thanks very.

_________________
Computer Science is no more about computers than astronomy is about telescopes.
- E. W. Dijkstra 
View user's profile Send private message Visit poster's website MSN Messenger ICQ Number
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Tue Jan 30, 2007 2:31 am Reply with quote

its not realy my field but thats corrupted and if im not mistaken you cannot repair it yourself...bit out of range.

you can't repair the corruption because myisamchk command to repair the database is outputting seg fault (core dump) messages indicating hardware causing corruption.

Best thing to do is to contact your host and ask to repair it..
 
View user's profile Send private message
southern
PostPosted: Tue Jan 30, 2007 9:52 am Reply with quote

Thanks very much, hitwalker, I'll get my host to fix this then. It's his hardware...
 
Raven
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Tue Jan 30, 2007 10:17 am Reply with quote

There is no hardware issue. It's simply a corrupted index file. I used phpMyAdmin and ran a repair on the table and it fixed it as it's supposed to Smile
 
View user's profile Send private message
southern
PostPosted: Tue Jan 30, 2007 11:50 am Reply with quote

Thanks O great corbil Smile
RavensScripts
 
hitwalker
PostPosted: Tue Jan 30, 2007 12:12 pm Reply with quote

repairing it could only be done by host,i didnt knew it was at raven... Laughing
 
Raven
PostPosted: Tue Jan 30, 2007 1:13 pm Reply with quote

hitwalker wrote:
repairing it could only be done by host,i didnt knew it was at raven... Laughing


I assumed that. That's why I didn't jump all over the post killing me speedtype
 
southern
PostPosted: Tue Jan 30, 2007 2:04 pm Reply with quote

Yeh I put the meat and beans and beer on his table heh It all works fine now, thanks hitwalker and Raven Smile
 
Raven
PostPosted: Tue Jan 30, 2007 8:50 pm Reply with quote

OffTopic

southern,

How far back do we go? I have an email from you on 8/30/2003 for a hosting quote, but I'm pretty sure we were aquainted before that.
 
southern
PostPosted: Wed Jan 31, 2007 8:54 am Reply with quote

If so it must be under other pseudonyms elsewhere on the net but I can't recall where. Our current webhost-client association goes back to August 2003 and officially October of that year, as near as my few brain cells can figure. May there be many more years. Smile
 
Raven
PostPosted: Wed Jan 31, 2007 11:12 am Reply with quote

Cheers
 
BobMarion
Former Admin in Good Standing


Joined: Oct 30, 2002
Posts: 1037
Location: RedNeck Land (known as Kentucky)

PostPosted: Wed Jan 31, 2007 11:05 pm Reply with quote

Just for safey's sake I've run the upgrader on several databases and find no indications that it was caused by it. If any one else finds a problem let me know.

_________________
Bob Marion
Codito Ergo Sum
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Send e-mail Visit poster's website
Raven
PostPosted: Thu Feb 01, 2007 12:29 am Reply with quote

Shocked - He is alive Wave
 
hitwalker
PostPosted: Thu Feb 01, 2007 4:42 am Reply with quote

yes he is !
can someone please take a picture of this....... killing me
 
southern
PostPosted: Thu Feb 01, 2007 10:53 am Reply with quote

Image Hi BobMarion Smile
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™ v2.5.x

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©