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, 1 day ago

                  Packages

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