 |
|
|
 |
jamesecampbell.blogspot.com
Joined: 10/16/2008
Posts: 130
|
|
|
I am currently working with a site that is at 4.9.1.
I have tried upgrading using the suggested upgrade path and many other ways. No matter what I cannot seem to get the Package File HTML_Community to install. It doesn't matter the version it always fails. It is the only failure. Here is my log from a straight 4.9.1 to 5.6.3. Now I know this isn't the proper upgrade path, but again it doesn't matter the only I get no matter what version is Installing Package File HTML_Community_05.06.03_Install: Error! .
Upgrading DotNetNuke
Current Assembly Version: 05.06.03
Current Database Version: 04.09.01
Upgrade Status Report
00:00:00.035 - Upgrading to Version: 05.06.03
00:00:00.303 - Executing Script: 05.00.00.SqlDataProvider Success
00:00:09.618 - Executing Script: 05.00.01.SqlDataProvider Success
00:00:10.509 - Executing Script: 05.01.00.SqlDataProvider Success
00:00:18.106 - Executing Script: 05.01.01.SqlDataProvider Success
00:00:18.948 - Executing Script: 05.01.02.SqlDataProvider Success
00:00:18.964 - Executing Script: 05.01.03.SqlDataProvider Success
00:00:19.401 - Executing Script: 05.01.04.SqlDataProvider Success
00:00:19.541 - Executing Script: 05.02.00.SqlDataProvider Success
00:00:23.597 - Executing Script: 05.02.01.SqlDataProvider Success
00:00:24.112 - Executing Script: 05.02.02.SqlDataProvider Success
00:00:24.143 - Executing Script: 05.02.03.SqlDataProvider Success
00:00:24.190 - Executing Script: 05.03.00.SqlDataProvider Success
00:00:26.811 - Executing Script: 05.03.01.SqlDataProvider Success
00:00:27.107 - Executing Script: 05.04.00.SqlDataProvider Success
00:00:27.622 - Executing Script: 05.04.01.SqlDataProvider Success
00:00:27.684 - Executing Script: 05.04.02.SqlDataProvider Success
00:00:27.825 - Executing Script: 05.04.03.SqlDataProvider Success
00:00:28.137 - Executing Script: 05.04.04.SqlDataProvider Success
00:00:28.199 - Executing Script: 05.05.00.SqlDataProvider Success
00:00:35.469 - Executing Script: 05.05.01.SqlDataProvider Success
00:00:35.687 - Executing Script: 05.06.00.SqlDataProvider Success
00:00:40.196 - Executing Script: 05.06.01.SqlDataProvider Success
00:00:40.305 - Executing Script: 05.06.02.SqlDataProvider Success
00:00:41.522 - Executing Script: 05.06.03.SqlDataProvider Success
00:00:41.537 - Executing Application Upgrades: 05.00.00 Success
00:00:49.212 - Executing Application Upgrades: 05.00.01 Success
00:00:49.244 - Executing Application Upgrades: 05.01.00 Success
00:00:51.849 - Executing Application Upgrades: 05.01.01 Success
00:00:51.865 - Executing Application Upgrades: 05.01.02 Success
00:00:51.865 - Executing Application Upgrades: 05.01.03 Success
00:00:51.989 - Executing Application Upgrades: 05.01.04 Success
00:00:51.989 - Executing Application Upgrades: 05.02.00 Success
00:00:52.067 - Executing Application Upgrades: 05.02.01 Success
00:00:52.067 - Executing Application Upgrades: 05.02.02 Success
00:00:52.067 - Executing Application Upgrades: 05.02.03 Success
00:00:52.067 - Executing Application Upgrades: 05.03.00 Success
00:00:55.531 - Executing Application Upgrades: 05.03.01 Success
00:00:55.531 - Executing Application Upgrades: 05.04.00 Success
00:00:55.624 - Executing Application Upgrades: 05.04.01 Success
00:00:55.624 - Executing Application Upgrades: 05.04.02 Success
00:00:55.624 - Executing Application Upgrades: 05.04.03 Success
00:00:55.655 - Executing Application Upgrades: 05.04.04 Success
00:00:55.655 - Executing Application Upgrades: 05.05.00 Success
00:00:55.811 - Executing Application Upgrades: 05.05.01 Success
00:00:55.811 - Executing Application Upgrades: 05.06.00 Success
00:00:55.999 - Executing Application Upgrades: 05.06.01 Success
00:00:55.999 - Executing Application Upgrades: 05.06.02 Success
00:00:56.014 - Executing Application Upgrades: 05.06.03 Success
00:00:56.014 - Cleaning Up Files: 05.00.00 Success
00:00:56.186 - Cleaning Up Files: 05.00.01 Success
00:00:56.186 - Cleaning Up Files: 05.01.00 Success
00:00:56.264 - Cleaning Up Files: 05.01.01 Success
00:00:56.264 - Cleaning Up Files: 05.01.02 Success
00:00:56.264 - Cleaning Up Files: 05.01.03 Success
00:00:56.264 - Cleaning Up Files: 05.01.04 Success
00:00:56.264 - Cleaning Up Files: 05.02.00 Success
00:00:56.264 - Cleaning Up Files: 05.02.01 Success
00:00:56.264 - Cleaning Up Files: 05.02.02 Success
00:00:56.264 - Cleaning Up Files: 05.02.03 Success
00:00:56.264 - Cleaning Up Files: 05.03.00 Success
00:00:56.264 - Cleaning Up Files: 05.03.01 Success
00:00:56.264 - Cleaning Up Files: 05.04.00 Success
00:00:56.264 - Cleaning Up Files: 05.04.01 Success
00:00:56.264 - Cleaning Up Files: 05.04.02 Success
00:00:56.264 - Cleaning Up Files: 05.04.03 Success
00:00:56.264 - Cleaning Up Files: 05.04.04 Success
00:00:56.264 - Cleaning Up Files: 05.05.00 Success
00:00:56.264 - Cleaning Up Files: 05.05.01 Success
00:00:56.264 - Cleaning Up Files: 05.06.00 Success
00:00:56.264 - Cleaning Up Files: 05.06.01 Success
00:00:56.264 - Cleaning Up Files: 05.06.02 Success
00:00:56.264 - Cleaning Up Files: 05.06.03 Success
00:00:56.279 - Updating Config Files: 05.00.00 Success
00:00:56.279 - Updating Config Files: 05.00.01 Success
00:00:56.279 - Updating Config Files: 05.01.00 Success
00:00:56.279 - Updating Config Files: 05.01.01 Success
00:00:56.279 - Updating Config Files: 05.01.02 Success
00:00:56.279 - Updating Config Files: 05.01.03 Success
00:00:56.279 - Updating Config Files: 05.01.04 Success
00:00:56.279 - Updating Config Files: 05.02.00 Success
00:00:56.295 - Updating Config Files: 05.02.01 Success
00:00:56.295 - Updating Config Files: 05.02.02 Success
00:00:56.295 - Updating Config Files: 05.02.03 Success
00:00:56.295 - Updating Config Files: 05.03.00 Success
00:00:56.295 - Updating Config Files: 05.03.01 Success
00:00:56.295 - Updating Config Files: 05.04.00 Success
00:00:56.295 - Updating Config Files: 05.04.01 Success
00:00:56.295 - Updating Config Files: 05.04.02 Success
00:00:56.295 - Updating Config Files: 05.04.03 Success
00:00:56.295 - Updating Config Files: 05.04.04 Success
00:00:56.295 - Updating Config Files: 05.05.00 Success
00:00:56.311 - Updating Config Files: 05.05.01 Success
00:00:56.311 - Updating Config Files: 05.06.00 Success
00:00:56.311 - Updating Config Files: 05.06.01 Success
00:00:56.311 - Updating Config Files: 05.06.02 Success
00:00:56.311 - Updating Config Files: 05.06.03 Success
00:00:56.326 - Performing General Upgrades
00:00:56.498 - Installing Optional Modules:
00:00:56.498 - Installing Package File HTML_Community_05.06.03_Install: Error!
00:00:59.665 - Installing Package File Messaging_05.06.03_Install: Success
00:00:59.836 - Installing Package File Taxonomy_05.06.03_Install: Success
00:01:00.070 - Installing Package File Telerik_05.06.03_Install: Success
00:01:00.850 - Installing Optional Skins:
00:01:00.850 - Installing Optional Containers:
00:01:00.850 - Installing Optional Languages:
00:01:00.850 - Installing Optional Providers:
00:01:00.850 - Installing Package File AspNetMembershipProvider_05.06.03_Install: Success
00:01:01.817 - Installing Package File CorePermissionProvider_05.06.03_Install: Success
00:01:02.129 - Installing Package File CoreSitemapProvider_05.06.03_Install: Success
00:01:02.207 - Installing Package File DatabaseLoggingProvider_05.06.03_Install: Success
00:01:02.301 - Installing Package File DNNMembershipProvider_05.06.03_Install: Success
00:01:02.426 - Installing Package File DNNMenuNavigationProvider_05.06.03_Install: Success
00:01:02.785 - Installing Package File DNNTreeNavigationProvider_05.06.03_Install: Success
00:01:02.878 - Installing Package File FckHtmlEditorProvider_02.00.04_Install: Success
00:01:10.023 - Installing Package File FileBasedCachingProvider_05.06.03_Install: Success
00:01:10.257 - Installing Package File FileModuleCachingProvider_05.06.03_Install: Success
00:01:10.351 - Installing Package File MemoryModuleCachingProvider_05.06.03_Install: Success
00:01:10.772 - Installing Package File SchedulingProvider_05.06.03_Install: Success
00:01:10.897 - Installing Package File SearchIndexProvider_05.06.03_Install: Success
00:01:10.990 - Installing Package File SearchProvider_05.06.03_Install: Success
00:01:11.084 - Installing Package File SolpartMenuNavigationProvider_05.06.03_Install: Success
00:01:11.209 - Installing Package File TelerikEditorProvider_05.06.03_Install: Success
00:01:11.911 - Installing Optional AuthSystems:
00:01:11.911 - Installing Package File LiveID_01.00.01_Install: Success
00:01:13.143 - Installing Package File OpenID_02.00.00_Install: Success
00:01:13.736 - Installing Optional Packages:
Upgrade Complete
|
| |
|
|
 | |
|
|
 |
 |
www.cathal.co.uk
Joined: 4/9/2003
Posts: 9676
|
|
|
have you installed .net 3.5sp1 and are using sql 2005 and above (they're the prerequisites for that version)
Buy the new Professional DNN7: Open Source .NET CMS Platform book
Amazon US
|
| |
|
|
| |
|
|
|
jamesecampbell.blogspot.com
Joined: 10/16/2008
Posts: 130
|
|
|
yes I have .NET 3.5 sp1 and am running SQL server 2008 R2.
|
| |
|
|
| |
|
|
|
jamesecampbell.blogspot.com
Joined: 10/16/2008
Posts: 130
|
|
|
This is the error I see after the install in the logs:
AssemblyVersion: 5.6.3
PortalID: -1
PortalName:
UserID: -1
UserName:
ActiveTabID: -1
ActiveTabName:
RawURL:
AbsoluteURL:
AbsoluteURLReferrer:
UserAgent:
DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
ExceptionGUID: c3f3716a-ccd3-43cc-9c9e-9ef73810fe53
InnerException: Parameter count does not match Parameter Value count.
FileName:
FileLineNumber: 0
FileColumnNumber: 0
Method: Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues
StackTrace:
Message: System.ArgumentException: Parameter count does not match Parameter Value count. at Microsoft.ApplicationBlocks.Data.SqlHelper.AssignParameterValues(SqlParameter[] commandParameters, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Modules.HTML.SqlDataProvider.GetHtmlText(Int32 moduleId) in C:\inetpub\App_Code\HTML\Providers\DataProviders\SQLDataProvider\SqlDataProvider.vb:line 120 at DotNetNuke.Modules.HTML.HtmlTextController.GetHtmlText(Int32 moduleId) in C:\inetpub\App_Code\HTML\HtmlTextController.vb:line 85 at DotNetNuke.Modules.HTML.HtmlTextController.GetSearchItems(ModuleInfo ModInfo) in C:\inetpub\App_Code\HTML\HtmlTextController.vb:line 126 at DotNetNuke.Services.Search.ModuleIndexer.GetSearchIndexItems(Int32 PortalID)
Source:
Server Name: USERNAME-PC
When I try to manually install after the upgrade I get:
Error loading files from temporary folder - see below
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: Cannot drop index 'PK_HtmlText' because it enforces the full-text key for table or indexed view 'HtmlText'. Could not drop constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (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 ALTER TABLE dbo.HtmlText DROP CONSTRAINT PK_HtmlText END System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'ItemID' in table 'dbo.HtmlText' is specified more than once. at System.Data.SqlClient.SqlConnection. (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 ALTER TABLE dbo.HtmlText ADD ItemID int NOT NULL IDENTITY (1, 1), Content ntext NULL, Version int NULL, StateID int NULL, IsPublished bit NULL, CreatedByUserID int NULL, CreatedOnDate datetime NULL, LastModifiedByUserID int NULL, LastModifiedOnDate datetime NULL ALTER TABLE dbo.HtmlText ADD CONSTRAINT PK_HtmlText PRIMARY KEY CLUSTERED ( ItemID ) ON [PRIMARY] END System.Data.SqlClient.SqlException: Cannot alter or drop column 'DesktopHtml' because it is enabled for Full-Text Search. at System.Data.SqlClient.SqlConnection. (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
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
|
| |
|
|
| |
|
|
|
jamesecampbell.blogspot.com
Joined: 10/16/2008
Posts: 130
|
|
|
So I dropped the Full text on the field and now I get this:
Error loading files from temporary folder - see below
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: Column names in each table must be unique. Column name 'ItemID' in table 'dbo.HtmlText' is specified more than once. at System.Data.SqlClient.SqlConnection. (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 ALTER TABLE dbo.HtmlText ADD ItemID int NOT NULL IDENTITY (1, 1), Content ntext NULL, Version int NULL, StateID int NULL, IsPublished bit NULL, CreatedByUserID int NULL, CreatedOnDate datetime NULL, LastModifiedByUserID int NULL, LastModifiedOnDate datetime NULL ALTER TABLE dbo.HtmlText ADD CONSTRAINT PK_HtmlText PRIMARY KEY CLUSTERED ( ItemID ) ON [PRIMARY] END System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.HtmlText' that match the referencing column list in the foreign key 'FK_HtmlTextLog_HtmlText'. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection. (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
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
|
| |
|
|
| |