Hey, and thanks for viewing my post. I'm trying to install the events module on my newly upgraded DNN 7.0.0.5 site. I get the following error:
Error loading files from temporary folder - see below
SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'PortalID', table 'DNN7.dbo.ModulePermission'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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.ExecuteScriptInternal(String connectionString, String script) /************************************************************/ /************************************************************/ /***** *****/ /***** Retain moderators as category/location editors *****/ /***** *****/ /************************************************************/ /************************************************************/ -- Ensure Moderators have edit category permissions INSERT INTO dbo.[ModulePermission] ( RoleID, ModuleID, PermissionID, AllowAccess ) SELECT MP1.RoleID, MP1.ModuleID, P3.PermissionID, - 1 AS AllowAcces FROM dbo.[ModulePermission] AS MP1 INNER JOIN dbo.[Permission] AS P1 ON MP1.PermissionID = P1.PermissionID CROSS JOIN dbo.[Permission] AS P3 WHERE (P1.PermissionCode = 'EVENTS_MODULE') AND (P1.PermissionKey = 'EVENTSMOD') AND MP1.RoleID is not null AND (MP1.RoleID NOT IN (SELECT MP2.RoleID FROM dbo.[ModulePermission] AS MP2 INNER JOIN dbo.[Permission] AS P2 ON MP2.PermissionID = P2.PermissionID INNER JOIN dbo.[Modules] AS M2 ON MP2.ModuleID = M2.ModuleID INNER JOIN dbo.[ModuleDefinitions] AS MD2 ON M2.ModuleDefID = MD2.ModuleDefID WHERE (P2.PermissionCode = 'EVENTS_MODULE') AND (P2.PermissionKey = 'EVENTSCAT') AND (MD2.FriendlyName = N'Events') AND (M2.ModuleID = MP1.ModuleID) AND MP2.RoleID is not null)) AND (P3.PermissionCode = 'EVENTS_MODULE') AND (P3.PermissionKey = 'EVENTSCAT') INSERT INTO dbo.[ModulePermission] ( UserID, ModuleID, PermissionID, AllowAccess ) SELECT MP1.UserID, MP1.ModuleID, P3.PermissionID, - 1 AS AllowAcces FROM dbo.[ModulePermission] AS MP1 INNER JOIN dbo.[Permission] AS P1 ON MP1.PermissionID = P1.PermissionID CROSS JOIN dbo.[Permission] AS P3 WHERE (P1.PermissionCode = 'EVENTS_MODULE') AND (P1.PermissionKey = 'EVENTSMOD') AND MP1.UserID is not null AND (MP1.UserID NOT IN (SELECT MP2.UserID FROM dbo.[ModulePermission] AS MP2 INNER JOIN dbo.[Permission] AS P2 ON MP2.PermissionID = P2.PermissionID INNER JOIN dbo.[Modules] AS M2 ON MP2.ModuleID = M2.ModuleID INNER JOIN dbo.[ModuleDefinitions] AS MD2 ON M2.ModuleDefID = MD2.ModuleDefID WHERE (P2.PermissionCode = 'EVENTS_MODULE') AND (P2.PermissionKey = 'EVENTSCAT') AND (MD2.FriendlyName = N'Events') AND (M2.ModuleID = MP1.ModuleID) AND MP2.UserID is not null)) AND (P3.PermissionCode = 'EVENTS_MODULE') AND (P3.PermissionKey = 'EVENTSCAT') System.Data.SqlClient.SqlException (0x80131904): Cannot insert the value NULL into column 'PortalID', table 'DNN7.dbo.ModulePermission'; column does not allow nulls. INSERT fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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.ExecuteScriptInternal(String connectionString, String script) -- Ensure Moderators have edit location permissions INSERT INTO dbo.[ModulePermission] ( RoleID, ModuleID, PermissionID, AllowAccess ) SELECT MP1.RoleID, MP1.ModuleID, P3.PermissionID, - 1 AS AllowAcces FROM dbo.[ModulePermission] AS MP1 INNER JOIN dbo.[Permission] AS P1 ON MP1.PermissionID = P1.PermissionID CROSS JOIN dbo.[Permission] AS P3 WHERE (P1.PermissionCode = 'EVENTS_MODULE') AND (P1.PermissionKey = 'EVENTSMOD') AND MP1.RoleID is not null AND (MP1.RoleID NOT IN (SELECT MP2.RoleID FROM dbo.[ModulePermission] AS MP2 INNER JOIN dbo.[Permission] AS P2 ON MP2.PermissionID = P2.PermissionID INNER JOIN dbo.[Modules] AS M2 ON MP2.ModuleID = M2.ModuleID INNER JOIN dbo.[ModuleDefinitions] AS MD2 ON M2.ModuleDefID = MD2.ModuleDefID WHERE (P2.PermissionCode = 'EVENTS_MODULE') AND (P2.PermissionKey = 'EVENTSLOC') AND (MD2.FriendlyName = N'Events') AND (M2.ModuleID = MP1.ModuleID) AND MP2.RoleID is not null)) AND (P3.PermissionCode = 'EVENTS_MODULE') AND (P3.PermissionKey = 'EVENTSLOC') INSERT INTO dbo.[ModulePermission] ( UserID, ModuleID, PermissionID, AllowAccess ) SELECT MP1.UserID, MP1.ModuleID, P3.PermissionID, - 1 AS AllowAcces FROM dbo.[ModulePermission] AS MP1 INNER JOIN dbo.[Permission] AS P1 ON MP1.PermissionID = P1.PermissionID CROSS JOIN dbo.[Permission] AS P3 WHERE (P1.PermissionCode = 'EVENTS_MODULE') AND (P1.PermissionKey = 'EVENTSMOD') AND MP1.UserID is not null AND (MP1.UserID NOT IN (SELECT MP2.UserID FROM dbo.[ModulePermission] AS MP2 INNER JOIN dbo.[Permission] AS P2 ON MP2.PermissionID = P2.PermissionID INNER JOIN dbo.[Modules] AS M2 ON MP2.ModuleID = M2.ModuleID INNER JOIN dbo.[ModuleDefinitions] AS MD2 ON M2.ModuleDefID = MD2.ModuleDefID WHERE (P2.PermissionCode = 'EVENTS_MODULE') AND (P2.PermissionKey = 'EVENTSLOC') AND (MD2.FriendlyName = N'Events') AND (M2.ModuleID = MP1.ModuleID) AND MP2.UserID is not null)) AND (P3.PermissionCode = 'EVENTS_MODULE') AND (P3.PermissionKey = 'EVENTSLOC')
Info End Sql execution: 05.01.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_Events
Info Deleted temporary install folder
EndJob Installation Failed
Any ideas on what can cause this? I haven't had any trouble installing other modules.