Bug #23266 Bug Fixed

Deleting an MSM site removes data it should not

Version: 3.5.3 Reporter: cherrycreekmortgage

Deleting a MSM site clears all data from the exp_channel_member_groups table.

After deleting the site I found that all Channel Layouts stopped working for all the sites in this MSM install. Tracking things backwards I found that all channel layouts no longer had member groups selected to use that layout. Most layouts are only for Super Admins but the checkbox was no longer checked. One site has a second member group using the layouts and that group no longer showed up on the layout form so I tracked further and found the group settings were set so they had no longer had access to any of the channels.

I have a database dump prior to deleting the site which has content in this table and one afterwards where the table is empty.

  • Looks like all layout permissions are removed too for non-SuperAdmin groups.

    I reimported the “exp_channel_member_groups” table from my backup and Super Admin is checked to use the Channel Layouts again but not the other group which should use all the layouts on one of the MSM sites.

    cherrycreekmortgage
    01st November, 2017 at 10:55pm
  • Looks like all plugin permissions were removed too. The exp_module_member_groups table is empty also.

    cherrycreekmortgage
    01st November, 2017 at 11:04pm
  • Sorry about that, I’m glad you have a backup. As this is data-loss related, this bug has been marked for a priority fix.

    Derek Jones
    02nd November, 2017 at 12:25am
  • I was not able to restore the full backup because I’d already started work on two new sites by the time I found the problems. I restored data manually from the tables I found to be empty. It’s possible there are other tables affected that haven’t revealed themselves yet.

    cherrycreekmortgage
    02nd November, 2017 at 1:17pm
  • Ok, it looks like the following are the potentially affected tables:

    • exp_channel_member_groups
    • exp_module_member_groups
    • exp_template_no_access
    • exp_upload_no_access
    • exp_status_no_access
    • exp_layout_publish_member_groups

    May have group assignments that need to be re-assigned.

    Derek Jones
    02nd November, 2017 at 2:17pm

You must be signed in to comment on a bug report.

ExpressionEngine News

#eecms, #events, #releases