Upgrade from 9.1.1 to 9.3.2 Showing TermsTabID error

[natedean18]

Hi all,

I am performing a DNN upgrade from 9.1.1 to 9.3.2.

After I perform the install, I am getting following error

DotNetNuke.Services.Exceptions.Exceptions - System.IndexOutOfRangeException: TermsTabId
at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
at System.Data.SqlClient.SqlDataReader.GetOrdinal(String name)
at System.Data.SqlClient.SqlDataReader.get_Item(String name)
at DotNetNuke.Entities.Portals.PortalInfo.Fill(IDataReader dr)
at DotNetNuke.Common.Utilities.CBO.FillObjectFromReader(Object objObject, IDataReader dr)

Looking in the database, I see a table called DNN_PortalLocalization which has a column name TermsTabID and the value is NULL, does this need to be set to something? The site worked fine in 9.1.1 when it was set to NULL.

Any ideas for help? Thanks

[valadas]

I would check the portals/_default/logs folder to see if there was any errors during the upgrade, you should find one file for each day as well as some install specific log files. Maybe some sql script went wrong and you can find a clue in there.

[bdukes]

Specifically for SQL issues, there are log files in Providers/DataProviders/SqlDataProvider for each SQL script.

That error is indicating that the results that came back from the database did not include the TermsTabId column.