| Author |
Message |
azism
Worker
Joined: Feb 02, 2005
Posts: 124
Location: Tucson, AZ
|
 Posted:
Wed Mar 14, 2007 4:35 pm |
 
|
I downloaded from NukeScripts.com a new IP2Country file. The first thing I notice is that the SQL file I am using has a 5th column called Country while to new IP2Country only has four columns, ip-lo, ip-hi, date and c2c. Now it doesn't take a rocket scientist to know this won't work.
Suggestions??? |
|
|
  
|
|
persona_non_grata
Joined:
Posts: 0
|
| Posted:
Wed Mar 14, 2007 5:33 pm |
|
your absolutely right...
but could it be because your running older NukeSentinel(tm) 2.4.2 ? |
|
|
|
|
|
fkelly
Moderator
Joined: Aug 30, 2005
Posts: 2093
Location: near Albany NY
|
| Posted:
Wed Mar 14, 2007 5:35 pm |
|
A Rocket Scientist I ain't but you appear to be right. I had downloaded the upgrade to Sentinel 2.5.07 earlier today but that didn't have the SQL files in it. The full distribution at Nukescripts, has SQL files for individual countries, and like you say only four columns are in there. For example:
| Code: | DELETE FROM `nuke_nsnst_ip2country` WHERE `c2c`='az';
INSERT INTO `nuke_nsnst_ip2country` (`ip_lo`, `ip_hi`, `date`, `c2c`) VALUES (1054138368, 1054146559, 1109653200, 'az'); |
Ahhhaaa. No, checking further the country field was dropped when the upgrade to version 2.5.02 was done. So you must be way out of date with versions. 2.5.07 was just released and you might want to move to that. Or you could install RN2.10 and run the upgrade script to get you to Sentinel 2.5.06 and then run the Sentinel script to get you to 2.5.07. |
|
|
|
|
|
azism
Worker
Joined: Feb 02, 2005
Posts: 124
Location: Tucson, AZ
|
| Posted:
Wed Mar 14, 2007 7:47 pm |
|
Whew, another upgrade. Well, it may be a couple months before I can tackle it as I just have way too many pokers in the fire right now. Does this mean upgrading Nuke also as I have version 7.6. |
|
|
|
|
|
persona_non_grata
Joined:
Posts: 0
|
| Posted:
Thu Mar 15, 2007 4:59 am |
|
no...just upgrade sentinel....
just download the proper version to upgrade....
or delete sentinel and just install the newest.... |
|
|
|
|
|
azism
Worker
Joined: Feb 02, 2005
Posts: 124
Location: Tucson, AZ
|
| Posted:
Thu Mar 15, 2007 8:45 am |
|
Ah, that's a relief. 
As long as php-Nuke (actually RavenNuke) 7.6 is still good. I sure don't want to upgrade that at this time. In fact, I'd just as soon not upgrade the Nuke itself at anytime. But, I suppose the day will come where I will have to.  |
|
|
|
|
|
|
|
|
|
![[Valid RSS]](http://ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
:: 
::
