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

Removing the Site does not remove related rows from TrashEntry or TrashVersion table

    Details

    • Type: Bug
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 6.2.10 EE GA1, 7.0.0 M3
    • Fix Version/s: 7.0.0 M3
    • Component/s: DM
    • Labels:
      None

      Description

      How to see this:

      1. Create site called "To be removed"
      2. Go to site configuration and write down the site id.
      3. Add some files by to site's DB.
      4. Move these files to Recycle bin
      5. Check if the site and the entries are at visible at DB.

      Replace <site id> that you did note down.

      Check that group exists:
      select * from Group_ where groupId = <site id>

      • expected result: row exist

      Check that DLFileEntry exist

      select * from DLFileEntry where groupId = <site id>

      • expected result: rows exists

      Check that recycle entries exists at DB:

      select * from TrashEntry where groupId = <site id>

      • expected result: rows exists

      6. Delete site from Site menu
      6. Check if the site and the entries are at visible at DB.

      Replace <site id> that you did note down.
      Check that group has been deleted:
      select * from Group_ where groupId = <site id>

      • Expected result no rows CORRECT

      Check that DLFileEntry exist

      select * from DLFileEntry where groupId = <site id>

      • Expected result no rows CORRECT

      Check that recycle bin entries has been deleted.
      select * from TrashEntry where groupId = <site id>

      • Expected result no rows (WRONG – ROWS exists)

      BTW: Root cause of this issue is caused by that we do not have Referential integrity defined on our database.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                linda.sui Linda Sui
                Reporter:
                sampsa.sohlman Sampsa Sohlman (Inactive)
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  5 years, 23 weeks, 1 day ago

                  Packages

                  Version Package
                  7.0.0 M3