I looked at the options and see there is a field for File Deleting and the options are Trash and Force. Do I understand this correct? If I have Trash selected it sets the state to -2, but if I set it to force, it's actually removed?
*Also just a note for others reading this thread, I had over 170 folder to recover. Fortunately they were all created at the same time so their ID numbers were consecutive (numbers 2950-3121). The following MySQL statement worked to make them visible again:
UPDATE plrpt_joomdoc_file SET state=1 WHERE id>2949 and id<3122
I viewed the table and executed the code using the MySQL module in WebMin on an Ubuntu Linux server.