Hi Greengiant83

Hmm, that's odd...

Could this perhaps be a permission issue?

/Jan

I am not sure how it could be. I am logged in as the default admin user trying to do the delete. So I should have all the permissions I need there. As for the phyiscal folder on the file system, I gave Everyone full control, so it shouldnt be a file system permissions issue. The app's connection string is connecting to the database via the SA account so there shouldnt be any issue there either.

Can you think of any other places to check?

I don't know why it is hanging, but I got the trash can emptied by manually removing the content from the database tables by executing this sql for each record in the umbracoNode table where parentID = -20

  delete from [Umbraco].[dbo].cmsDocument where nodeId = 123

  delete from [Umbraco].[dbo].cmsContentXml where nodeId = 123

  delete from [Umbraco].[dbo].cmsPreviewXml where nodeId = 123

  delete from [Umbraco].[dbo].cmsPropertyData where contentNodeId = 123

  delete from [Umbraco].[dbo].cmsContentVersion where ContentId = 123

  delete from [Umbraco].[dbo].cmsContent where nodeId = 123

  delete from [Umbraco].[dbo].umbracoNode where id = 123

I have the same issue. I currently have 5300 items in my recycle bin, due to testingt auto import stuff within Umbraco 4.7.

I cleaned it up with the following sql:

DECLARE @nodeId int

DECLARE node_cursor CURSOR FOR
SELECT Id
FROM umbracoNode
WHERE ParentId = -20

OPEN node_cursor;

FETCH NEXT FROM node_cursor
INTO @nodeId;

WHILE @@FETCH_STATUS = 0
BEGIN
    delete from [dbo].cmsDocument where nodeId = @nodeId
    delete from [dbo].cmsContentXml where nodeId = @nodeId
    delete from [dbo].cmsPreviewXml where nodeId = @nodeId
    delete from [dbo].cmsPropertyData where contentNodeId = @nodeId
    delete from [dbo].cmsContentVersion where ContentId = @nodeId
    delete from [dbo].cmsContent where nodeId = @nodeId
    delete from [dbo].umbracoNode where id = @nodeId
   
     FETCH NEXT FROM node_cursor
    INTO @nodeId
END
CLOSE node_cursor;
DEALLOCATE node_cursor;

This SQL code works fine for me.
Thanks Ingmar Hoogendoorn

I'm guessing it's possible to have event handlers in your code which should fire when deleting items from the recycle bin?

Obviously in this case they won't fire :-]

is working on a reply...