I just downloaded UmbracoContour_1.1.13.2.zip and tried to install it to Umbraco 4.8.1 and I got following errors
he INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoUser2app_umbracoApp". The conflict occurred in database "GRS_Infosite_DEV", table "dbo.umbracoApp", column 'appAlias'.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoUser2app_umbracoApp". The conflict occurred in database "GRS_Infosite_DEV", table "dbo.umbracoApp", column 'appAlias'.
The statement has been terminated.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoUser2app_umbracoApp". The conflict occurred in database "GRS_Infosite_DEV", table "dbo.umbracoApp", column 'appAlias'.
OK, I managed to get it going. We've upgraded Umbraco through a few versions and it seems that umbracoApp used to have some FK contraints on it but no longer does in the current version. The upgrade process doesn't remove these constraints so I removed them manually and Contour then successfully installed.
Error installing Contour
I just downloaded UmbracoContour_1.1.13.2.zip and tried to install it to Umbraco 4.8.1 and I got following errors
he INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoUser2app_umbracoApp". The conflict occurred in database "GRS_Infosite_DEV", table "dbo.umbracoApp", column 'appAlias'.
The statement has been terminated.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoUser2app_umbracoApp". The conflict occurred in database "GRS_Infosite_DEV", table "dbo.umbracoApp", column 'appAlias'.
The statement has been terminated.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[SqlException (0x80131904): The INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoUser2app_umbracoApp". The conflict occurred in database "GRS_Infosite_DEV", table "dbo.umbracoApp", column 'appAlias'.
The statement has been terminated.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6368941
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6370642
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +689
System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +327
Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +167
umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +150
[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +261
umbraco.BusinessLogic.User.addApplication(String AppAlias) +229
Umbraco.Forms.UI.Usercontrols.Installer.Page_Load(Object sender, EventArgs e) +3665
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
System.Web.UI.Control.LoadRecursive() +71
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064
Did you get this working in the end? I've having the same issue with Contour 1.1.13.2 on Umbraco 4.8.
OK, I managed to get it going. We've upgraded Umbraco through a few versions and it seems that umbracoApp used to have some FK contraints on it but no longer does in the current version. The upgrade process doesn't remove these constraints so I removed them manually and Contour then successfully installed.
is working on a reply...