I was just creating a bunch of pages, found some common text that needed to be changed, used Janitor, and poof, all of my content disappeared from a selected group of resources. As a veteran of system issues like this, I usually do backups before critical operations, but in this case I knew I wouldn't lose much work.
So, having been scratched by the kitten I want to avoid being bitten by the lion.
When $modx->exec("query") is used, is a snapshot taken of the data before being updated? If this happens again, is there any hidden nook or cranny where content might be stored? Some pages are cached and I was able to recover one of the pages from cache, but this is clumsy and not guaranteed for newer resources.
Are there any tools for getting a quick snapshot before doing an update like this? I can use Janitor itself but I was wondering if there was some hidden snapshot options somewhere, or some other hidden Undo option showing the last database updates. Yeah, I know ... dream on ... Just askin...
About this issue with Janitor, there is an option for Searches to be RegEx. I was searching for "../assets/images" and I wanted to change it to "/assets/images/articles". The Janitor Replace is hard-coded for RegEx, and somehow those strings caused a global replacement of all characters to null.
Caveat Emptor even with FOSS.
Thanks.