Upgrade to 2.5.05

New Member Joined: Jun 02, 2006 Posts: 6

I just upgraded my Nuke Sentinel tables to 2.5.05. The upgrade script appeared to run fine and I received the message that the upgrade was successful.

Now I notice that when I go to the tracked IP screen and click the display tracked IP link my installation is no longer updating. The IP tracking entries stopped on the day I upgraded the tables. The admin menu indicates I have IP tracking set to ON.

Any help resolving this issue would be appreciated.

registered · Posted: Wed Feb 28, 2007 5:56 pm

Try two things:
1) make sure you have uploaded the 2.5.05 includes/nukesentinel.php file
2) goto phpmyadmin and have it check the $prefix _nsnst_tracked_ips table

If the second reports the table is damaged have phpmyadmin repair the table. If the table is missing readd the table thru phpmyadmin with:

Code:

DROP TABLE IF EXISTS `nuke_nsnst_tracked_ips`;


CREATE TABLE IF NOT EXISTS `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 `user_id` (`user_id`),


  KEY `username` (`username`),


  KEY `ip_addr` (`ip_addr`),


  KEY `c2c` (`c2c`),


  KEY `date` (`date`),


  KEY `ip_long` (`ip_long`),


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


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


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


) TYPE=MyISAM;

Posted: Wed Feb 28, 2007 10:05 pm

Thanks for the help. I checked the file and it appears that I uploaded the nukesentinel.php file successfully. The file date and file size is correct.

I also checked the nsnst_tracked_ips table through phpMyAdmin and it reported:

Table Op Msg_type Msg_text
nuke_nsnst_tracked_ips check status OK

I'm new to this so what would you suggest now? Would un-installing NukeSentinel and re-installing it correct the problem? If so, how would I un-install the module and tables?

Posted: Thu Mar 01, 2007 1:13 am

Looking at the table listing above, make sure your table has all the fields it shows, no more and no less. It could be as simple as a past update having been missed.

Posted: Thu Mar 01, 2007 10:09 am

There are more fields listed above than in my existing table so I assume you are correct and I missed a past update. How do I correct this?

Posted: Thu Mar 01, 2007 10:24 am

Which fields are you missing and I'll post the exact sql queries to get you upto date.

Posted: Thu Mar 01, 2007 3:46 pm

Thanks again. In reviewing the fields in the nuke_nsnst_tracked_ips table the only one that appears to be missing is the 'refered_from' field.

If I missed an update that caused my current problem are any other NukeSentinel functions/tables affected by this oversight? I noticed the tracked IP issue because I check that all the time.