Sign in Register
Copied to clipboard

Flag this post as spam?

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


This forum does not allow new topics to be created, please use the v2 forum from now on.

  • Connie DeCinko 931 posts 1159 karma points
    Nov 29, 2010 @ 16:54
    Connie DeCinko
    0

    Error Uninstalling 1.1 Package

    When uninstalling the 1.1 package, the following error appears:

    The DELETE statement conflicted with the REFERENCE constraint 
    "FK_cmsPropertyData_cmsPropertyType". The conflict occurred in database 
    "umbracoCMS", table "dbo.cmsPropertyData", column 'propertytypeid'.
    The statement has been terminated.

     

    Stack Trace:

    [SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_cmsPropertyData_cmsPropertyType". The conflict occurred in database "umbracoCMS", table "dbo.cmsPropertyData", column 'propertytypeid'.
    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.RunExecuteNonQueryTds(String methodName, Boolean async) +2840828
       System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +504
       System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +327
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +167
       umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteNonQuery(String commandText, SqlParameter[] parameters) +173
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +212
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery]
       umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters) +356
       umbraco.cms.businesslogic.propertytype.PropertyType.delete() +408
       umbraco.cms.businesslogic.datatype.DataTypeDefinition.delete() +233
       umbraco.presentation.developer.packages.installedPackage.confirmUnInstall(Object sender, EventArgs e) +5422
       System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +154
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3691

     

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Nov 29, 2010 @ 17:00
    Stefan Kip
    0

    Mike Taylor experienced the same problem: http://twitter.com/#!/m1ketayl0r/statuses/8083633889873920
    His problem were some rogue DB entries: http://twitter.com/#!/m1ketayl0r/statuses/8090779322945536

    So the problem isn't the 301 URL Tracker, but a DB with entries which shouldn't be there.

    Copy Link
  • Connie DeCinko 931 posts 1159 karma points
    Nov 29, 2010 @ 17:05
    Connie DeCinko
    0

    I'm glancing through that table... what should I be looking for?  Sounds like from his second tweet that he still has issues.

     

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Nov 29, 2010 @ 17:09
    Stefan Kip
    0

    I don't know the exact problem. I already asked him if he could join this topic :-)
    He still had an issue, but it didn't have anything to do with this. Quote from his tweet: "and managed to uninstall the old version"

    Copy Link
  • Mike Taylor 155 posts 353 karma points
    Nov 29, 2010 @ 17:09
    Mike Taylor
    1

    Hi there

    In the cmsPropertyType table, I found the row for "Redirect301" and noted the id.

    Then, in the cmsPropertyData table, I just deleted any rows which had that id in the propertytypeid column.

    (NB Back up your database before you do this, just in case!)

    Mike

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Nov 29, 2010 @ 17:10
    Stefan Kip
    0

    Thanks a lot mike! :-)

    Copy Link
  • Connie DeCinko 931 posts 1159 karma points
    Nov 29, 2010 @ 17:13
    Connie DeCinko
    0

    I have no entry in cmsPropertyType for "Redirect301".

     

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Nov 29, 2010 @ 17:16
    Stefan Kip
    0

    How about '301URLTracker'?

    Copy Link
  • Connie DeCinko 931 posts 1159 karma points
    Nov 29, 2010 @ 17:18
    Connie DeCinko
    0

    Nothing with 301.  The entry is still showing in my Data Types and when I click on it, I get "The given key was not present in the dictionary."

     

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Nov 29, 2010 @ 17:20
    Stefan Kip
    1

    Recycle you appPool (or 'touch' the web.config). Then it should be gone.

    After that try to uninstall 1.1 again...

    Copy Link
  • Connie DeCinko 931 posts 1159 karma points
    Nov 29, 2010 @ 17:31
    Connie DeCinko
    0

    Still the same.  No go.

    I decided to see what would happen, so I installed 1.2 package.  No errors, all seems to be ok, accept, now I have two entries for 301 URL Tracker in my list of installed packages.

     

    Copy Link
  • Connie DeCinko 931 posts 1159 karma points
    Nov 29, 2010 @ 18:06
    Connie DeCinko
    0

    Problem solved.  I used a different Alias for the datatype and it was still associated with my main doctype.  Removed that, and successfully uninstalled.

     

    Copy Link
  • Mike Taylor 155 posts 353 karma points
    Nov 29, 2010 @ 18:09
    Mike Taylor
    0

    Ah - makes sense - glad you got it figured out :-)

    Mike

    Copy Link
  • Stefan Kip 1606 posts 4098 karma points c-trib
    Nov 29, 2010 @ 18:23
    Stefan Kip
    0

    Great :-)

    Could you mark a reply as the answer, so this topic will appear 'Solved' on the forum page? Thanks! :-)

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies