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.5.x
Author Message
kevinkap
Involved
Involved


Joined: Apr 22, 2006
Posts: 356

PostPosted: Thu Oct 11, 2007 7:14 pm Reply with quote

I am trying to update the ip to country data. I uploaded the html/import file on two sites, I was able to import all data on one site, on the other, none of the data is imported. What would cause this? Sentinel is updated to the latest version.

_________________
Kevin Kappes 
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: Thu Oct 11, 2007 10:46 pm Reply with quote

That happens from time to time and I have found that the best route is to delete the table and then recreate it. Below is a sql query that will do just that in phpMyAdmin which you should have access to through your sites hosting control panel. If you don't have access to run the query let me know and I'll create a short php file that will do it for you.

Code:
DROP TABLE IF EXISTS `nuke_nsnst_ip2country`;

CREATE TABLE IF NOT EXISTS `nuke_nsnst_ip2country` (
  `ip_lo` int(10) unsigned NOT NULL default '0',
  `ip_hi` int(10) unsigned NOT NULL default '0',
  `date` int(20) NOT NULL default '0',
  `c2c` char(2) NOT NULL default '',
  PRIMARY KEY  (`ip_lo`,`ip_hi`),
  KEY `c2c` (`c2c`),
  KEY `date` (`date`)
) TYPE=MyISAM;


This query assumes your sites prefix is nuke and not something else. If it is different then change the two `nuke_ to `WHATEVERITIS_. Once the table is recreated you should be able to import that data normally thru NukeSentinel(tm)s admin panel.

_________________
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
kevinkap
PostPosted: Fri Oct 12, 2007 3:03 pm Reply with quote

That seems to have fixed it. Thanks.
 
redhairz
Worker
Worker


Joined: Nov 17, 2006
Posts: 222

PostPosted: Fri Nov 23, 2007 11:27 am Reply with quote

BobMarion wrote:
That happens from time to time and I have found that the best route is to delete the table and then recreate it. Below is a sql query that will do just that in phpMyAdmin which you should have access to through your sites hosting control panel. If you don't have access to run the query let me know and I'll create a short php file that will do it for you.

Code:
DROP TABLE IF EXISTS `nuke_nsnst_ip2country`;

CREATE TABLE IF NOT EXISTS `nuke_nsnst_ip2country` (
  `ip_lo` int(10) unsigned NOT NULL default '0',
  `ip_hi` int(10) unsigned NOT NULL default '0',
  `date` int(20) NOT NULL default '0',
  `c2c` char(2) NOT NULL default '',
  PRIMARY KEY  (`ip_lo`,`ip_hi`),
  KEY `c2c` (`c2c`),
  KEY `date` (`date`)
) TYPE=MyISAM;


This query assumes your sites prefix is nuke and not something else. If it is different then change the two `nuke_ to `WHATEVERITIS_. Once the table is recreated you should be able to import that data normally thru NukeSentinel(tm)s admin panel.


Thanks can this thread be place under sticky i am sure many will find this handy?

_________________
Jesus is Alive, He is our joy, be it good times or bad time. 
View user's profile Send private message
Susann
Moderator


Joined: Dec 19, 2004
Posts: 3191
Location: Germany:Moderator German NukeSentinel Support

PostPosted: Sat Nov 24, 2007 7:31 am Reply with quote

I use only PhpMyAdmin and click there usally empty table which means truncate table if something isn´t okay with the entries in nuke_nsnst_ip2country table and afterthat I start again with IP2Country.
SQL query:
Code:
 

TRUNCATE TABLE `nuke_nsnst_ip2country`


To delete the table I would also use PHPMyAdmin.
Its a simple procedure.
 
View user's profile Send private message
montego
Site Admin


Joined: Aug 29, 2004
Posts: 9456
Location: Arizona

PostPosted: Sun Nov 25, 2007 10:59 am Reply with quote

Ok, I've enhanced the title slightly and made this a Sticky.

_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website
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.5.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 ©