DNN 05.02.02
DMX 05.02.02
When I run the script "Add DMX Search to DNN Search " I got the message
System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'TabID', table 'C:\INETPUB\INTRANET\APP_DATA\MIJNINTRA.MDF.dbo.TabModules'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Can anyone tell me how to solve thi problem?
Kind regards,
Ad Spelt
Run Script
00: - Retrieving Settings
00: - PortalId: Success
00: - TabId: Success
00: - ModuleId: Success
00: - Finding Script: Success
00: - Reading 'C:\Inetpub\Intranet\DesktopModules\Bring2mind\DMX\Admin\Scripts\SetSearchPane.Resources': Success
00: - Script title: Add DMX Search to DNN Search Results Page 00: - Checking permission: Success
00: - Script description: This script adds DMX search to your DNN Search Results page.
00: - Processing script:
BEGIN
DECLARE @SRT INT
SELECT @SRT = t.TabId
FROM {databaseOwner}{objectQualifier}TabModules tm
INNER JOIN {databaseOwner}{objectQualifier}Modules m ON m.ModuleId=tm.ModuleId
INNER JOIN {databaseOwner}{objectQualifier}ModuleDefinitions md ON m.ModuleDefID = md.ModuleDefID
INNER JOIN {databaseOwner}{objectQualifier}DesktopModules dm ON dm.DesktopModuleID = md.DesktopModuleID
INNER JOIN {databaseOwner}{objectQualifier}Tabs t ON t.TabID = tm.TabId
WHERE dm.ModuleName='Search Results'
AND m.PortalID=56
IF (SELECT COUNT(tm.TabId)
FROM {databaseOwner}{objectQualifier}TabModules tm
INNER JOIN {databaseOwner}{objectQualifier}Modules m ON m.ModuleId=tm.ModuleId
INNER JOIN {databaseOwner}{objectQualifier}ModuleDefinitions md ON m.ModuleDefID = md.ModuleDefID
INNER JOIN {databaseOwner}{objectQualifier}DesktopModules dm ON dm.DesktopModuleID = md.DesktopModuleID
INNER JOIN {databaseOwner}{objectQualifier}Tabs t ON t.TabID = tm.TabId
WHERE dm.ModuleName='Bring2mind\DMX'
AND t.TabId=@SRT) = 0
BEGIN
DECLARE @MDID INT
SELECT @MDID = md.ModuleDefID FROM {databaseOwner}{objectQualifier}ModuleDefinitions md
INNER JOIN {databaseOwner}{objectQualifier}DesktopModules dm ON dm.DesktopModuleID = md.DesktopModuleID
WHERE dm.ModuleName='Bring2mind\DMX'
DECLARE @MID INT
INSERT INTO {databaseOwner}{objectQualifier}Modules (ModuleDefID, ModuleTitle, AllTabs, IsDeleted, InheritViewPermissions, PortalID)
VALUES (@MDID, 'DMX Search Results', 0, 0, 1, 0)
SELECT @MID = SCOPE_IDENTITY()
INSERT INTO {databaseOwner}{objectQualifier}TabModules (TabID, ModuleID, PaneName, ModuleOrder, CacheTime, Alignment, Visibility, DisplayTitle, DisplayPrint, DisplaySyndicate)
VALUES (@SRT, @MID, 'ContentPane', 2, 0, 'left', 0, 1, 1, 0)
INSERT INTO {databaseOwner}{objectQualifier}ModuleSettings (ModuleID, SettingName, SettingValue)
VALUES (@MID, 'DefaultPane', 'bring2mind/dmx/search.ascx')
END
END
00: - Running script: Success
bij System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
bij System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
bij System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
bij System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
bij System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
bij System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
bij System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
bij Bring2mind.DNN.Modules.DMX.Data.SqlDataProvider.ᜁ(String A_0)
bij Bring2mind.DNN.Modules.DMX.Data.SqlDataProvider.ExecuteScript(String Script)
BEGIN
DECLARE @SRT INT
SELECT @SRT = t.TabId
FROM dbo.TabModules tm
INNER JOIN dbo.Modules m ON m.ModuleId=tm.ModuleId
INNER JOIN dbo.ModuleDefinitions md ON m.ModuleDefID = md.ModuleDefID
INNER JOIN dbo.DesktopModules dm ON dm.DesktopModuleID = md.DesktopModuleID
INNER JOIN dbo.Tabs t ON t.TabID = tm.TabId
WHERE dm.ModuleName='Search Results'
AND m.PortalID=56
IF (SELECT COUNT(tm.TabId)
FROM dbo.TabModules tm
INNER JOIN dbo.Modules m ON m.ModuleId=tm.ModuleId
INNER JOIN dbo.ModuleDefinitions md ON m.ModuleDefID = md.ModuleDefID
INNER JOIN dbo.DesktopModules dm ON dm.DesktopModuleID = md.DesktopModuleID
INNER JOIN dbo.Tabs t ON t.TabID = tm.TabId
WHERE dm.ModuleName='Bring2mind\DMX'
AND t.TabId=@SRT) = 0
BEGIN
DECLARE @MDID INT
SELECT @MDID = md.ModuleDefID FROM dbo.ModuleDefinitions md
INNER JOIN dbo.DesktopModules dm ON dm.DesktopModuleID = md.DesktopModuleID
WHERE dm.ModuleName='Bring2mind\DMX'
DECLARE @MID INT
INSERT INTO dbo.Modules (ModuleDefID, ModuleTitle, AllTabs, IsDeleted, InheritViewPermissions, PortalID)
VALUES (@MDID, 'DMX Search Results', 0, 0, 1, 0)
SELECT @MID = SCOPE_IDENTITY()
INSERT INTO dbo.TabModules (TabID, ModuleID, PaneName, ModuleOrder, CacheTime, Alignment, Visibility, DisplayTitle, DisplayPrint, DisplaySyndicate)
VALUES (@SRT, @MID, 'ContentPane', 2, 0, 'left', 0, 1, 1, 0)
INSERT INTO dbo.ModuleSettings (ModuleID, SettingName, SettingValue)
VALUES (@MID, 'DefaultPane', 'bring2mind/dmx/search.ascx')
END
END
00:00:00.125 - Instantiating Bring2mind.DNN.Modules.DMX.Framework.ModuleController, BRING2MIND.DNN.MODULES.DMX.CORE: Success
00:00:00.125 - Finished Running Script