Daily Log for #alfresco IRC Channel

Alfresco discussion and collaboration. Stick around a few hours after asking a question.

Official support for Enterprise subscribers: support.alfresco.com.

Joining the Channel:

Join in the conversation by getting an IRC client and connecting to #alfresco at Freenode. Our you can use the IRC web chat.

More information about the channel is in the wiki.

Getting Help

More help is available in this list of resources.

Daily Log for #alfresco

2019-11-05 08:11:56 GMT <alfresco-discord> <MorganP> Hello xkahn

2019-11-05 08:12:27 GMT <alfresco-discord> <MorganP> If you took the correct query (with the store on the last line), it should be working no matter in which store the file is

2019-11-05 08:12:45 GMT <alfresco-discord> <MorganP> Because it doesn't limit anything on the store id

2019-11-05 08:13:59 GMT <alfresco-discord> <MorganP> Can you just execute a simple: SELECT u.content_url AS "Location" FROM alf_content_url AS u WHERE u.content_url='store://YYYY/MM/DD/HH/MM/id.bin';

2019-11-05 08:14:26 GMT <alfresco-discord> <MorganP> To see if there is an entry in the alf_content_url table for the path you are looking for

2019-11-05 08:21:10 GMT <alfresco-discord> <MorganP> If there is no row, then the file might have been removed? In this case, it would have been moved to the contentstore.deleted folder and the row in the alf_content_url table has been removed as I described in another of my blog (https://blog.dbi-services.com/understand-the-lifecycle-of-alfresco-nodes/)

2019-11-05 08:21:12 GMT <alfbot> Title:Understand the Lifecycle of Alfresco Nodes - Blog dbi services Understand the Lifecycle of Alfresco Nodes - Blog dbi services (at blog.dbi-services.com)

2019-11-05 08:22:24 GMT <alfresco-discord> <MorganP> Maybe you can try a find from the alf_data folder (parent of contentstore & contentstore.deleted folders): find . -name c1c62ed0-dd19-473e-9235-73917935e2f3

2019-11-05 08:23:51 GMT <alfresco-discord> <MorganP> (it should keep the same path on the contentstore as well as contentstore.deleted if it was deleted)

2019-11-05 12:24:33 GMT <xkahn> MorganP: Ah! It's as you said. I found it!

End of Daily Log

The other logs are at http://esplins.org/hash_alfresco