installSQL.php error

tourniqu3t · Hangin' Around Joined: Jan 16, 2009 Posts: 40

I chose to upgrade from 2.3 version to 2.4. I am actually doing a fresh install instead. I seem that Raven or someone else wrote a wrong code in installSQL.php. You may look at this.

I clicked on step 3b.

Error said

The exact error message that your MySQL server reported is:
MySQL Error # 4 at line 117 in file installSQL.php ==> Duplicate entry '1401432064-1401434111-ie' for key 1

Error in ns_ip2c3.sql.gz at line 1:
INSERT INTO `nuke_nsnst_ip2country` (`ip_lo`, `ip_hi`, `date`, `c2c`) VALUES (1401432064, 1401434111, 1217134800, 'ie');

nuken · Posted: Mon Aug 23, 2010 3:52 pm

Are you using the latest version, 2.40.01?

tourniqu3t · Hangin' Around Joined: Jan 16, 2009 Posts: 40

Yes, that's correct.

sixonetonoffun · Posted: Tue Aug 24, 2010 5:29 am

Reporting errors of this nature without including server info php and mysql versions especially make it very difficult to... well to do anything.

In my case I had a failed install due to the latest PHP Version 5.3.2 date issues.
PHP 5.3 problem: Warning: date() [function.date]: It is not safe ...
I was able to quickly find a dirty hack to fix it but it was specific to my php version.

jestrella · Posted: Tue Aug 24, 2010 9:50 pm

If you get to this point, It means that the base system sql tables have been populated, so your system must be usable at the moment. But is still weird that error message being displayed.

I'll have to try a fresh install when possible and then report back....

dad7732 · Posted: Wed Aug 25, 2010 8:44 am

FWIW, I did two fresh installs with the same PHP version 5.3.2 and no errors whatsoever. I wonder if dropping the IP2C table and then using the installSQL once again this time only loading those tables will work. I've done just that in the past with success.

dad7732 · Posted: Wed Aug 25, 2010 1:16 pm

Also wondering if the gzip may be problematic for whatever reason. I'm thinking of my problems with 5.3.2 and apache mods.

tourniqu3t · Hangin' Around Joined: Jan 16, 2009 Posts: 40

jestrella wrote:

If you get to this point, It means that the base system sql tables have been populated, so your system must be usable at the moment. But is still weird that error message being displayed.

I'll have to try a fresh install when possible and then report back....

Everything include SQL is fresh.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

tourniqu3t, just to clarify, did you drop the tables first or install to a new database? Knowing that will help us determine how to address this.

dad7732 · Posted: Wed Aug 25, 2010 3:31 pm

Find your PHP.INI file and then look for the timezone setting:

For your timezone, edit the line or uncomment it, such as:

Code:

date.timezone = "America/New_York"

That's just an example.

Cheers, let us know how it turns out.

BTW: On new installs of PHP 5.3.2, the date line is usually commented out.

tourniqu3t · Hangin' Around Joined: Jan 16, 2009 Posts: 40

kguske wrote:

tourniqu3t, just to clarify, did you drop the tables first or install to a new database? Knowing that will help us determine how to address this.

I dropped all tables first before I start to install.

Everything is fresh. That's all I did.

dad7732 · Posted: Thu Aug 26, 2010 6:24 am

Have you tried the PHP.INI edit?? I'm thinking that will do it.

Mine is set to:

Code:

date.timezone="US/Central"

Palbin · Posted: Thu Aug 26, 2010 6:51 am

dad7732 wrote:

Have you tried the PHP.INI edit?? I'm thinking that will do it.

Mine is set to:

Code:

date.timezone="US/Central"

dad7732 what is the reason you are asking him to do that?

dad7732 · Posted: Thu Aug 26, 2010 7:28 am

Because I googled the error and one of the fixes was to configure the correct timezone entry in PHP.INI

I think it's worth a shot anyways ..

Nevermind, I'm looking at the wrong reply .. Sad

Raven · Posted: Fri Aug 27, 2010 7:38 am

A duplicate entry error usually means you tried loading the tables without dropping them first.

tourniqu3t · Hangin' Around Joined: Jan 16, 2009 Posts: 40

Raven wrote:

A duplicate entry error usually means you tried loading the tables without dropping them first.

Ok, I will try again tomorrow morning.

tourniqu3t · Hangin' Around Joined: Jan 16, 2009 Posts: 40

Sorry to keep you waiting for an answer from me. I struggled with upload. It's solved. And installSQL.php is successful now. Smile