Your question has been submitted and is awaiting moderation.
Thank you for reporting this content, moderators have been notified of your submission.
Am trying to install Form and List module but I keep getting this error
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): 'NOT FOR REPLICATION' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:a4511f56-fee7-41a4-ab83-cb3ac1d5fa4c /************************************************************/ /***** SqlDataProvider *****/ /***** *****/ /***** *****/ /***** Note: To manually execute this script you must *****/ /***** perform a search and replace operation *****/ /***** for dbo. and *****/ /***** *****/ /************************************************************/ /** Create UserDefinedTable Tables **/ if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[UserDefinedRows]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE dbo.[UserDefinedRows] ( [UserDefinedRowId] [int] NOT NULL IDENTITY(1, 1), [ModuleId] [int] NOT NULL ) ALTER TABLE dbo.[UserDefinedRows] ADD CONSTRAINT [PK_UserDefinedRows] PRIMARY KEY CLUSTERED ([UserDefinedRowId]) CREATE NONCLUSTERED INDEX [IX_UserDefinedRows] ON dbo.[UserDefinedRows] ([ModuleId]) ALTER TABLE dbo.[UserDefinedRows] WITH NOCHECK ADD CONSTRAINT [FK_UserDefinedRows_Modules] FOREIGN KEY ([ModuleId]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION END System.Data.SqlClient.SqlException (0x80131904): 'NOT FOR REPLICATION' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:0a2e123c-0f59-48b7-b74f-45bc4cf9a34d if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[UserDefinedFields]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE dbo.[UserDefinedFields] ( [UserDefinedFieldId] [int] NOT NULL IDENTITY(1, 1), [ModuleId] [int] NOT NULL, [FieldTitle] [varchar] (50) NOT NULL, [Visible] [bit] NOT NULL, [FieldOrder] [int] NOT NULL DEFAULT (0), [FieldType] [varchar] (20) NOT NULL ) ALTER TABLE dbo.[UserDefinedFields] ADD CONSTRAINT [PK_UserDefinedTable] PRIMARY KEY CLUSTERED ([UserDefinedFieldId]) CREATE NONCLUSTERED INDEX [IX_UserDefinedFields] ON dbo.[UserDefinedFields] ([ModuleId]) ALTER TABLE dbo.[UserDefinedFields] WITH NOCHECK ADD CONSTRAINT [FK_UserDefinedFields_Modules] FOREIGN KEY ([ModuleId]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION END System.Data.SqlClient.SqlException (0x80131904): 'NOT FOR REPLICATION' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:b11fdcd3-25a1-4d72-9e13-77e339dd33c7 if not exists (select * from dbo.sysobjects where id = object_id(N'dbo.[UserDefinedData]') and OBJECTPROPERTY(id, N'IsTable') = 1) BEGIN CREATE TABLE dbo.[UserDefinedData] ( [UserDefinedDataId] [int] NOT NULL IDENTITY(1, 1), [UserDefinedFieldId] [int] NOT NULL, [UserDefinedRowId] [int] NOT NULL, [FieldValue] [nvarchar] (2000) NOT NULL ) ALTER TABLE dbo.[UserDefinedData] ADD CONSTRAINT [PK_UserDefinedData] PRIMARY KEY CLUSTERED ([UserDefinedDataId]) CREATE NONCLUSTERED INDEX [IX_UserDefinedData] ON dbo.[UserDefinedData] ([UserDefinedFieldId]) CREATE NONCLUSTERED INDEX [IX_UserDefinedData_1] ON dbo.[UserDefinedData] ([UserDefinedRowId]) ALTER TABLE dbo.[UserDefinedData] WITH NOCHECK ADD CONSTRAINT [FK_UserDefinedData_UserDefinedFields] FOREIGN KEY ([UserDefinedFieldId]) REFERENCES dbo.[UserDefinedFields] ([UserDefinedFieldId]) NOT FOR REPLICATION ALTER TABLE dbo.[UserDefinedData] WITH NOCHECK ADD CONSTRAINT [FK_UserDefinedData_UserDefinedRows] FOREIGN KEY ([UserDefinedRowId]) REFERENCES dbo.[UserDefinedRows] ([UserDefinedRowId]) ON DELETE CASCADE NOT FOR REPLICATION END
Please Help