problem with tracked_ips table

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?

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 ;

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

Posted: Wed Mar 14, 2007 3:31 pm

you have updated sentinel ?

Posted: Wed Mar 14, 2007 3:47 pm

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

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.

Posted: Thu Mar 15, 2007 5:01 am

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

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

Posted: Tue Apr 17, 2007 9:20 am

your welcome dad7732 Wink

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