Files in the Recycle bin become orphaned when their parent folder has been deleted and the site is deleted

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.0.0 DXP SP3, 7.0.0 DXP FP22, 7.0.X EE, Master
• Fix Version/s: 7.1.X, Master
• Component/s: Document Repository Framework
• Labels: None
• Fix Priority: 3
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/51169

Files in the Recycle bin become orphaned when their parent folder has been deleted and the site is deleted.

Steps

1. Control Panel > Sites > Sites
2. Create a Site "Test Site"
3. Go to "Test Site" > Content > Documents and Media
4. Create a folder "test folder"
5. Create a file "test file" inside "test folder"
6. Query the database and remember the fileEntryId

   select * from DLFileEntry

7. Delete "test file" putting it into the recycle bin
8. Delete "test folder" putting it into the recycle bin
9. Navigate to the recycle bin and permanently delete "test folder"
10. Control Panel > Sites > Sites
11. Delete "Test Site"

Expected
All the file entries from "Test Site" will be deleted from the database.
Actual
The file "test file" is orphaned and is still in the database.