DNN upgrade failure

[RFH Reseller: heavenlyarts]

Well

I upgraded dnn from 4.0.3 to 4.8.0, the upgrade gave an error at step 4.0.4 (helpurl was all that the log file showed).

Now nothing works, I get this error.


Server Error in '/' Application.

IsSecure

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.IndexOutOfRangeException: IsSecure

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[IndexOutOfRangeException: IsSecure] System.Data.ProviderBase.FieldNameLookup.GetOrdina l(String fieldName) +1433771 System.Data.SqlClient.SqlDataReader.GetOrdinal(Str ing name) +102 System.Data.SqlClient.SqlDataReader.get_Item(Strin g name) +12 DotNetNuke.Entities.Tabs.TabController.FillTabInfo (IDataReader dr, Boolean CheckForOpenDataReader, Boolean CheckForLegacyFields) +1788 DotNetNuke.Entities.Tabs.TabController.GetTab(Int3 2 TabId, Int32 PortalId, Boolean ignoreCache) +223 DotNetNuke.Entities.Portals.PortalSettings.VerifyP ortalTab(Int32 PortalId, Int32 TabId) +318 DotNetNuke.Entities.Portals.PortalSettings.GetPort alSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +2405 DotNetNuke.Entities.Portals.PortalSettings..ctor(I nt32 tabId, PortalAliasInfo objPortalAliasInfo) +83 DotNetNuke.HttpModules.UrlRewriteModule.OnBeginReq uest(Object s, EventArgs e) +3303 System.Web.SyncEventExecutionStep.System.Web.HttpA pplication.IExecutionStep.Execute() +92 System.Web.HttpApplication.ExecuteStep(IExecutionS tep step, Boolean& completedSynchronously) +64

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433

Can anyone offer any assistance.

Thanx

Jeremy

[RFH Reseller: balexandre]

as seeing in the trace info, that error cames from reading a column named isSecure on the database and that is not available.

did you upgraded the DB first? cause DNN 480 will probably have more fields and for that you should run a script to assure that new columns are created.

Never worked with DNN but have plenty years of .NET experience and by reading the info that you paste, that's my 1st thought.


by the way last version of DNN is 4.8.1

more...

reading the upgrade installation readme file I get this

Application Upgrades

- make sure you always backup your files/database before upgrading to a new version
- BACKUP your web.config file in the root of your site
- unzip the code over top of your existing application ( using the Overwrite and Use Folder Names options )
- rename release.config -> web.config
- merge any localized settings from your old web.config to the new web.config. These typically include:
- connection strings ( SiteSqlServer )
- machine keys ( validationKey and decryptionKey )
- objectQualifier
- browse to localhost/DotNetNuke in your web browser
- the application will automatically execute the necessary database scripts and provide feedback in the browser

so... I can't really help you pointing the right spot

[RFH Reseller: heavenlyarts]

as seeing in the trace info, that error cames from reading a column named isSecure on the database and that is not available.

did you upgraded the DB first? cause DNN 480 will probably have more fields and for that you should run a script to assure that new columns are created.

Never worked with DNN but have plenty years of .NET experience and by reading the info that you paste, that's my 1st thought.



by the way last version of DNN is 4.8.1

more...

reading the upgrade installation readme file I get this



so... I can't really help you pointing the right spot

Thanx you gave me ideas...

Well I'm making some progress.

I upgraded to 4.8.1 and also installed 4.8.1 on my local machine.

Know I'm going through the database objects locating the fields that are missing and adding them

so far I've had to add

issecure to view vw_tabs and DefaultCacheTime to vw_modules

The site now loads but security is all messed up, I only see pages when logged in as Host. I'n now going through the error log to see what else needs adding.


Thanx

[RFH Reseller: heavenlyarts]

Well it's all working now.

Downloaded an eval version fo SQL-compare from redgate.
It found hundreds of SQL differences, I applied the change script it gave to fix and AOK.

Still not worked out what went wrong with the DNN upgrade script.

[Tanzy]

Sorry not been around to notice this.

I have had a few problems in the past updrading DNN but not many. They order of things that I do an upgrade is as follows

1. BACKUP
2. BACKUP
3. Restore backup onto a test machine and carry out upgrade on test machine
4. If things go well....
5. BACKUP MAIN Website & SQL server
6. Carryout upgrade
7. If upgrade fails restore backup and try to workout why it failed
8. BACKUP

BTW did I mention always backup before carrying out any sort of DB upgrade?

The main issues I have found in the past for an upgrade fail has been due to timeouts, this is why I check everything on a local machine before I do a live upgrade. In the past I have also found bugs in the upgrade due to minor issues that I have been able to fix myself.

Ken