Copied to clipboard

Flag this post as spam?

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


  • Dan Evans 629 posts 1016 karma points
    Mar 26, 2013 @ 09:26
    Dan Evans
    0

    Error when emptying recycle bin

    We recently upgraded to 6.0.2 from 4.7 and now cannot ampty the recycle bin. Getting the following error when the web service /webservices/trashcan.asmx/EmptyTrashcan is called but there is no information about which node is causing the conflict:

    System.Data.SqlClient.SqlException: The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode". The conflict occurred in database "rbl_umbraco_6x", table "dbo.umbracoNode", column 'parentID'.
    The statement has been terminated.
       at System.Data.SqlClient.SqlConnection.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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Umbraco.Core.Persistence.Database.Execute(String sql, Object[] args)
       at Umbraco.Core.Persistence.Repositories.PetaPocoRepositoryBase`2.PersistDeletedItem(TEntity entity)
       at Umbraco.Core.Persistence.Repositories.ContentRepository.PersistDeletedItem(IContent entity)
       at Umbraco.Core.Persistence.Repositories.RepositoryBase`2.PersistDeletedItem(IEntity entity)
       at Umbraco.Core.Persistence.UnitOfWork.PetaPocoUnitOfWork.Commit()
       at Umbraco.Core.Services.ContentService.EmptyRecycleBin()
       at umbraco.cms.businesslogic.RecycleBin.CallTheGarbageMan(Action`1 itemDeletedCallback)
       at umbraco.presentation.webservices.trashcan.EmptyTrashcan(RecycleBinType type)
    

     

Please Sign in or register to post replies

Write your reply to:

Draft