Still getting the same error:
System.Data.SqlClient.SqlException: Invalid column name 'DesktopHtml'. Invalid column name 'CreatedByUser'. Invalid column name 'CreatedDate'. Invalid column name 'CreatedByUser'. Invalid column name 'CreatedDate'. 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) IF NOT EXISTS (select * from dbo.sysobjects where id = object_id(N'dbo.HtmlTextLog') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN update dbo.HtmlText set Content = DesktopHtml, Version = 1, IsPublished = 1, CreatedByUserID = CreatedByUser, CreatedOnDate = CreatedDate, LastModifiedByUserID = CreatedByUser, LastModifiedOnDate = CreatedDate ALTER TABLE dbo.HtmlText DROP COLUMN DesktopHtml, DesktopSummary, CreatedByUser, CreatedDate CREATE TABLE dbo.HtmlTextLog ( HtmlTextLogID int NOT NULL IDENTITY (1, 1), ItemID int NOT NULL, StateID int NOT NULL, Comment nvarchar(4000), Approved bit NOT NULL, CreatedByUserID int NOT NULL, CreatedOnDate datetime NOT NULL ) ON [PRIMARY] ALTER TABLE dbo.HtmlTextLog ADD CONSTRAINT PK_HtmlTextLog PRIMARY KEY CLUSTERED ( HtmlTextLogID ) ON [PRIMARY] CREATE TABLE dbo.HtmlTextUsers ( HtmlTextUserID int NOT NULL IDENTITY (1, 1), ItemID int NOT NULL, StateID int NOT NULL, ModuleID int NOT NULL, TabID int NOT NULL, UserID int NOT NULL, CreatedOnDate datetime NOT NULL ) ON [PRIMARY] ALTER TABLE dbo.HtmlTextUsers ADD CONSTRAINT PK_HtmlTextUsers PRIMARY KEY CLUSTERED ( HtmlTextUserID ) ON [PRIMARY] ALTER TABLE dbo.HtmlText WITH NOCHECK ADD CONSTRAINT FK_HtmlText_WorkflowStates FOREIGN KEY ( StateID ) REFERENCES dbo.WorkflowStates ( StateID ) ON UPDATE NO ACTION ON DELETE NO ACTION NOT FOR REPLICATION ALTER TABLE dbo.HtmlTextLog WITH NOCHECK ADD CONSTRAINT FK_HtmlTextLog_HtmlText FOREIGN KEY ( ItemID ) REFERENCES dbo.HtmlText ( ItemID ) ON UPDATE NO ACTION ON DELETE CASCADE NOT FOR REPLICATION ALTER TABLE dbo.HtmlTextLog WITH NOCHECK ADD CONSTRAINT FK_HtmlTextLog_WorkflowStates FOREIGN KEY ( StateID ) REFERENCES dbo.WorkflowStates ( StateID ) ON UPDATE NO ACTION ON DELETE NO ACTION NOT FOR REPLICATION ALTER TABLE dbo.HtmlTextUsers WITH NOCHECK ADD CONSTRAINT FK_HtmlTextUsers_HtmlText FOREIGN KEY ( ItemID ) REFERENCES dbo.HtmlText ( ItemID ) ON UPDATE NO ACTION ON DELETE CASCADE NOT FOR REPLICATION END