Hi Virgil,

Good looking module there. I'm quite keen to check it over and have installed it on a DNN 4.7 test portal, but the installation has an error as pasted below. I've been trying to get back to your site to let you know, but it seems to be offline or something... so I'm just letting you know here instead.

I'll keep checking your site and will carry this on there if it comes back.

Rob

StartJob Begin Sql execution
Info Executing 01.00.00.SqlDataProvider
StartJob Start Sql execution: 01.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Line 27: Incorrect syntax near '('. 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 **/ CREATE TABLE dbo.[AdvanceLinks]( [ItemID] [int] IDENTITY(0,1) NOT NULL, [ModuleID] [int] NOT NULL, [CreatedDate] [datetime] NULL, [Title] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Url] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [ViewOrder] [int] NULL, [Description] [nvarchar](2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CreatedByUser] [int] NOT NULL, [TabId] [int] NULL, [IconUrl] [nchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, PRIMARY KEY NONCLUSTERED ( [ItemID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] System.Data.SqlClient.SqlException: Cannot alter table 'dbo.AdvanceLinks' because this table does not exist in database 'wumpdev'. 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) ALTER TABLE dbo.[AdvanceLinks] WITH NOCHECK ADD FOREIGN KEY([ModuleID]) REFERENCES dbo.[Modules] ([ModuleID]) ON DELETE CASCADE NOT FOR REPLICATION 
EndJob End Sql execution: 01.00.00.SqlDataProvider file

Hi Rob,

Sorry have not much to time to fix the PA of the module, after install all the files should be in your server already except the table so for  a quick fix run the script below using Host\SQL  menu.

CREATE TABLE [dbo].[AdvanceLinks](
 [ItemID] [int] IDENTITY(0,1) NOT NULL,
 [ModuleID] [int] NOT NULL,
 [CreatedDate] [datetime] NULL,
 [Title] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [Url] [nvarchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [ViewOrder] [int] NULL,
 [Description] [nvarchar](2000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
 [CreatedByUser] [int] NOT NULL,
 [TabId] [int] NULL,
 [IconUrl] [nchar](250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
PRIMARY KEY NONCLUSTERED
(
 [ItemID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[AdvanceLinks]  WITH NOCHECK ADD FOREIGN KEY([ModuleID])
REFERENCES [dbo].[Modules] ([ModuleID])
ON DELETE CASCADE
NOT FOR REPLICATION

HTH