I have a client who saves a ton of deleted resources on their ModX install. Today I noticed they were gone. I've done a fairly recent upgrade to 2.3.3. Is it possible that the upgrade permanently erased the deleted resources? Are there any tips, suggestions for troubleshooting or solving this problem? I'm at the point where I am ready to roll back changes, but unfortunately the most recent backups are several months ago.
This is not very likely, but it's worth checking. It's possible that the resources are still there but not showing in the tree. A look in the modx_site_content table in the database will tell you. If they're still there, they'll have a 1 in the deleted field (and may have a 0 in the show_in_tree field).
That logs his username and the date/time of the action. I've actually made a pull request to get that added to the 2.4.0-dev, so if they accept it it will become part of the core.
In the meantime, it might be safer to use the same function in a plugin.
I took a look at the site_content table, but there were no records with show_in_tree set to 0. I was able to update the sql files though and rescue about 100 resources. Sotwell, I think I will add that plugin to my sites as it will no doubt be quite useful in the future. Thanks for your help!