Trying to install the Events module 6.00.3 (tried 6.00 as well) on a DNN Accellerator / Azure install.  The Accellerator / install works well and the site works as expected.  But, I really need the Events module functionality for this project.  Everytime I try to install the package it fails, error below.

I've tried / tested this on both a vanilla 6.2.4 dnn install as well as a vanilla 7.0 beta install (for good measure) and the issue is repeatable.  I would really appreciate some help as I've not had time to dig in too deep yet as other parts of the site / project need attention still.  But, this module is going to be needed soon enough.

Thanks for any help!  I still don't understand the logic of removing the 'core' DNN modules as this problem wouldn't happen.

6.2.4 Installation Log / Errors

StartJob	Starting Installation
Info	Starting Installation - DNN_Events
Info	Starting Installation - Script
Info	Begin Sql execution
Info	Folder Created - X:\DotNetNuke6\DesktopModules\Events\Installation
Info	Created - Installation\Install.05.02.04.SqlDataProvider
Info	Executing Install.05.02.04.SqlDataProvider
Info	Start Sql execution: Install.05.02.04.SqlDataProvider file
Info	End Sql execution: Install.05.02.04.SqlDataProvider file
Info	Created - Installation\06.00.00.SqlDataProvider
Info	Executing 06.00.00.SqlDataProvider
Info	Start Sql execution: 06.00.00.SqlDataProvider file
Failure	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sysconstraints'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:925dc657-0e53-4ea8-ac72-876e54e4bb2f DECLARE @defname VARCHAR(100), @cmd VARCHAR(1000) SET @defname = (SELECT name FROM sysobjects so JOIN sysconstraints sc ON so.id = sc.constid WHERE object_name(so.parent_obj) = 'Events' AND so.xtype = 'D' AND sc.colid = (SELECT colid FROM syscolumns WHERE id = object_id('Events') AND name = 'CreatedDateOld')) SET @cmd = 'ALTER TABLE dbo.[Events] DROP CONSTRAINT '+ @defname EXEC(@cmd) ALTER TABLE dbo.[Events] DROP COLUMN CreatedDateOld System.Data.SqlClient.SqlException (0x80131904): Deprecated feature 'DROP INDEX with two-part name' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:5ce4269d-f8e0-4b42-bc8d-0d37a44d5a4b /***** Set EventsPPErrorLog.CreateDate to UTC *****/ if exists (select * from dbo.sysindexes where id = object_id(N'dbo.[EventsPPErrorLog]') AND name = N'IX_EventsPPErrorLog') drop index dbo.[EventsPPErrorLog].[IX_EventsPPErrorLog] System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sysconstraints'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:ed89d82c-06f3-49e9-b08f-04299291cd01 DECLARE @defname VARCHAR(100), @cmd VARCHAR(1000) SET @defname = (SELECT name FROM sysobjects so JOIN sysconstraints sc ON so.id = sc.constid WHERE object_name(so.parent_obj) = 'EventsPPErrorLog' AND so.xtype = 'D' AND sc.colid = (SELECT colid FROM syscolumns WHERE id = object_id('EventsPPErrorLog') AND name = 'CreateDateOld')) SET @cmd = 'ALTER TABLE dbo.[EventsPPErrorLog] DROP CONSTRAINT '+ @defname EXEC(@cmd) ALTER TABLE dbo.[EventsPPErrorLog] DROP COLUMN CreateDateOld System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsPPErrorLog' already exists on table 'dbo.EventsPPErrorLog'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:1d8ccbd6-47d7-4838-bd3a-539992691f40 CREATE INDEX [IX_EventsPPErrorLog] ON dbo.[EventsPPErrorLog]([CreateDate] DESC ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sysconstraints'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ClientConnectionId:baa26bc8-89a1-404c-a9f4-56f374475bf6 DECLARE @defname VARCHAR(100), @cmd VARCHAR(1000) SET @defname = (SELECT name FROM sysobjects so JOIN sysconstraints sc ON so.id = sc.constid WHERE object_name(so.parent_obj) = 'EventsSignups' AND so.xtype = 'D' AND sc.colid = (SELECT colid FROM syscolumns WHERE id = object_id('EventsSignups') AND name = 'CreateDateOld')) SET @cmd = 'ALTER TABLE dbo.[EventsSignups] DROP CONSTRAINT '+ @defname EXEC(@cmd) ALTER TABLE dbo.[EventsSignups] DROP COLUMN CreateDateOld
Info	End Sql execution: 06.00.00.SqlDataProvider file
Info	Finished Sql execution
Failure	Installation Failed - Script
Info	Installation Failed - DNN_Events
Info	Deleted temporary install folder
EndJob	Installation Failed

7.0 Installation Log / Errors

Starting Installation - DNN_Events
Info	Starting Installation - Script
Info	Begin Sql execution
Info	Folder Created - X:\dnn7\DesktopModules\Events\Installation
Info	Created - Installation\Install.05.02.04.SqlDataProvider
Info	Executing Install.05.02.04.SqlDataProvider
Info	Start Sql execution: Install.05.02.04.SqlDataProvider file
Info	End Sql execution: Install.05.02.04.SqlDataProvider file
Info	Created - Installation\06.00.00.SqlDataProvider
Info	Executing 06.00.00.SqlDataProvider
Info	Start Sql execution: 06.00.00.SqlDataProvider file
Failure	SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sysconstraints'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) ClientConnectionId:28897ad4-e130-4766-8f10-7096442ff761 DECLARE @defname VARCHAR(100), @cmd VARCHAR(1000) SET @defname = (SELECT name FROM sysobjects so JOIN sysconstraints sc ON so.id = sc.constid WHERE object_name(so.parent_obj) = 'Events' AND so.xtype = 'D' AND sc.colid = (SELECT colid FROM syscolumns WHERE id = object_id('Events') AND name = 'CreatedDateOld')) SET @cmd = 'ALTER TABLE dbo.[Events] DROP CONSTRAINT '+ @defname EXEC(@cmd) ALTER TABLE dbo.[Events] DROP COLUMN CreatedDateOld System.Data.SqlClient.SqlException (0x80131904): Deprecated feature 'DROP INDEX with two-part name' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) ClientConnectionId:68e4db27-d107-4a21-bf75-c1a18cb81023 /***** Set EventsPPErrorLog.CreateDate to UTC *****/ if exists (select * from dbo.sysindexes where id = object_id(N'dbo.[EventsPPErrorLog]') AND name = N'IX_EventsPPErrorLog') drop index dbo.[EventsPPErrorLog].[IX_EventsPPErrorLog] System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sysconstraints'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) ClientConnectionId:e46748a4-7f8c-4a21-8bd8-9b1718fec908 DECLARE @defname VARCHAR(100), @cmd VARCHAR(1000) SET @defname = (SELECT name FROM sysobjects so JOIN sysconstraints sc ON so.id = sc.constid WHERE object_name(so.parent_obj) = 'EventsPPErrorLog' AND so.xtype = 'D' AND sc.colid = (SELECT colid FROM syscolumns WHERE id = object_id('EventsPPErrorLog') AND name = 'CreateDateOld')) SET @cmd = 'ALTER TABLE dbo.[EventsPPErrorLog] DROP CONSTRAINT '+ @defname EXEC(@cmd) ALTER TABLE dbo.[EventsPPErrorLog] DROP COLUMN CreateDateOld System.Data.SqlClient.SqlException (0x80131904): The operation failed because an index or statistics with name 'IX_EventsPPErrorLog' already exists on table 'dbo.EventsPPErrorLog'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) ClientConnectionId:fe97f40d-7cd8-4703-93a1-ff5c20b26ff1 CREATE INDEX [IX_EventsPPErrorLog] ON dbo.[EventsPPErrorLog]([CreateDate] DESC ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Invalid object name 'sysconstraints'. at System.Data.SqlClient.SqlConnection. (SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection. (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) ClientConnectionId:4c43ac92-cd1e-40dd-beeb-fb2751ce5385 DECLARE @defname VARCHAR(100), @cmd VARCHAR(1000) SET @defname = (SELECT name FROM sysobjects so JOIN sysconstraints sc ON so.id = sc.constid WHERE object_name(so.parent_obj) = 'EventsSignups' AND so.xtype = 'D' AND sc.colid = (SELECT colid FROM syscolumns WHERE id = object_id('EventsSignups') AND name = 'CreateDateOld')) SET @cmd = 'ALTER TABLE dbo.[EventsSignups] DROP CONSTRAINT '+ @defname EXEC(@cmd) ALTER TABLE dbo.[EventsSignups] DROP COLUMN CreateDateOld
Info	End Sql execution: 06.00.00.SqlDataProvider file
Info	Finished Sql execution
Failure	Installation Failed - Script
Info	Installation Failed - DNN_Events
Info	Deleted temporary install folder
EndJob	Installation Failed

 

 

Thanks for looking in to it. It looks like Ernst has release the fix with a couple others. I have been bogged down with other parts of the site.

I dug in a bit and the first problem was the missing 'sysconstraints' table on Azure SQL but there was still a few other issues I didn't have the time to dig in to.

But, I will be installing 6.0.4 soon and hopefully all is well.

Thanks again to Ernst and yourself for responding.