While upgrading to dnn community 07.01.01 we are getting the error below...
--------------------------------------------------------------------------------
Upgrade Now 0:35 Minutes | 26% ERROR occured - System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'Status' in table 'dbo.UserRoles' is specified more than once.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
/* Add new Columns To UserRoles Table *//**************************************/
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME='dbo.UserRoles' AND COLUMN_NAME='Status')
BEGIN ALTER TABLE dbo.UserRoles
ADD [Status] int NOT NULL CONSTRAINT DF_UserRoles_Status DEFAULT 1 END
System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name 'IsOwner' in table 'dbo.UserRoles' is specified more than once.
at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script)
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME='dbo.UserRoles' AND COLUMN_NAME='IsOwner')
BEGIN ALTER TABLE dbo.UserRoles
ADD IsOwner bit NOT NULL CONSTRAINT DF_UserRoles_IsOwner DEFAULT 0 END
,Error: Object reference not set to an instance of an object. at DotNetNuke.Services.Upgrade.Upgrade.ConvertCoreNotificationTypeActionsFor700()
at DotNetNuke.Services.Upgrade.Upgrade.UpgradeToVersion700()
at DotNetNuke.Services.Upgrade.Upgrade.UpgradeApplication(String providerPath, Version version, Boolean writeFeedback)
26 %Retry View Logs
Updating Database
Thanks.