A user creates a group. That user has a designation in the db as jomsocial group owner. Sometimes this designation is lost and must be reset manually in the back end of Joomla. Why am I having this problem and what can be done about it?
Thanks,

Hi, Bernerd.

Are there any special circumstances when user lost his designation as group owner?
Does it happen after a while or right after user creates a group?

It happens after a while. I will reset it then it will happen again. I reset it by going into the joomla user back end. I can see if I have the problem by using this query.
SELECT distinct cg.ownerid, us.name FROM `jos_community_groups` as cg
left join jos_users as us on cg.ownerid = us.id
where cg.ownerid not in
(select ugm.user_id from jos_user_usergroup_map as ugm where ugm.group_id=9)

Yesterday I was looking on the forums for an answer and really didn't find anything. today, I did find something that seemed related but I'm not sure. this is the post. www.jomsocial.com/forum/technical-issues...nging?start=14#99622 . would you say this is the same as my issue?
thanks,
Bernie

Hi, Bernard.

No, linked thread apply to JOOMLA GROUPS.
Your issue apply to JomSocial group ownership.
Let me do some tests. I've registered a user, created a group and joined two others. Ran cron job...
Let's wait a while...

Hi, Bernard.

I created a group yesterday... I checked it today and still I'm group owner:

index.php?option=com_community&view=groups&task=viewmembers&groupid=91&Itemid=1246

I just checked and you aren't anymore. if I go to users/user manager search for Michal. the jomsocial group owner designation is no longer there. if you look at newcentral user you will see that there is a designation for jomsocial group owner.
thanks,

Hi, Bernard.

Please, take a look on the screen shot: prntscr.com/69z5vi

EDIT:

And I'm still able to perform admin actions for group: prntscr.com/69z6k3

This table jos_community_groups table is used by jomsocial. correct? I'm surprised that this behavior doesn't cause problems in your application at some point. we have used this table for some of our programming and that is the issue. So, I should expect no action on your part? is that correct?
thanks,
Bernie

Hi, Bernard.

jos_community_groups - yes, it's JomSocial table.It Stores information about group and in "ownerid" is ID of group owner.

I'm surprised that this behavior doesn't cause problems in your application at some point.

What behavior do you mean?

I'm really not sure what is your issue now as everything seems to work fine. I created a test group and after few day I was still a group owner/moderator. The only way that user lost his group owner ship is to remove his ID from "ownerid" column or replace it by other ID.

By "this behavior" I mean that for some reason id's are deleted from the table community_groups. Your testing has shown that the front end of Jomsocial continues to work correctly based upon looking at 2 pages (you've shown me 2 screen shots). Hence my comment that this behavior doesn't cause issues in the program. I would guess that maybe it's a table that was put in and at some point is not really used or needed.
Regarding your comment "I created a test group and after few day I was still a group owner/moderator. " Yes but you will notice that if you look at the joomla user manager in the backend the designation of Jomsocial Group owner is no longer there for you Michal jomsocial like it was when the group was first created..
Regarding your comment "The only way that user lost his group ownership is to remove his ID from "ownerid" column or replace it by other ID. " It is apparent that an individual can be the owner of a group and not be in this table (my query shows that group owners that aren't in this table) and your screen shot demonstrates that you are still the owner of the group you created. Even though the group owner has not changed the userid for the owner has been deleted from this table and no one went into the backend to delete the joomla user manager designation for this user.
If it doesn't matter to you/Jomsocial, I understand. That is good information because it means that if you don't see this as an issue then I need to find another way of doing what I'm doing (I'm using this table for custom programming). .
So, just let me know that you don't see any reason to look at this further.
I say my problem is not fixed because my problem still exists even though it is not really a problem as far as you're concerned.
Thanks,
Bernie

Hi, Bernard.

I've checked in every possible place, where group related information is displayed:

In backend - Group list: prntscr.com/6ahw0v
In backend - Members -> Assign to group: prntscr.com/6ahwbj
In frontent - Group list: prntscr.com/6ahwik
In frontend - group members: prntscr.com/6ahwpt

As you could see I;m group owner every where.

I don't check in database (you didn't provide any access). But if everywhere is my user ID... then it should be also in database in right.

As you can see I can't replicate on your site issue you write about. My ID is not deleted from database because as result my user should be removed... but it's still there.

Of course it does matter for us - we are here to help you... but I just can't replicate your issue.
Please, edit your first post and add PHPmyAdmin credentials. I'll check your database.

Hi, thank you for the quick response.
I've attached 4images.
1. A listing in the Joomla users menu showing users that have the jomsocial group designation
2. Your id with that designation missing
3. Art Adminer - under components that will get you access to the db using the joomla backend. just be sure to select the db before you select the sql query link in the top left hand of the page.
4. Results of runing this query showing that your user id is not in the table.

SELECT distinct cg.ownerid, us.name FROM `jos_community_groups` as cg
left join jos_users as us on cg.ownerid = us.id
where cg.ownerid not in
(select ugm.user_id from jos_user_usergroup_map as ugm where ugm.group_id=9)

if you go back to the joomla user manager and edit your id and select jomsocial group owner in the assigned groups tab and save then run the query again you will not see your id is no longer in the list meaning that it is now in the table. So by doing this you have put your user id back in the table.

Thanks for your support and realize that I don't make my comments about this in a bad way.
thanks,
Bernie

you will be able to see this using the JomSocSup login with password Jklo9876.
thanks,

Hi, Bernard.

I'm sorry... but you mistake two separated things:

Joomla Groups are NOT THE SAME as JomSocial Groups.
Creating group in JomSocial DOESN'T create group in Joomla! and make user a group owner of it.

Argh... we wasted so much time though because misunderstanding...
You titled your thread "User - Jomsocial Group Owner", mentioned _community_groups table... I was thinking from beginning that your issue apply to JOMSOCIAL GROUPS.

But it's not.

_user_usergroup_map has nothing to do with _community_groups (beside user ID). First table is related with JOOMLA, second is for JOMSOCIAL groups.

Now everything is clear for me. Issue you experience is a Joomla! bug. We already reported it some time ago:

issues.joomla.org/tracker/joomla-cms/5138