Hi all!

The install fails as so:
-----------------------------------------------------------------------------------------------------------
Start jobb    Starter Installering
Info    Starter Installering - DNN_Events
Info    Starter Installering - Script
Info    Start Sql-kjøringen
Info    Oppretter backup for tildligere versjoner
Info    Opprettet
Info    Utfører05.01.00.SqlDataProvider
Info    Start Sql-kjøringen: 05.01.00.SqlDataProvider filen
Feil    Sql-kjøringen årsaket følgende unntak: System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'TabID', table 'DotNetNuke_1.dbo.dnn_EventsNotification'; column does not allow nulls. UPDATE fails. The statement has been terminated. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) UPDATE dbo.dnn_EventsNotification SET TabID = (Select top 1 TabID from dbo.dnn_TabModules where ModuleID = dbo.dnn_EventsNotification.ModuleID) WHERE TabID = 1 /************************************************************/ /************************************************************/ /***** *****/ /***** Add new fields to EventsSignups table *****/ /***** *****/ /************************************************************/ /************************************************************/ /* Add NoEnrolees to EventsSignups Table */ if not exists (select * from information_schema.columns where table_name = 'dnn_EventsSignups' and column_name = 'NoEnrolees') BEGIN ALTER TABLE dbo.dnn_EventsSignups WITH NOCHECK ADD NoEnrolees INT NULL DEFAULT 1 END
Info    Avslutt Sql-kjøringen: 05.01.00.SqlDataProvider filen
Info    Fullført Sql-kjøringen
Feil    Installasjonen feilet - Script
Info    Installasjonen feilet - DNN_Events
Info    Slettet midlertidig instalasjonsmappe
Avslutt jobb    Installasjonen feilet
 ________________________________________________________

Please help with correcting this.

Regards Arnt

Hi Roger,

I think I have now deleted all modules and pages from the recycle bin for all portals having deleted Events modules in my host install.

When I now run the two quries below they both returns zero lines.
--------------------------------------------------------------------------------------------------------
/* --- */
/* ModuleDefID for Events = 96 */
SELECT
    dnn_Modules.PortalID,
    dnn_Modules.ModuleID,
    dnn_Modules.ModuleDefID,
    dnn_Modules.IsDeleted AS ModuleDeleted,
    'http://' + dnn_PortalAlias.HTTPAlias + '/tabid/' + CONVERT(VARCHAR, dnn_Tabs.TabID) + '/Default.aspx' AS WebAddress,
    dnn_Tabs.IsDeleted AS PageDeleted
   
 FROM dnn_Modules INNER JOIN dnn_TabModules
    ON dnn_Modules.ModuleID = dnn_TabModules.ModuleID INNER JOIN dnn_Tabs
    ON dnn_TabModules.TabID = dnn_Tabs.TabID INNER JOIN dnn_Portals
    ON dnn_Tabs.PortalID = dnn_Portals.PortalID INNER JOIN dnn_PortalAlias
    ON dnn_Portals.PortalID = dnn_PortalAlias.PortalID
    
WHERE dnn_Modules.ModuleDefID = 96 and dnn_Tabs.IsDeleted = 1

ORDER BY WebAddress
----------------------------------------------------------------------------
/* --- */
/* ModuleDefID for Events = 96 */
SELECT
    dnn_Modules.PortalID,
    dnn_Modules.ModuleID,
    dnn_Modules.ModuleDefID,
    dnn_Modules.IsDeleted AS ModuleDeleted,
    'http://' + dnn_PortalAlias.HTTPAlias + '/tabid/' + CONVERT(VARCHAR, dnn_Tabs.TabID) + '/Default.aspx' AS WebAddress,
    dnn_Tabs.IsDeleted AS PageDeleted
    
 FROM dnn_Modules INNER JOIN dnn_TabModules
    ON dnn_Modules.ModuleID = dnn_TabModules.ModuleID INNER JOIN dnn_Tabs
    ON dnn_TabModules.TabID = dnn_Tabs.TabID INNER JOIN dnn_Portals
    ON dnn_Tabs.PortalID = dnn_Portals.PortalID INNER JOIN dnn_PortalAlias
    ON dnn_Portals.PortalID = dnn_PortalAlias.PortalID
    
WHERE dnn_Modules.ModuleDefID = 96 and dnn_Modules.IsDeleted = 1

ORDER BY WebAddress   
----------------------------------------------------------------------------------------

I think this should prove that there is no deleted pages with the Events module and no deleted Evnets modules on non deleted pages. Do you agreee?

I think it is to late for restoring a backup now and the the install still gives the same error.

Please help asap :)

Roger, I have sent you an email

Thanks you.