"nuke_nsnst_tracked_ips" table issue.

Hangin' Around Joined: Sep 26, 2007 Posts: 34

I have all the tables repaired but 1 The "nuke_nsnst_tracked_ips" I tried to repair it but keeps failing. It is a table for "NukeSentinel(tm) 2.6.00." I have tracking ips turned off in "NukeSentinel(tm) 2.6.00" and don't really need to track ips. This is the error I get when doing a check in MySQL Account Maintenance

Code:

Error    : Table './wwwhiph_nuke1/nuke_nsnst_tracked_ips' is marked as crashed and last (automatic?) repair failed


Error    : Table 'nuke_nsnst_tracked_ips' is marked as crashed and last (automatic?) repair failed


status   : Table is already up to date

With this table corrupt I can't do a "Download a MySQL Database Backup" through cpanel. I removed the table "nuke_nsnst_tracked_ips" from the database and I can now do a "MySQL Database Backup" Do I need to have this table added ? If so how can I fix it ? I have a backup of it from a few weeks ago but couldn't seem to get it import and work correctly.

Thanks in advance for the help.

Steve

registered · Posted: Fri Jul 25, 2008 7:02 am

If you want to have the tracked IP feature you should have this table. Just find the SQL for it in the install script or your backup and re-run it in phpMyAdmin to restore it.

Posted: Fri Jul 25, 2008 7:03 am

Also, the next time the table gets whacked out like that, try running a REPAIR from phpMyAdmin on it.

Posted: Fri Jul 25, 2008 11:27 am

If I don't want to track ip's is it fine not to have it ?

Posted: Fri Jul 25, 2008 11:48 am

I did run repair but it wouldn't fix it.

Posted: Fri Jul 25, 2008 12:08 pm

Quess thats because there were invalid entires in this table. Didn´t you try to empty the table or only the invalid entry ?

Creat this table new like Gremmie already said.

Posted: Fri Jul 25, 2008 12:49 pm

I have a backup of the old one and tried to import that after emptying the old one but it keeps timing out when I try and upload it. Its ony 2 mb. I even tried .zip it and its like 220 kbs and still wont upload.

Posted: Fri Jul 25, 2008 12:58 pm

Just restore an empty table. Just run the CREATE TABLE SQL.

Posted: Fri Jul 25, 2008 1:09 pm

I went am imported a blank "nuke_nsnst_tracked_ips.sql" file. Is that correct ? It gave me this message here

"Import has been successfully finished, 0 queries executed."

Sorry I am not the best at this.

Thanks again for help.

Steve

Posted: Fri Jul 25, 2008 2:18 pm

Open your phpMyAdmin, navigate to your database. Find the SQL tab. Copy and paste this into it and hit go.

Code:




CREATE TABLE `nuke_nsnst_tracked_ips` (


  `tid` int(10) NOT NULL auto_increment,


  `ip_addr` varchar(15) character set latin1 NOT NULL default '',


  `ip_long` int(10) unsigned NOT NULL default '0',


  `user_id` int(11) NOT NULL default '1',


  `username` varchar(60) character set latin1 NOT NULL default '',


  `user_agent` text character set latin1 NOT NULL,


  `refered_from` text character set latin1 NOT NULL,


  `date` int(20) NOT NULL default '0',


  `page` text character set latin1 NOT NULL,


  `x_forward_for` varchar(32) character set latin1 NOT NULL default '',


  `client_ip` varchar(32) character set latin1 NOT NULL default '',


  `remote_addr` varchar(32) character set latin1 NOT NULL default '',


  `remote_port` varchar(11) character set latin1 NOT NULL default '',


  `request_method` varchar(10) character set latin1 NOT NULL default '',


  `c2c` char(2) character set latin1 NOT NULL default '00',


  PRIMARY KEY  (`tid`),


  KEY `ip_addr` (`ip_addr`),


  KEY `ip_long` (`ip_long`),


  KEY `user_id` (`user_id`),


  KEY `username` (`username`),


  KEY `user_agent` (`user_agent`(255)),


  KEY `refered_from` (`refered_from`(255)),


  KEY `date` (`date`),


  KEY `page` (`page`(255)),


  KEY `c2c` (`c2c`)


) ENGINE=MyISAM;

Posted: Fri Jul 25, 2008 2:35 pm

Seems to to have worked for me, Just did a "check" on it and all showing up ok.

Thank You Very Much for the help !

Steve

Posted: Fri Jul 25, 2008 3:07 pm