I have the same error upgrading from version 3.3.5 I get all successes all the way through till it hits 4.3.5 not I am at the following:
Assembly: 04.03.05
Database: 04.00.03
And the log file 04.03.05.log has the following:
System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'LastUpdated' in table 'dbo.Folders' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
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.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Add LastUpdated Column to Folders */
/*************************************/
ALTER TABLE dbo.Folders ADD
LastUpdated datetime NOT NULL CONSTRAINT DF_Folders_LastUpdated DEFAULT getUtcDate()
Does anyone have any suggestions?