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
General
Install Errors
Previous
Next
1/3/2009 5:16 AM
John
Joined: 12/30/2008
Posts: 1
Install Errors
(United States)
I am trying to install the trial version of AnnounceIT 40.02.15 and 16 on a localhost version of DNN 4.9.0.In both cases I get the following errors:
StartJob Start Sql execution: 40.01.29.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Modules' that match the referencing column list in the foreign key 'FK_spascoe_AnnounceIT_Modules'. Could not create constraint. See previous errors. 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) /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /** Create Table **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[spascoe_AnnounceIT]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE dbo.[spascoe_AnnounceIT] ( [ItemId] [int] IDENTITY(1,1) NOT NULL, [ModuleId] [int] NOT NULL DEFAULT (0), [Content] [ntext] NOT NULL DEFAULT (''), [CreatedByUser] [int] NOT NULL DEFAULT (0), [CreatedDate] [datetime] NOT NULL, [Title] [nvarchar](150) NOT NULL DEFAULT (''), [CatID] [int] NOT NULL DEFAULT (0), [Summary] [ntext] NOT NULL DEFAULT (''), [isDeleted] [int] NOT NULL DEFAULT (0), [RemoveDate] [datetime] NULL, [UpdatedByUser] [int] NOT NULL DEFAULT (0), [UpdatedDate] [datetime] NULL, [ActiveFrom] [datetime] NULL, [ArchiveDate] [datetime] NULL ) ALTER TABLE dbo.[spascoe_AnnounceIT] ADD CONSTRAINT [PK_spascoe_AnnounceIT] PRIMARY KEY CLUSTERED ([ItemID]) CREATE NONCLUSTERED INDEX [IX_spascoe_AnnounceIT] ON dbo.[spascoe_AnnounceIT] ([ModuleID]) ALTER TABLE dbo.[spascoe_AnnounceIT] WITH NOCHECK ADD CONSTRAINT [FK_spascoe_AnnounceIT_Modules] FOREIGN KEY ([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION END System.Data.SqlClient.SqlException: There are no primary or candidate keys in the referenced table 'dbo.Modules' that match the referencing column list in the foreign key 'FK_spascoe_AnnounceITCategory_Modules'. Could not create constraint. See previous errors. 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.[spascoe_AnnounceITCategory]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE dbo.[spascoe_AnnounceITCategory] ( [CatID] [int] IDENTITY(1,1) NOT NULL, [CategoryTitle] [nvarchar](250) NOT NULL DEFAULT (''), [IconURL] [nvarchar](250) NOT NULL DEFAULT (''), [ModuleId] [int] NOT NULL DEFAULT (0), [CatOrder] [int] NOT NULL DEFAULT (0), [ParentId] [int] NOT NULL DEFAULT (0), [Level] [int] NOT NULL DEFAULT (0), [tbl] [nvarchar](350) NOT NULL DEFAULT (''), [tdHeader] [nvarchar](350) NOT NULL DEFAULT (''), [tdBody1] [nvarchar](350) NOT NULL DEFAULT (''), [tdBody2] [nvarchar](350) NOT NULL DEFAULT (''), [lnk1] [nvarchar](350) NOT NULL DEFAULT (''), [lnk2] [nvarchar](350) NOT NULL DEFAULT (''), [lnk3] [nvarchar](350) NOT NULL DEFAULT ('') ) ALTER TABLE dbo.[spascoe_AnnounceITCategory] ADD CONSTRAINT [PK_spascoe_AnnounceITCategory] PRIMARY KEY CLUSTERED ([CatID]) CREATE NONCLUSTERED INDEX [IX_spascoe_AnnounceITCategory] ON dbo.[spascoe_AnnounceITCategory] ([ModuleID]) ALTER TABLE dbo.[spascoe_AnnounceITCategory] WITH NOCHECK ADD CONSTRAINT [FK_spascoe_AnnounceITCategory_Modules] FOREIGN KEY ([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION END
EndJob End Sql execution: 40.01.29.SqlDataProvider file
Thanks for any help.
John
4/22/2009 1:53 PM
DNN Module Support
Joined: 8/28/2006
Posts: 2065
Re: Install Errors
(Australia)
if you're still experiencing the problem there is a new version available for you to trial here:
http://www.interactivewebs.com.au/Downloads/tabid/163/language/en-AU/Default.aspx
Page 1 of 1
Previous
Next
Home
Support
General
Install Errors