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.4.x
Author Message
t_henson
Regular
Regular


Joined: Feb 02, 2007
Posts: 65
Location: Cincinnati, Ohio

PostPosted: Wed Mar 14, 2007 1:53 pm Reply with quote

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?
 
View user's profile Send private message
hitwalker
Sells PC To Pay For Divorce


Joined:
Posts: 5661

PostPosted: Wed Mar 14, 2007 2:56 pm Reply with quote

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 ;

 
View user's profile Send private message
t_henson
PostPosted: Wed Mar 14, 2007 3:15 pm Reply with quote

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
PostPosted: Wed Mar 14, 2007 3:31 pm Reply with quote

you have updated sentinel ?
 
hitwalker
PostPosted: Wed Mar 14, 2007 3:47 pm Reply with quote

and even better,before diving in it to much...to rule out any other problems just reinstall sentinel...
 
t_henson
PostPosted: Thu Mar 15, 2007 1:49 am Reply with quote

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
PostPosted: Thu Mar 15, 2007 5:01 am Reply with quote

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
RavenNuke(tm) Development Team


Joined: Mar 18, 2007
Posts: 1242

PostPosted: Tue Apr 17, 2007 8:17 am Reply with quote

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
 
View user's profile Send private message
hitwalker
PostPosted: Tue Apr 17, 2007 9:20 am Reply with quote

your welcome dad7732 Wink
 
dad7732
PostPosted: Tue Apr 17, 2007 9:53 am Reply with quote

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
 
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.4.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 ©