Hey Amir,

I tried following the tips in the thread and I was able to execute some of the SQL, however a lot of them fails with errors like:

DELETE FROM cmsContent WHERE nodeId IN (SELECT id FROM umbracoNode WHERE (path LIKE '%-21%' AND id!=-21) OR (path LIKE '%-20%' AND id!=-20));

Error: The primary key value cannot be deleted because references to this key still exist. [ Foreign key constraint name = FK_cmsMedia_cmsContent_nodeId ]

DELETE FROM umbracoUser2NodePermission WHERE nodeId IN (SELECT id FROM umbracoNode WHERE (path LIKE '%-21%' AND id!=-21) OR (path LIKE '%-20%' AND id!=-20));

Error: The specified table does not exist. [ umbracoUser2NodePermission ]

I attempted to manually clear the content and media recycle bin but it doesn't work. If I manually clear 1 item in the bin I get a 404:

    Request error: The URL returned a 404 (not found):
/umbraco/backoffice/UmbracoApi/Media/DeleteById

The working SQL affected a lot of items so something has happened, I just cannot empty the bin.

// Mike