When deleting a site, the ResourcePermission records of its navigation menus are not deleted

• Type: Bug
• Status: Closed
• Resolution: Fixed
• Affects Version/s: 7.1.X, 7.2.X, 7.3.X, Master
• Fix Version/s: 7.1.X, 7.2.10 DXP FP17, 7.2.10.6 DXP SP6, 7.2.X, 7.3.X, 7.4.3.7 CE GA7, 7.4.13 DXP U3, 7.4.3.8 CE GA8, 7.4.13 DXP U4, Master
• Component/s: Navigation Menus
• Labels:
  • ee-ts
  • liferay-dxp-72-sp6
  • liferay-fixpack-dxp-17-7210
  • liferay-fixpack-dxp-27-7110
  • liferay-fixpack-dxp-4-7310
  • liferay-update-dxp-3-7413
  • liferay-update-dxp-4-7310
• Branch Version/s:
  7.3.x, 7.2.x, 7.1.x
• Backported to Branch:
  Committed
• Fix Priority: 2
• Git Pull Request: https://github.com/liferay-echo/liferay-portal/pull/6849

When deleting a site, there are some database wrong references, the ResourcePermission records of its navigation menus are not deleted

Steps to reproduce

1. Create a site
2. Add a navigation menu to the new site
3. Execute the SQL:

   select * from SiteNavigationMenu

   to get the SiteNavigationMenuId of the created navigation menu

4. Execute this SQL:

   select * from ResourcePermission where primKeyId = <SiteNavigationMenuId>

   ==> this query should return some records

5. Delete the previously created site
6. Execute again the SQL of step number 3:
   • Expected behavior: the query doesn't return any record
   • Wrong behavior: the query returns some records