Module Definition Validator

Manually do the 5.0.0 and 5.0.1 scripts. Delete these from future upgrade scripts
5.0.0 Done
5.0.1 Done

Update the dnn_Version table

Redo the CatRem_ backup above, append to the backup set
NB: Disregard for 2 May upgrade first attempt. This is the backup that exists in db.

Copy over the backup configs contents to Website/
Done

The copied web config files are backups of the 495, 522 and 541 web configs.

Make a DOA_495 copy of web.config Done
Delete web.config Done
Copy and paste the 495_2_522_release.config file. Done
Rename the copy to web.config Done

Remove keys for url rewriters in httphandlers and providers in the web config, use only the dnn url rewriter

Make sure the initial catalog is set from NEW_DOA to DOA.
Done

The HTML is already removed as mentioned above in the skins file section. Rename the collectors.ascx and collectors-copy appropriately. This way you keep a backup.
Not done as part of 4.9.5 to 5.2.2.

495 to 522
Ensure the above sequence is done Done
Unzip the 522 upgrade zip in my webftpshare folder/DNN Versions over the /Website folder Done
Open the C:\WebShare\doa.ovionx.com\Website\Providers\DataProviders\SqlDataProvider folder and remove the scripts for 5.0.0 and 5.0.1
Done
Run the Create script from Lisa Gillespie
Done -- had to edit [dbo].[dnn_].[object] to [dbo].[dnn_object]
There are 2 messages from SQL after this:
The module 'dnn_SaveCoreAuditTypes' depends on the missing object 'dbo.AddEventLogType'. The module will still be created; however, it cannot run successfully until the object exists.
The module 'dnn_SaveCoreAuditTypes' depends on the missing object 'dbo.AddEventLogConfig'. The module will still be created; however, it cannot run successfully until the object exists.
There are 2 EXEC statements using the type without object qualifiers, which is why it failed.
Edited the copy and re-ran the script. Commands completed successfully. Done, but found out later object qualifiers are a serious issue. These files are no good and I'll have to start over.

Run the Alter script from Lisa Gillespie
Edited [dbo].[object] to [dbo].[dnn_object]
When I first opened the script, some of the dnn_vw objects were throwing the error of Invalid Object. I had to close and reopen SQL 2008 Mgmt Studio to fix this. The error disappeared, I have no idea why. The objects were also missing from intellisense.
NB: There are errors that show up, such as invalid objects for the HTMLTextLog table. These do exist in databases already upgraded to 5.x and don't for the moment exist. I highlighted and ran a query where there were errors, as this only ALTERS a stored procedure. It does run.
I'm trying the upgrade to see if this doesn't put the objects in place that I expect.

Verify all web.config edits are correct

Upgrade to 522. Do the rest of the upgrade later in the sequence
Reinstall iFinity -- copy over web config entries from 495 copy. Add these to the appropriate sections. make sure iFinity is in the appropriate sections and is the default friendly url provider. REPLACE the key in the <httphandlers> section; ADD the key to the provider section.
Run the SQL Query to reset dnn_tabs | Is Secure to False This is: dnn_Tabs_IsSecure-Set_False.sql
Check that admin and host links work. They will but not all tabs can be browsed to because of a bug supposedly repaired in higher upgrades
Ensure the rest of the site works

Backup the db, backup the site to this point.

522 to 541
Make a DOA_522 copy of the web.config
Delete web.config
Copy and paste the 522_2_541_release.config file -- make sure iFinity is in the appropriate sections and is the default friendly url provider. REPLACE the key in the <httphandlers> section; ADD the key to the provider section.
Rename the copy to web.config

Ensure the above sequence is done
Unzip the 541 upgrade zip in my webftpshare folder/DNN Versions over the /Website folder
Verify all web.config edits are correct

Upgrade to 541
Check that everything works

Do the upgrade path on the test site:

Reinstall the modules for Catalook

Backup the CAT folders in /Desktop Modules -- reinstall these file by file from a backup once Cat 6.0.8 is installed. We customized these files.

Script the content back in

Check that it all works Settings table can't be copied probably due to credit card protections in place.