iFinity

Just installed the InlineLinkMaster and received the following SQLException,

ExceptionSystem.Data.SqlClient.SqlException: Procedure or function 'AddTab' expects parameter '@PermanentRedirect', which was not supplied. The statement has been terminated. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.AddModuleControl(Int32 ModuleDefId, String ControlKey, String ControlTitle, String ControlSrc, String IconFile, Int32 ControlType, Int32 ViewOrder, String HelpUrl, Boolean SupportsPartialRendering) at DotNetNuke.Entities.Modules.ModuleControlController.AddModuleControl(ModuleControlInfo objModuleControl) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.RegisterModules(PaFolder Folder, ArrayList Modules, ArrayList Controls) at DotNetNuke.Modules.Admin.ResourceInstaller.PaDnnInstallerBase.Install(PaFolderCollection folders) at DotNetNuke.Modules.Admin.ResourceInstaller.PaInstaller.Install()

I need it too. Thx, Ivan

Ivan Farkas
Ivan Farkas, LLC
http://www.FL4SaleLive.com
DNN 5.0.1, Vista Ultimate x64 SP1 (Dev), Windows Server 2008 x64 (Prod), IIS7, Sql Server 2008 x64 SP1, .NET 3.5 SP1.

I have a different error when installing it on DNN5.0. Do you know aprox release date of the module?

gSQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'TabPath', table 'Sandbox.dbo.ifty_ilm_TabModuleCreation'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TabPath', table 'Sandbox.dbo.ifty_ilm_TabModuleCreation'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TabPath', table 'Sandbox.dbo.ifty_ilm_TabModuleCreation'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TabPath', table 'Sandbox.dbo.ifty_ilm_TabModuleCreation'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TabPath', table 'Sandbox.dbo.ifty_ilm_TabModuleCreation'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TabPath', table 'Sandbox.dbo.ifty_ilm_TabModuleCreation'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. 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) /* create a new tab, module and tab module for the InlineLinks.ascx control */ Declare @newControlSource nvarchar(255), @targetPortalId int Declare @hostTabId int, @tabPath nvarchar(255), @tabOrder int SET @NewControlSource = 'DesktopModules/iFinity.InlineLinkMaster/InlineLinks.ascx' IF NOT EXISTS (Select * from ifty_ilm_TabModuleCreation where ControlSource = @newControlSource) BEGIN DECLARE Portal_Curs CURSOR FOR SELECT PortalId FROM Portals open Portal_Curs FETCH FROM Portal_Curs into @targetPortalId WHILE @@Fetch_Status = 0 BEGIN /* insert an admin / Inline Links page for each portal */ Declare @AdminTabId int SELECT @AdminTabId = TabId , @tabPath = TabPath + '//InlineLinks' FROM Tabs t WHERE portalId = @targetPortalId AND parentId is null AND tabPath is not null AND TabOrder = 10001 --this defines the admin page SELECT @tabOrder = coalesce(max(tabOrder), 0) + 1 --taborder is the last tab in the host tabs FROM Tabs t WHERE portalId = @targetPortalId AND TabOrder > 10000 /* now insert the values to be created */ INSERT INTO ifty_ilm_TabModuleCreation ( PortalId, ControlSource, TabName, IsVisible, DisableLink, ParentId, TabIconFile, Title, Description, KeyWords, SkinSrc, ContainerSrc, TabPath, StartDate, EndDate, RefreshInterval, PageHeadText, IsSecure, TabOrder, IsAdmin, PaneName, CacheTime, Alignment, Color, Border, ModuleIconFile, Visibility, DisplayTitle, DisplayPrint, DisplaySyndicate, SetDesktopModuleAdmin, DeleteTabOnModuleRemove, TabId, ModuleId, ModuleDefId, Completed) VALUES ( @targetPortalId, @newControlSource, 'Inline Links', 1, 0, @adminTabId, 'link16.gif', 'Inline Link Replacements', '', '',NULL, NULL, @tabPath, NULL, NULL, 0, NULL, 0, @tabOrder, 1, 'ContentPane', 0, NULL, NULL, NULL, 'link32.gif', 0, 1, 0, 0, 1, 1, NULL, NULL, NULL, 0) FETCH FROM Portal_Curs into @targetPortalId END CLOSE Portal_Curs DEALLOCATE Portal_Curs END ---------------- /* create auto trigger to create new Inline Links page when new portals are created */ IF EXISTS (select * from sysobjects where id = OBJECT_ID(N'dbo.[ifty_ilm_OnNewModule]') and xtype='TR') drop trigger dbo.[ifty_ilm_OnNewModule] /* create a trigger that calls the stored procedure that takes records from the table and creates tabs, modules and tab modules for a new portal */ EXEC sp_executesql @statement = N'CREATE TRIGGER dbo.[ifty_ilm_OnNewModule] on dbo.[Modules] FOR INSERT as -- ============================================= -- Author: Bruce Chapman -- Create date: 26 May 2008 -- Description: Checks and runs tab and tabmodule creation -- when a new module for the portal-specific solutions explorer -- is added. It is done like this so it is created after all -- the other admin tabs are created. -- ============================================= declare @portalId int select @portalID = Coalesce(Max(m.PortalId), -1) from inserted m inner join MOduleDefinitions md on m.ModuleDefId= md.ModuleDefId inner join ModuleControls mc on md.ModuleDefId = mc.ModuleDefId where ModuleTitle = ''Solutions Explorer'' and controlsrc = ''Admin/Host/Solutions.ascx'' if @PortalId > -1 BEGIN declare @moduleDefId int, @moduleControlId int, @controlSource nvarchar(255) declare @parentId int select @parentId = Min(TabId) from Tabs where PortalId = @portalID and TabOrder > 10000 and ParentID is Null /* look for the table */ IF EXISTS (SELECT * FROM sysobjects WHERE id = OBJECT_ID(N''dbo.[ifty_ilm_TabModuleCreation]'') AND type in (N''U'')) BEGIN if exists (select * from dbo.[ifty_ilm_TabModuleCreation] where completed = 1) Begin /* insert a new record into the tabModuleCreation table, in preparation for the sp to be run*/ insert into dbo.[ifty_ilm_TabModuleCreation] (PortalId ,ControlSource ,TabName ,IsVisible ,DisableLink ,ParentId ,TabIconFile ,Title ,Description,KeyWords,SkinSrc,ContainerSrc,TabPath ,StartDate,EndDate,RefreshInterval,PageHeadText ,IsSecure,TabOrder,IsAdmin ,PaneName ,CacheTime,Alignment,Color ,Border,ModuleIconFile,Visibility ,DisplayTitle,DisplayPrint,DisplaySyndicate,SetDesktopModuleAdmin,DeleteTabOnModuleRemove,TabId ,ModuleId,ModuleDefId,Completed) select @PortalId ,ControlSource ,TabName ,IsVisible ,DisableLink ,@parentId ,TabIconFile ,Title ,Description,KeyWords,SkinSrc,ContainerSrc,TabPath ,StartDate,EndDate,RefreshInterval,PageHeadText ,IsSecure,TabOrder,IsAdmin ,PaneName ,CacheTime,Alignment,Color ,Border,ModuleIconFile,Visibility ,DisplayTitle,DisplayPrint,DisplaySyndicate,SetDesktopModuleAdmin,DeleteTabOnModuleRemove,TabId ,ModuleId,ModuleDefId , 0 from dbo.[ifty_ilm_TabModuleCreation] where PortalID = (select MIN(PortalId) from dbo.[ifty_ilm_TabModuleCreation]) and ControlSource = ''DesktopModules/iFinity.InlineLinkMaster/InlineLinks.ascx'' select @moduleDefId = mc.moduleDefId , @moduleControlId = moduleControlId From dbo.[ifty_ilm_TabModuleCreation] tmc inner join ModuleControls mc on mc.ModuleDefID = tmc.ModuleDefId and mc.ControlSrc = tmc.ControlSource where PortalId = @portalId and ControlSource = ''DesktopModules/iFinity.InlineLinkMaster/InlineLinks.ascx'' exec ifty_ilm_AddTabAndTabModule @moduleDefId, @moduleControlId END END END ' ---------------- SET ANSI_NULLS ON