Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Fix Data Integrity Issues once Integrity Checker solves conflicts for Roles. #13067

Closed
joseorsini opened this issue Nov 15, 2017 · 3 comments
Closed

Comments

@joseorsini
Copy link
Contributor

If a CMS Tab/Tool depends on an user-created role, the Integrity Checker does not update references on environments and process fail because of enforced Data integrity objects in DB side (foreign Keys).

Scenario is:

  1. Create a role on separate environments, using the same role name and key.
  2. Create a custom tab for it and assign different tools for it.
  3. Run the integrity checker. A conflict between roles is found.
  4. Whether a local or remote fix is triggered, it fails because the layouts_cms_roles table enforces data integrity with cms_role table. Once the new role is recreated on the DB, old one is dropped but existing references between it and CMS Tabs are not properly updated.
joseorsini added a commit that referenced this issue Nov 15, 2017
@joseorsini
Copy link
Contributor Author

PR: #13068

@bryanboza
Copy link
Member

Fixed, tested on the last master // Postgres // Chrome

@joseorsini
Copy link
Contributor Author

Please include this one for 4.3.3 release.
Requested by customer: https://dotcms.zendesk.com/agent/tickets/95565

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

5 participants