1
Vote

Installation Error (DNN 07.01.01 with 7.0.0 module)

description

Env:
  • DNN 07.01.01
  • DNN_Announcements 7.0.0 source package
Error:
StartJob Starting Installation
Info Starting Installation - DNN_Announcements
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\Install.07.00.00.SqlDataProvider
Info Created - Providers\DataProviders\SqlDataProvider\Install.07.00.00.SqlDataProvider
Info Executing Install.07.00.00.SqlDataProvider
Info Start Sql execution: Install.07.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Announcements'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:ea5fc98f-60ea-4f17-825f-3b07989b254d CREATE TABLE dbo.zp_[Announcements]( [ItemID] [int] IDENTITY(0,1) NOT NULL, [ModuleID] [int] NOT NULL, [CreatedOnDate] [datetime] NULL, [Title] nvarchar NULL, [URL] nvarchar NULL, [ExpireDate] [datetime] NULL, [Description] nvarchar NULL, [ViewOrder] [int] NULL, [CreatedByUserID] [int] NOT NULL, [PublishDate] [datetime] NULL, [ImageSource] nvarchar NULL, [LastModifiedByUserID] [int] NULL, [LastModifiedOnDate] [datetime] NULL, [PortalID] [int] NULL, CONSTRAINT [PK_zp_Announcements] PRIMARY KEY CLUSTERED ( [ItemID] ASC ) ) System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Announcements'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:69a7b3ed-7284-4df3-af25-06778a6d4daf ALTER TABLE dbo.zp_[Announcements] WITH CHECK ADD CONSTRAINT [FK_zp_Announcements_Modules] FOREIGN KEY([ModuleID]) REFERENCES dbo.zp_[Modules] ([ModuleID]) ON DELETE CASCADE System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near 'Announcements'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:a1366071-1dcc-4299-a5af-600854d0e479 ALTER TABLE dbo.zp_[Announcements] CHECK CONSTRAINT [FK_zp_Announcements_Modules]
Info End Sql execution: Install.07.00.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_Announcements
Info Deleted temporary install folder
EndJob Installation Failed

Jesse

comments