problem with tracked_ips table

t_henson · Posted: Wed Mar 14, 2007 1:53 pm

i recently noticed that my tracked_ips table was missing. i know i never deleted it, so it seems kinda weird that it would just dissapear. i tried to upgrade to 2.5 but parts of the install failed because of the missing table. how would i go about repairing it?

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

well answering as to why it disapeared or how is a bit hard...
solving it is easier...

use this one.....
it hold no tracked ip....so i cleared it....

Code:

CREATE TABLE `nuke_nsnst_tracked_ips` (
`tid` int(10) NOT NULL auto_increment,
`ip_addr` varchar(15) NOT NULL default '',
`ip_long` int(10) unsigned NOT NULL default '0',
`user_id` int(11) NOT NULL default '1',
`username` varchar(60) NOT NULL default '',
`user_agent` text NOT NULL,
`refered_from` text NOT NULL,
`date` int(20) NOT NULL default '0',
`page` text NOT NULL,
`x_forward_for` varchar(32) NOT NULL default '',
`client_ip` varchar(32) NOT NULL default '',
`remote_addr` varchar(32) NOT NULL default '',
`remote_port` varchar(11) NOT NULL default '',
`request_method` varchar(10) NOT NULL default '',
`c2c` char(2) 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`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

t_henson · Posted: Wed Mar 14, 2007 3:15 pm

okay thanks. apparently the table did exist and there is another problem. here is what it says in the nukesentinel database structure

nuke_nsnst_tracked_ips Table 'ohiomini_nuke1.EXTENDED' doesn't exist 0 0.00 Kb

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

you have updated sentinel ?

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

and even better,before diving in it to much...to rule out any other problems just reinstall sentinel...

t_henson · Posted: Thu Mar 15, 2007 1:49 am

yeah i had sentinel uploaded before and everything worked fine. i went ahead and uninstalled the tables and then reinstalled the 2.5 so everything is working good now. only downside is i lost my banned ip's, forgot to save that part lol. thanks for the help though, hitwalker.

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

yes sometimes you forget something huh...
but doesnt realy matter...
people who wanna get banned return and get banned again....so no problem there.. Laughing

dad7732 · Posted: Tue Apr 17, 2007 8:17 am

Thank you to "hitwalker" for posting the table creation for tracked_ips as it solved my problem after Verio transferred my VPS to another physical server. I DROPPED the existing table and recreated using your code and it worked like a charm .. THANKS

Jay

hitwalker · Sells PC To Pay For Divorce Joined: Posts: 5661

your welcome dad7732 Wink

dad7732 · Posted: Tue Apr 17, 2007 9:53 am

I always take the time to reply with a "thanks it worked" as it means a lot to folks who supply fixes and solutions in this free medium.

/jay