Mitchel. I have looke deverywhere and tried everything that I can think of. I am trying to upgrade to 5.1.4 from 4.8.4. I have done this before with other sites and no issues. This one is giving me lots of grief. The site was originall 3.2.2 which I updated to 4.8.4 following the stepped approach that is listed on your upgrade page. This is the approach that I have always followed and it has been great! The HTML_Community_05.01.04_Install is the only item that is failing on the install. In trying to load the extension through the Host->Extensions section, it fails with an error loading the SQL script, specifically provider 5.1.0. i try running that by itself through Host->SQL gives me the same error: (I parsed this out to try and make sense of it) 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
I am stuck at this point in time. My test site is ncgt.cstech.ca and you can see all of the failed HTML modules on the front page. Any help with this would be great! Cheers
Dave
|