Can't add Login module to dnn page - Advance Login Module

Search Home

Home

Support

Advance Login M...

Can't add Login module to dnn page

9/26/2012 5:51 PM

bon slon

Joined: 9/25/2012

Posts: 2

Can't add Login module to dnn page (Belarus)

Hi, I have some problems with standard dnn login functionality (described here: ) and then found description of your Ligon module. Hope it can helps me.

I've downloaded trial from your site and tried to test it but faced with some problems:

1) during installation in dnn I've got some errors/warnings:

StartJob	Starting Installation
Info	Starting Installation - AdvancedLogin
Info	Starting Installation - Script
Info	Begin Sql execution
Info	Folder Created - C:\Projects\FiberizerWeb\__Externals\fiberizer-web\DesktopModules\AdvancedLogin\
Info	Created - 45.01.07.SqlDataProvider
Info	Executing 45.01.07.SqlDataProvider
Info	Start Sql execution: 45.01.07.SqlDataProvider file
Warning	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.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:8c196f31-674f-4754-b56f-771d5a520638 /**********************************************************/ /* SqlDataProvider */ /* */ /* */ /* Note: To manually execute this script you must */ /* perform a search and replace operation */ /* for dbo. and dnn_ */ /* */ /********************************************************/ / Create Table */ if not exists (select from dbo.sysobjects where id = object_id(N'dbo.dnn_iWebs_AL_ReDir') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE dbo.dnn_iWebs_AL_ReDir ( [ID] [int] IDENTITY (1, 1) NOT NULL , [ModuleId] [int] NOT NULL , [Role] [nvarchar] (100) NOT NULL , [URL] [nvarchar] (1000) NULL ) ON [PRIMARY] ALTER TABLE dbo.dnn_iWebs_AL_ReDir ADD CONSTRAINT PK_dnn_iWebs_AL_ReDir PRIMARY KEY CLUSTERED (ID) ALTER TABLE dbo.dnn_iWebs_AL_ReDir WITH NOCHECK ADD CONSTRAINT FK_dnn_iWebs_AL_ReDir_dnn_Modules FOREIGN KEY (ModuleID) REFERENCES dbo.dnn_Modules (ModuleID) ON DELETE CASCADE NOT FOR REPLICATION END -- DROP GET PROCEDURE -------------------------------------------------------------------------------------%> if exists (select * from dbo.sysobjects where id = object_id(N'dbo.dnn_iWebs_AL_ReDirGet') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure dbo.dnn_iWebs_AL_ReDirGet
Info	End Sql execution: 45.01.07.SqlDataProvider file
Info	Created - 45.01.09.SqlDataProvider
Info	Executing 45.01.09.SqlDataProvider
Info	Start Sql execution: 45.01.09.SqlDataProvider file
Warning	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.dnn_iWebs_AL_ReDir'. at System.Data.SqlClient.SqlConnection.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:83f1c28a-2dae-447e-b685-64ab7561bc3f UPDATE dbo.dnn_iWebs_AL_ReDir SET ViewOrder=ID
Info	End Sql execution: 45.01.09.SqlDataProvider file
Info	Created - 45.01.10.SqlDataProvider
Info	Executing 45.01.10.SqlDataProvider
Info	Start Sql execution: 45.01.10.SqlDataProvider file
Warning	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.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:26a23955-3ed2-4964-8c40-5be3f1b81680 /**********************************************************/ /* SqlDataProvider */ /* */ /* */ /* Note: To manually execute this script you must */ /* perform a search and replace operation */ /* for dbo. and dnn_ */ /* */ /*********************************************************/ / ===================================================================================== / TABLE: iWebs_AL_IP / ===================================================================================== / if not exists (select from dbo.sysobjects where id = object_id(N'dbo.dnn_iWebs_AL_IP') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE dbo.dnn_iWebs_AL_IP ( [ID] [int] IDENTITY (1, 1) NOT NULL , [ModuleId] [int] NOT NULL , [IP] [nvarchar] (1000) NOT NULL , [Allowed] [bit] NOT NULL , [URL] [nvarchar] (1000) NULL , [ViewOrder] [int] NOT NULL ) ON [PRIMARY] ALTER TABLE dbo.dnn_iWebs_AL_IP ADD CONSTRAINT PK_dnn_iWebs_AL_IP PRIMARY KEY CLUSTERED (ID) ALTER TABLE dbo.dnn_iWebs_AL_IP WITH NOCHECK ADD CONSTRAINT FK_dnn_iWebs_AL_IP_dnn_Modules FOREIGN KEY (ModuleID) REFERENCES dbo.dnn_Modules (ModuleID) ON DELETE CASCADE NOT FOR REPLICATION END System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'dbo.dnn_iWebs_AL_IP'. at System.Data.SqlClient.SqlConnection.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:0a8a0ac0-0d5c-4dfe-8363-ba56e112991f UPDATE dbo.dnn_iWebs_AL_IP SET ViewOrder=ID
Info	End Sql execution: 45.01.10.SqlDataProvider file
Info	Created - 45.02.11.SqlDataProvider
Info	Executing 45.02.11.SqlDataProvider
Info	Start Sql execution: 45.02.11.SqlDataProvider file
Info	End Sql execution: 45.02.11.SqlDataProvider file
Info	Created - 45.03.02.SqlDataProvider
Info	Executing 45.03.02.SqlDataProvider
Info	Start Sql execution: 45.03.02.SqlDataProvider file
Warning	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.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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:8c196f31-674f-4754-b56f-771d5a520638 /**********************************************************/ /* SqlDataProvider */ /* */ /* */ /* Note: To manually execute this script you must */ /* perform a search and replace operation */ /* for dbo. and dnn_ */ /* */ /*********************************************************/ / ===================================================================================== / TABLE: iwebs_AL_AdvRole / ===================================================================================== / if not exists (select from dbo.sysobjects where id = object_id(N'dbo.dnn_iwebs_AL_AdvRole') and OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE dbo.dnn_iwebs_AL_AdvRole ( ID INT IDENTITY (1, 1) NOT NULL , ModuleID INT NOT NULL , Role NVARCHAR(50) NOT NULL , SubscribeLength NVARCHAR(50) NULL , Notify NVARCHAR(10) NULL ) ON [PRIMARY] ALTER TABLE dbo.dnn_iwebs_AL_AdvRole ADD CONSTRAINT PK_dnn_iwebs_AL_AdvRole PRIMARY KEY CLUSTERED (ID) ALTER TABLE dbo.dnn_iwebs_AL_AdvRole WITH NOCHECK ADD CONSTRAINT FK_dnn__iwebs_AL_AdvRole_dnn_Modules FOREIGN KEY (ModuleID) REFERENCES dbo.dnn_Modules (ModuleID) ON DELETE CASCADE NOT FOR REPLICATION END
Info	End Sql execution: 45.03.02.SqlDataProvider file
Info	Created - 45.06.23.SqlDataProvider
Info	Executing 45.06.23.SqlDataProvider
Info	Start Sql execution: 45.06.23.SqlDataProvider file
Info	End Sql execution: 45.06.23.SqlDataProvider file
Info	Created - Uninstall.SqlDataProvider