Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Hardy Wang 91 posts 112 karma points
    Sep 10, 2012 @ 18:17
    Hardy Wang
    0

    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

  • Chris Mahoney 242 posts 454 karma points
    Oct 19, 2012 @ 00:36
    Chris Mahoney
    0

    Did you get this working in the end? I've having the same issue with Contour 1.1.13.2 on Umbraco 4.8.

  • Chris Mahoney 242 posts 454 karma points
    Oct 19, 2012 @ 04:06
    Chris Mahoney
    0

    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.

Please Sign in or register to post replies

Write your reply to:

Draft