Emails still in database after member's account is deleted

I just happened to notice there are entries in the database showing emails sent to me from a deleted member. The mail is NOT in my mail folders, and obviously not in there's, so why is it still in the database. With big sites, that could be a mess when members start deleting their accounts, or get booted. Shouldn't all entries be gone once the account is closed? I'm reaching 1000 members, and can see this being a problem.

there's an option in admin
Database Pruning   Clean old messages ( days ): that might help, i know it's not the best solution. If a members account is deleted all content should be deleted as well.

Just a question: only emails remain? Have you checked photos, music and video files? In our case, these 3 remain in the old accounts moved from D6 to D7...

regards,

I don't know, I was going to check photos, but didn't get that far. There's over 28,000 images in the photo directory, so that could be a pain in the butt. I don't understand how, if it's not in the senders folders OR the recipients folders, where the message actually is. That's a MAJOR flaw in dolphin IMO. 

I could not agree more, but it looks like we are the only 2 thinking like that...worse, going trough the photos, if you find photos with no user name attached and you delete them, then you will be back in page 1....it took us a week to go trough our files, so good luck...

You dont need to go through the photos, what you can do is a database query searching for the userID of which you Are having the problem. Alternatively, you can query the database for ownerID that does not exist on the orofiles table. Every user is assigned a uniqueID, every photo has a column that is associated with that uniqueID, so finding a photoID that does not have a profileID associated should not be that difficult to locate. If you already kniw the userID then that would make it a bit simpker, and you could search the entire database for anything lingering that may have belonged to that userID

@DosDawg, as usual, thanks for the very useful information. I do not like to mess up with the DB and the team was doing some more important stuff, so I guess it looks like I did it the hardest way...lol..in the end, we have solved our DB related issues by simply making the deleting of the accounts only possible by the Admin, after user request...

Regards,

 I deleted 9k photos that weren't attached to any profiles. I set the page to show 130 photos per page before I started deleting them, THEN I'd have to go back to page 1, then try to find where I left off. I'm seriously thinking of switching over to phpFox, I can't see that this will be a reliable software for large sites

 in the database, you should be able to query the images that have no associated userID in the profile table, then you should also be able to extract that list of imageID's. based on the imageID, you can then run a bash script or create a php script that will run through the media directory and rm -rf those imageID's

 you can query the database, save the query result csv, then use that csv to run through a loop to clean up the directory.