Anyone know how the hash column is calculated? In metadata_items, the hash column there is based on the guid field that is also there. The guid is based on the agent for that file. For items using the personal media scanner, it uses this hash value from media_parts.
My reason for this question is that I noticed that sometimes the guid is not updated which leads to wrong posters and metadata which are based on the hash in metadata_items. In cases of home videos, the hash in media_parts is also not updating, so the guid doesn't update, so that hash doesn't update, so posters do not update. So I want to manually update the hash in media_parts so I can update down the line.
Thanks in advance.
