Thread

Hi,

I have set up a member group for ‘site admins’.

They can do pretty much everything bar touch templates and most critical settings.

When I however add which channel assignments this group can use, the ‘guest’ group then clears all it’s channel assignments to NO to all channels.

And visa versa!!!

Any ideas?

Hey there Jez Timms,

Welcome to the ExpressionEngine forums!!!

I am sorry to hear you are running into this problem.

Can you tell me what version of ExpressionEngine you are currently running?

Thank you,

I’m having the same problem:
EE 2.5.3 build 20120911
(recently upgraded from 2.3.1)

Editing any member group causes all other member groups to lose their channel assignments.

Steps to reproduce:
- Edit membergroup A and enable all channel assignments
- Edit membergroup B and enable all channel assignments
- membergroup A has now lost its channel assignments

As a workaround I’m using this SQL-query (you’ll have to modify it to match your own member groups and channels):

insert ignore
into exp_channel_member_groups
select
mg.group_id as group_id,
c.channel_id as channel_id

from exp_member_groups as mg

inner join exp_channels as c

where
1
and
(mg.group_title in (“Membergroup A”)
and c.channel_name in (“channel_one”, “channel_two”, “channel_three”)
)
)
or
(mg.group_title in (“Membergroup B”)
and c.channel_name in (“channel_one”, “channel_three”)
)
)
or
(mg.group_title in (“Members”)
and c.channel_name in (“channel_one”, “channel_four”,
)
)
or
(mg.group_title in (“Guests”)
and c.channel_name in (“zoo_visitor”)
)

;

This fixed it for me:
https://support.ellislab.com/bugs/detail/18234

Hi Kees Internet,

Thanks for the update, I’m glad the bug fix worked for you!

Jez Timms,

Can you check the bug fix as well?

Is there anything else I can assist you with?

Cheers,