Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-98193

LayoutPageTemplateEntries with no LayoutPageTemplateCollectionId are not cleaned up upon group deletion

    Details

      Description

      Description
      https://github.com/liferay/liferay-portal/blob/master/modules/apps/layout/layout-page-template-service/src/main/java/com/liferay/layout/page/template/internal/model/listener/GroupModelListener.java

      When a Group is deleted, all LayoutPageTemplateCollections are cleaned up, which in turn cleans up all LayoutPageTemplateEntries, however since it is now possible to have a LayoutPageTemplateEntry with no LayoutPageTemplateCollectionId, some layoutPageTemplateEntries, mainly Display Pages will not properly get removed from the DB upon group deletion. This will likely affect customers who want to clean up some sites to improve database table query speeds.

      Steps to Reproduce

      1. Add a LayoutPageTemplateEntry with no layoutPageTemplateCollectionId
      2. Delete group LayoutPageTemplateEntry is in
      3. Assert layoutPageTemplateEntry is removed from database

      Expected Result
      LayoutPageTemplateEntry deleted

      Actual Result
      LayoutPageTemplateEntry present

      Tested on Tomcat 9.0.10 + MySQL 5.7
      Portal master GIT ID: e4ca8e0fc87b963340338fc413fe068ad88761dc

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              kyle.miho Kyle Miho
              Reporter:
              kyle.miho Kyle Miho
              Participants of an Issue:
              Recent user:
              Jason Pince
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 16 weeks, 3 days ago

                  Packages

                  Version Package
                  7.2.10 DXP FP1
                  7.2.X
                  7.2.1 CE GA2
                  7.3.10 DXP GA1
                  Master