1
Vote

Install error

description

Hi All,

I am trying to install 2sic_2SexyContent_08.04.02_Install.zip on DNN 07.04.00 (353) (SQL SERVER 2014 Express Edition) and I am getting the following error. I have tried 5 times all with the same result.

Any help appreciated.

Start Sql execution: 02.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Column 'IsCurrent' in table 'ToSIC_EAV_Values' is invalid for creating a default constraint. Could not create constraint or index. See previous errors. 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:8355b614-428d-4ce5-a4ec-f077a16ef86a Error Number:1752,State:0,Class:16 / Object: Default [DF_ToSIC_EAV_Values_IsCurrent] Script Date: 05/09/2012 10:28:57 / IF Not EXISTS (SELECT * FROM sys.default_constraints WHERE object_id = OBJECT_ID(N'[dbo].[DF_ToSIC_EAV_Values_IsCurrent]') AND parent_object_id = OBJECT_ID(N'[dbo].[ToSIC_EAV_Values]')) Begin IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_ToSIC_EAV_Values_IsCurrent]') AND type = 'D') BEGIN ALTER TABLE [dbo].[ToSIC_EAV_Values] ADD CONSTRAINT [DF_ToSIC_EAV_Values_IsCurrent] DEFAULT ((1)) FOR [IsCurrent] END End

comments

JaxUK wrote May 4, 2016 at 8:07 AM

Has anyone got any ideas on this... ???

Thanks