Hi Philippe,

I've consult this with our developer, it is not advisable to move user photo album to group photo album using sql query, as there will be much complication will occur as it was related with privacy, ownership, notification and stream generate

Thank you for response Fadhli.

Ok. In this case, are the following manual SQL manipulations correct ?


ALBUM USER TO GROUP


1° Most important

#_social_albums
uid : put group id
type : put group

#_social_photos
uid : put group id
type : put group



2° Optional

#_social_stream
cluster_id : put group id
cluster_type : put group
cluster_access : put 1

#_social_stream_item
params :
If "uid":"USER ID","type":"user"
replace to "uid":"GROUP ID","type":"group"



3° Comments and Reactions

#_social_comments
element :
If albums.user.create
replace to albums.group.create

If photos.user.add
replace to photos.group.create


#_social_likes
type :
If photos.user.add
replace to photos.group.create

If comments.user.like
keep this value (same for Group)


I am aware that this is complex. But I tried and it works.
What do you think ?

Thank you,
Philippe

Yes Philippe correct!

That is true ? I did not make any mistakes, nor any forgets ?

No other table is impacted ?

Thanks

Yes

Ok nice

And for Pages, I've tested same methods and this works too.
I know that in principle a user can not create an album in his name on a Page.
But thanks to customs files, it's possible.

There is just the word "group" which becomes "page" :

You also confirm that it's good ?


ALBUM USER TO PAGE


1° Most important

#_social_albums
uid : put page id
type : put page

#_social_photos
uid : put page id
type : put page



2° Optional

#_social_stream
cluster_id : put page id
cluster_type : put page
cluster_access : put 1

#_social_stream_item
params :
If "uid":"USER ID","type":"user"
replace to "uid":"PAGE ID","type":"page"



3° Comments and Reactions

#_social_comments
element :
If albums.user.create
replace to albums.page.create

If photos.user.add
replace to photos.page.create


#_social_likes
type :
If photos.user.add
replace to photos.page.create

If comments.user.like
keep this value (same for Page)


Philippe

The dataset seems correct but I really would not recommend you to alter data through the database as it may eventually cause corrupted data if you are not careful.

Thank you Mark. Yes I will be careful.

I have a question.
For #_social_stream_item and #_social_stream, is the value "params" mandatory ?
And indicating the group id and type.

Or can I leave #_social_stream_item as is, without changing anything ?
To limit my intervention.

What is the usefulness of this data "params"?

Philippe

Hi Philippe,

Basically, the use of params is related to performance, where as stream items on feed might load the easysocial's table vigorously. Getting data from param will make your site performance a lot better

Ok I see

Thanks Fadhli

You are most welcome,

Just for your information, I have locked and marked this thread as resolved to avoid confusions in the future. Please start a new thread if you have any other issue in the future so it will be easier for us to manage your inquiries.

Thanks for understanding