Mountain View 1600, CA 94043
+1 650-253-0000
name@example.com
Web
Site
Search
Register
Login
DNN Home
Services
-
DotNetNuke Support
-
CRM Systems
DNN
-
DotNetNuke Modules
-
Module Downloads
-
Module Upgrade Policy
DNN Support
-
Module Update News
-
Knowledge Base
-
License Management
-
Invoice History
Module Downloads
Blog
Store
Contact Us
-
About Us
Search
Home
1
2
3
4
5
Home
Support
DNN Word Editor
Install error
Previous
Next
11/16/2010 7:13 PM
Joined: 1/1/0001
Posts: 0
Install error
(Vietnam)
I try to install word editor DNN , but get some error, please help me to solve this issue
StartJob
Starting Installation
Info
Starting Installation - DNN_HTML
Info
Starting Installation - Script
Info
Begin Sql execution
Info
Creating backup of previous version - Providers\DataProviders\SqlDataProvider\05.01.00.SqlDataProvider
Info
Created - Providers\DataProviders\SqlDataProvider\05.01.00.SqlDataProvider
Info
Executing 05.01.00.SqlDataProvider
Info
Start Sql execution: 05.01.00.SqlDataProvider file
Failure
SQL Execution resulted in following Exceptions: 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 System.Data.SqlClient.SqlException: Invalid column name 'ModuleTitle'. 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) create procedure dbo.GetHtmlTextUser @UserID int as select HtmlTextUsers.*, WorkflowStates.StateName, Modules.ModuleTitle from dbo.HtmlTextUsers inner join dbo.WorkflowStates on dbo.HtmlTextUsers.StateID = dbo.WorkflowStates.StateID inner join dbo.Modules on dbo.HtmlTextUsers.ModuleID = dbo.Modules.ModuleID where HtmlTextUsers.UserID = @UserID order by HtmlTextUsers.CreatedOnDate asc
Info
End Sql execution: 05.01.00.SqlDataProvider file
Info
Finished Sql execution
Failure
Installation Failed - Script
Info
Installation Failed - DNN_HTML
Info
Deleted temporary install folder
EndJob
Installation Failed
1/3/2011 3:40 AM
DNN Module Support
Joined: 8/28/2006
Posts: 2065
Re: Install error
(Australia)
What version of DNN are you using and what version of the HTML editor have you used.
There was a recent mod to the manual about this, so ensure that you have the latest version.
Page 1 of 1
Previous
Next
Home
Support
DNN Word Editor
Install error