Official SEOW

Posted: **Wed 28 Jan 2009 6:29 pm**

I just finished my upgrades to Apache2.2.11, PHP 5.2.8 and MySQL 5.1.30

I did PHP first, then I did Apache. I then tested it out and everything was working fine. After I upgraded the MySQL server and then tested mw SEOW setup and ran into this problem.

I can pick Ardennes of the main page of the SEOW Mission Planner. I can log in ok. The initial Ardennes sector map loads up fine but if I try to request a district map or a detailed city map a get the "The website cannot display the page" error. This happens on any map I try.

Here is the Apache error...

[Wed Jan 28 17:21:47 2009] [error] [client 192.168.1.122] PHP Fatal error: Call to a member function Close() on a non-object in D:\\Apache2\\htdocs\\ScorchedEarth\\MP4\\Scripts\\MP-SQL.php on line 579

I am running DCS 3.1.20, SEOW Mission Planner 4.450 and the sedb31d sql files.

Any suggestions on what might fix this?

Thanks
Eric Cabral

Posted: **Thu 29 Jan 2009 6:26 pm**

Hi Eric,

I am just guessing here, but I suspect that your Ardennes DB is not compliant with your MP version. That is, the MP might be expecting something in your Ardennes DB that isn't acutally there. So are you certain that EVERY DB that your MP is pointing at is of the correct version, i.e. SEDB31d?

Cheers,
4Shades

Posted: **Thu 29 Jan 2009 7:10 pm**

I will download the db file again and verify right now and post shortly.

Posted: **Thu 29 Jan 2009 7:39 pm**

Got the same results. I went ahead and installed MySQL 5.0.67 which was 1 version prior to the most recent version and everything is working fine now. There must be something in 5.1.30 version causing the issue.

I'll get the most recent version up and running on my 2nd machine and see if I can see what setting might have changed from the default install.

Eric Cabral

Posted: **Thu 29 Jan 2009 9:48 pm**

Eek. OK, thanks for the advice about potential MySQL issue.

Cheers,
4Shades

Posted: **Fri 30 Jan 2009 12:44 am**

The only difference in the options I can see is that the 5.1.30 version has "Named Pipes" disabled and the older version has it enabled by default.

Posted: **Sat 31 Jan 2009 3:26 pm**

4Shades,
already spotted three weeks ago when I also updated to My Sql 5.1.28

Change the query code at MP-SQL.php 564 row from:

Code: Select all

 
...
Object_Specifications.Range AS Range
...

to

Code: Select all

...
 Object_Specifications.Range AS OSRange
...

Posted: **Sat 31 Jan 2009 7:09 pm**

Ah yes, thanks Gross. Too many things on my mind at the moment.

Cheers,
4Shades

Posted: **Sat 31 Jan 2009 7:37 pm**

Yes, thanks for the info. I am all upgraded now.

Eric

Official SEOW

Apache error after upgrading.

Apache error after upgrading.