"nuke_nsnst_tracked_ips" table issue.

djslue · 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

Gremmie · 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.

Gremmie · 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.

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

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

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

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

Susann · 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.

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

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.

Gremmie · Posted: Fri Jul 25, 2008 12:58 pm

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

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

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

Gremmie · 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;

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

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

Gremmie · Posted: Fri Jul 25, 2008 3:07 pm