Hi, when I'm trying to upgrade from 6.01.05 to 6.02.04 I keep getting an error when the sql script for 6.02.00 is being run.
The error in my log file is; http://chopapp.com/#p6nfk3f5 (or) http://hastebin.com/raw/deqileqewo
This is all of the information I can find. Can anyone please point me in the correct direction here?
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, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)ClientConnectionId:865cfe95-78d5-4973-9d40-fd2563fda864 /* 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, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)ClientConnectionId:c4287781-7b4c-48ec-94c4-b41500a86060 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