1

Closed

Installation error on DNN 6.1.4

description

Info
 
Starte SQL-Ausführung: Datei 01.02.00.SqlDataProvider
 
Abbruch
 
Die SQL-Ausführung hat folgende Fehler verursacht: System.Data.SqlClient.SqlException: ALTER TABLE failed because the following SET options have incorrect settings: 'ARITHABORT'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(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) -- This is to allow more than one label controls per form, but require unique labels for all other controls ALTER TABLE dbo.helferlein_FormItem ADD FormItemUniqueLabelPerForm AS (CASE WHEN FormItemLabel IS NULL THEN (LTRIM(STR(PortalID)) + '-' + LTRIM(STR(ModuleID)) + '-' + LTRIM(STR(FormItemID)) + '-' + LEFT(LTRIM(RTRIM(CAST(FormItemValue AS nvarchar(100)))) + REPLICATE('-', 100), 100)) ELSE FormItemLabel END) PERSISTED System.Data.SqlClient.SqlException: Column name 'FormItemUniqueLabelPerForm' does not exist in the target table or view. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(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) ALTER TABLE dbo.helferlein_FormItem ADD CONSTRAINT IX_helferlein_FormItem_UniqueLabelsPerForm UNIQUE ( PortalID ASC, ModuleID ASC, FormItemUniqueLabelPerForm ASC ) ON [PRIMARY] .
 
 
 
Info
 
SQL-Ausführung beendet: Datei 01.02.00.SqlDataProvider
 
 
 
Info
 
SQL-Ausführung abgeschlossen.
 
 
 
Abbruch
 
Installation fehlgeschlagen - Script
Closed Mar 31, 2012 at 5:46 AM by Maikl
Propably not an issue of the module.

comments

stedan wrote Mar 30, 2012 at 9:35 AM

On my local machine it's working seems to be a hosting provider related problem ...

Maikl wrote Mar 31, 2012 at 5:45 AM

There seems to be something wrong with the SQL Server settings. Please pay attention to ARITHABORT.

http://msdn.microsoft.com/de-de/library/ms190306.aspx

Best wishes
Michael