It is usually installed at the same time when you install sql server or sql server express, so if that is already installed you should find it in the programs menu. If you have not yet installed sql express, the easiest way to install it is using the MS Platform Installer.

You would need to have GoDaddy restore the db, but the file system also needs to be restored exactly as it was before the upgrade, which would requiring having a backup of the file system, deleting all the current files then restoring them from the backup.

If you can get the backup of the current db to me I can try to restore it here and take a look to confirm the problem suspicions and that "may" lead to an idea to solve it. You could zip it, put it on your server and send me a link at joe dot audette at g mail dotcom, then remove the file after I get it so no-one else can get the file.

You should be able to install on Windows 8 using platform installer unless it conflicts with an existing slq server installation on the machine. xp is pretty useless at this point.

It would be best to make a copy of both the db as it is currently and the one before upgrade available to me so I could compare them, but I would definitley want the backup of the db as it is right now.

I promise to delete the files after my investigation is complete.

Based on the mp_SchemaScriptHistory table, it looks like your old version is 2.3.5.5. I have no idea how it got changed to an older version in mp_SchemaVersion table but that is why it is trying to run older scripts that it should not run.

Run this against your db to correct it in mp_SchemaVersion, then visit the setup page again.

UPDATE mp_SchemaVersion
SET Major = 2, Minor = 3, Build = 5, Revision = 5
WHERE ApplicationID = '077E4857-F583-488E-836E-34A4B04BE855' 

That should make it start running upgrade scripts greater than version 2.3.5.5

That is still a pretty old version to upgrade from, you should also review all the release notes in the blog for versions from that one up to the latest and you will likely also need to make skin changes per the important skin changes article.

Hope that helps,

Joe

yes, you can set it manually on the mojoportal-core row, but make sure it is still there after you leave that row, ie it doesn't actually change until you get out of that row.

I assumed you could run a sql script since you previously posted a sql select statement.

Glad I was able to help! Many thanks for the generous beer donation!

Cheers,

Joe