Solved/CB GroupJive Gallery : DB Issue after changing author of a media in album

Hi !

Today I had a mess with an album photo in a group. The album is supposed to be fed by members of the group but for many reasons, it can be fed by the group owner or superadmin 'on behalf of' .... In order to link the photo with it's owner, I wanted to manually change the owner ID of each photo in backend ( plugin CB Gallery>Media>Owner) guessing it was a simple update of the database...

Unfortunatly this operation messed up the album :
- Changing the owner ID unlink the photo to the album ID ( this can be fixed in PHPMyadmin in table xxx_comprofiler_plugin_gallery_items)
- Loose the photo attached - not anymore visible in frontend as well as in backend ( in media folder comprofiler)

So I had to upload again each photo to recreate the album...

My question is : is there an explanation to this behavior (bug or not) and is there a way to makes this kind of operation easier ?

Thank you

Changing the album owner will move the original owner media into the new owners user id. So if the album has an owner of 100 and 3 photos also belonging to 100 then you change it to an owner of 200 then those 3 photos will also be changed to 200. The idea is it's a means of fully shifting ownership of the album and its contents. Will review adjusting this logic as it's probably only relevant for profile galleries and nothing else.

Beyond that nothing else happens during edit save unless Asset or Gallery where changed in which case it'll do similar logic for media within that album.

You can change Album and Media owner from backend. Frontend owner change was removed as it just caused confusion so that management will be left to backend. In backend you can do this per-album/media or use the Batch Tools to mass change the owner.

Ah OK. I understand the logic because the media folder are organised with user's ID as a root . But if I understand correctly, if I change the owner (in the backend) of a photo, the link to that photo will point to the new owner's folder while the photo file itself isn't moved. That's what's causing the problem. Is that correct?
 

Yes, that's currently a bug with that logic. I should have a fix out later today fixing it.

forge.joomlapolis.com/issues/9871

Ok, this is now fixed in latest CB Gallery build release. Changing album owner will no longer touch media owner in that album. Changing media owner will now also properly move the files.

Wow that's really nice ! This fix will be very useful for us because it allows administrators or moderators to upload media for helping some owners

There is one remaining issue, according to the problem i described (first topic) :

 - Changing the owner ID unlink the photo to the album ID ( this can be fixed in PHPMyadmin in table xxx_comprofiler_plugin_gallery_items)

In other words, the field folder_id is reset to 0 after changing the media owner (it should be kept at initial value)

Note: I just refer to change of media owner while media is in an album because, in our site, all photos must be in albums.