Install issue DNN6.2.4 .NET 4

Jan 21, 2013 at 3:46 PM

Hi Michael,

I just tried installing helferlein form on DNN 6.2.4 (.net 4.0)

And I get this install error:

Start Sql execution: 01.02.00.SqlDataProvider file
Failure     SQL Execution resulted in following Exceptions:

System.Data.SqlClient.SqlException (0x80131904): 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() 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

(0x80131904): 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() 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     End Sql execution: 01.02.00.SqlDataProvider file

 

Do you have any idea what might cause this?

Thanks, Timo

 

Jan 21, 2013 at 3:53 PM

Ok, found it. The compatibility of the DB was set to 80 (SQL 2000), now that it is set higher the installer does work.

Timo

Coordinator
Jan 23, 2013 at 6:18 AM

Hi Timo,

SQL Server 2000 does not support the XML datatype which is used by helferlein_Form... If you do not have any other chance, there are some older versions of helferlein_Form available on www.helferlein.com which run on DNN 4 and SQL Server, but they are - of course - not supported any longer.

Best wishes
Michael

Jan 23, 2013 at 11:03 AM

The DB started back in the SQL 2000 days, but runs on SQL 2008 now.
I didn't notice it was still in that mode, changing that solved the issue.

Thanks, Timo