Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™
Author Message
fastgun
New Member
New Member


Joined: Jun 02, 2006
Posts: 6

PostPosted: Tue Feb 27, 2007 2:32 pm Reply with quote

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.
 
View user's profile Send private message
BobMarion
Former Admin in Good Standing


Joined: Oct 30, 2002
Posts: 1037
Location: RedNeck Land (known as Kentucky)

PostPosted: Wed Feb 28, 2007 5:56 pm Reply with quote

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;

_________________
Bob Marion
Codito Ergo Sum
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Send e-mail Visit poster's website
fastgun
PostPosted: Wed Feb 28, 2007 10:05 pm Reply with quote

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?
 
BobMarion
PostPosted: Thu Mar 01, 2007 1:13 am Reply with quote

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.
 
fastgun
PostPosted: Thu Mar 01, 2007 10:09 am Reply with quote

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?
 
BobMarion
PostPosted: Thu Mar 01, 2007 10:24 am Reply with quote

Which fields are you missing and I'll post the exact sql queries to get you upto date.
 
fastgun
PostPosted: Thu Mar 01, 2007 3:46 pm Reply with quote

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.
 
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> NukeSentinel™

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 ©