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

Database references associated with deleted sites remain in the Layout table

    Description

    Description

    When deleting a site, not all references to the site are also removed, as entries in the Layout table containing the sites groupId still remain after the deletion has completed.

    Steps to Reproduce

    1. Launch a clean 7.3 bundle connected to an observable database type (such as MySQL)
    2. Create a test site "TestSite1"
    3. In a terminal window and/or utility, begin examining the database, then execute the query select * from Group_; and find the entry with the groupKey: TestSite1; making note of the groupId for that entry
    4. Within the bundle, create a blank content page "BlankPage1" on TestSite1, then publish the page without making any changes
    5. Execute the select * from Layout; query for the database, then make note of how many entries were present that included the groupId identified in step 3 (there were two in my case, for the friendly URLs "/a4a8730d-1dd5-4ec0-a322-d954e5f5a660" and "/blankpage1")
    6. In the bundle, delete the test site
    7. Execute the query select * from Layout; again

    Results of Testing

    Expected Result: All references to the test site would be removed
    Actual Result: There are still references in the Layout table to the deleted site's pages

    Errors/Logs

    No errors

    Master

    Partially reproduced – there is also a third entry including the “/manage” reference when performing the steps above in Master, which the client notes they have seen in 7.2 sites as well (I assume it is related to the ...control_panel/manage... link). After deleting the site, the /manage reference remains, though the other entries seem to be removed from the Layout table.
    Hash#: 8d17d473200786491e38ac7f6758b303db2c28f6

    Branch

    Not reproduced.
    Hash#: 2130773fbf87560ae927775e605c9b76c6c8beb6

      Attachments

        Issue Links

          Activity

            People

            Assignee:
            summer.zhang Summer Zhang
            Reporter:
            jorge.avalos Jorge Avalos
            Participants of an Issue:
            Recent user:
            Jorge Avalos
            Engineering Assignee:
            Michael Bowerman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Days since last comment:
              8 weeks, 1 day ago

                Packages

                Version Package
                7.4.13 DXP GA1
                Master