Apache error after upgrading.

[eric963]

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

[IV/JG7_4Shades]

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

[eric963]

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

[eric963]

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

[IV/JG7_4Shades]

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

Cheers,
4Shades

[eric963]

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.

[22GCT_Gross]

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
...

[IV/JG7_4Shades]

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

Cheers,
4Shades

[eric963]

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

Eric