Problem installing IP2COUNTRY data!!!!!!!!

New Member Joined: May 02, 2008 Posts: 5

This is the first time I install RavenNuke and everything's fine until I try to upload the IP2COUNTRY data in steps "Step 6e" and "Step 6f"

At Step 6e (5/6) an error message appears:

"MySQL Error # 4 = You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"

And at Step 6f (6/6) this error message appears:

"MySQL Error # 4 = Duplicate entry '1362100224-1362395135' for key 1"

Am I doing something wrong?, I swear I haven't touched a single file other that the "config.php" file, I followed the instructions to the letter and no matter what I try I still get the error.

What should I do?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Have you tried starting over with the IP2COUNTRY load? Use phpMyAdmin and EMPTY the IP2COUNTRY table. Then run the install script and start with the 6a step. If it continues to fail then post back. BTW, make sure that when you uploaded the sql files you used BINARY and not ASCII.

Posted: Sat May 03, 2008 1:43 am

ffloty, I've just realised you have double post. Please do not double post, please choose a forum and make a post. If it is in the wrong forum then we will move it to a more suitable location. Smack

Posted: Sun May 04, 2008 9:09 am

Raven wrote:

Have you tried starting over with the IP2COUNTRY load? Use phpMyAdmin and EMPTY the IP2COUNTRY table. Then run the install script and start with the 6a step. If it continues to fail then post back. BTW, make sure that when you uploaded the sql files you used BINARY and not ASCII.

Yes, that was the first thing I did when I got the error message, but the funny thing is that when I install it on my computer with Apache there's no problem, but when I upload the files to my website I get the error message.
and yes I made sure I used BINARY.

Posted: Sun May 04, 2008 11:31 pm

So, what web server are you using for your website?

Posted: Mon May 05, 2008 4:39 pm

ByeHost
[ Only registered users can see links on this board! Get registered or login! ]

Posted: Mon May 05, 2008 9:18 pm

Web server, as in IIS, Apache, etc.

Posted: Fri May 09, 2008 2:25 pm

Apache

New Member Joined: May 22, 2008 Posts: 1

I also am having this issue with hostgator.com, so I am also interested in the result.

Posted: Fri May 23, 2008 4:55 am

I am not sure if there is an issue or not with the provided IP2C data, however, it is very important that you keep this data up-to-date anyways, and BobMarion has posted several updates since (including a NukeSentinel upgrade or two - another one to keep up on).

Therefore, what I would suggest both of you do is get the latest IP2C data from [ Only registered users can see links on this board! Get registered or login! ] and just install that. You can either use the SQL files, or upload the "import" directory and then use the IP To Country -> Import Data -> Import to IP2Country feature.