topic Re: How to delete content from contentstore that is not referenced in database??? in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/how-to-delete-content-from-contentstore-that-is-not-referenced/m-p/300472#M253602 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>the only sure way I can think of at this point is go for a SQL query to export the content URLs and whip up a script to remove these files.</SPAN><BR /><SPAN>Yes, the orphan handling should occur like you have stated. Your situation is indicative of a constellation where - for some reason - this did not work or was possibly circumvented by a poorly written addon (there are ways developers can write code that doesn't necessarily guarantee orphan detection / cleanup by Alfresco).</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Tue, 20 May 2014 08:28:20 GMT afaust 2014-05-20T08:28:20Z How to delete content from contentstore that is not referenced in database??? https://connect.hyland.com/t5/alfresco-archive/how-to-delete-content-from-contentstore-that-is-not-referenced/m-p/300471#M253601 Hi all,so I have a repository that contains binary files under alf_date/contentstore but I don't have that content in alf_content_url table in database. So it is obvious that somehow references to that content are removed from database but not from the file system (don't ask my how, I am new in this Mon, 19 May 2014 11:34:34 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-delete-content-from-contentstore-that-is-not-referenced/m-p/300471#M253601 nenad982 2014-05-19T11:34:34Z Re: How to delete content from contentstore that is not referenced in database??? https://connect.hyland.com/t5/alfresco-archive/how-to-delete-content-from-contentstore-that-is-not-referenced/m-p/300472#M253602 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>the only sure way I can think of at this point is go for a SQL query to export the content URLs and whip up a script to remove these files.</SPAN><BR /><SPAN>Yes, the orphan handling should occur like you have stated. Your situation is indicative of a constellation where - for some reason - this did not work or was possibly circumvented by a poorly written addon (there are ways developers can write code that doesn't necessarily guarantee orphan detection / cleanup by Alfresco).</SPAN><BR /><BR /><SPAN>Regards</SPAN><BR /><SPAN>Axel</SPAN></BODY></HTML> Tue, 20 May 2014 08:28:20 GMT https://connect.hyland.com/t5/alfresco-archive/how-to-delete-content-from-contentstore-that-is-not-referenced/m-p/300472#M253602 afaust 2014-05-20T08:28:20Z