I have a Alfresco 4.1.1.3 with many files more of 10000. I have moved all data in trashcan, now I need to recover some files, but when I try to read the trashcan I get a read time out 408. This error is already present in bug report for other actions. Can I recover some files with direct access to database? For example with a simple sql UPDATE.
I see the problem is resolved with version 4.1.3, but I can't upgrade now. I need to recover data from trashcam. Can I export trashcan to FTP? I analyzing DB. In table ALF_NODE there is the field STORE_ID where in ALF_STORE there are 2 SpacesStore: archive and workspace. archive is used for Trashcan and workspace is the default. I can't update the table ALF_NODE I have a constraint violation if I try to update STORE_ID from 5 (archive) to 6 (workspace).
I had the trashcan timeout problem on share a while ago too. I retrieved the file by going through the old explorer interface (http://[yourServer]/alfresco) > login > user profile > Manage Deleted Items . Here you can search for your file instead of brutally displaying everything. Then you can recover it.