Thread:Project:Support desk/Failed Upgrade to 1.18 or 1.19/reply (7)

OK I am posting this as I found a solution and want to share to help any others that get the same issue. Here's what I did to get it to work.

Set up a Test Server and installed MySQL, PHP and Mediawiki 1.19.2 on IIS7.

Ran the initial Setup for MediaWiki

Then Copied the Database for our production MediaWiki (WIKIDB) over from the Production MySQL Server.

Copied over the Images Folder from the production Folder

Compared the LocalSettings.PHP files for both 1.17.1 and 1.19.2. Annotated the differences and then made the changes to the 1.19.2 LocalSettings.php file that were there. I did not add any new lines, just changed the current lines to reflect correct information, i.e. MySQL Account Names and what have you.

Started IIS and it worked Fine.

So I went to the Production Server to update the real Web.

Stopped IIS Services

First, backed up both the web root folder and the SQL Database, then I moved the LocalSettings.PHP file to the Desktop.

Copied the MediaWiki 1.19.2 folder over to the server's desktop.

Removed all the contents of our web's Mediawiki folder (W) except the Images Folder and the LocalSettings.php file.

Copied all the contencts of hte 1.19.2 folder over to our MediaWiki folder, except the Extensions folder and the local settings file.

Moved the LocalSettings.php file over to the desktop.

Copied the 1.19.2 LocalSettings.php file from our test server to the production server.

Compared the 1.17 and 1.19.2 LocalSettings.php and only had to change the $wgServer line to reflect the correct name of the production Server. For example it did say "http://localhost"; I changed it to "http://wiki";.

From an elevated command prompt I ran the c:\inetpup\wwwroot\w\maint\update.php script to ensure the database was updated. No errors were observed.

Started the IIS Service

Tested the page both from the server and from several other computers on the network. All seemed well.

Went back and stopped IIS Services again.

Downloaded the latest version of the three extensions that our office desired. Cite Embed Video Replace Text

Added the three Extensions that we still wanted to utilize to localsettings.php but only enabled one at a time.

Then I started IIS after each was enabled to test the extension. Then repeated the process for each subsequent Extension.

Once each extension was tested and verified we left the server up and then had our local Webadmin test some changes, some new pages and a few file loads and downloads. It all appears to be working fine.

One of the things I think contributed to this issue was that this MediaWiki had been updated from some of the original versions of Mediwiki. The localsettings.php file had a lot of pollution if you will. When I started to work for this agency last year one of the first things I had to do was move the MediaWiki from the Linux Host to a Windows Server IIS environment. And then update it to 1.17.

Hope this helps someone else who is getting the HTTP 500 error 0x00000000 errors.