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

After deleting one site, related datas was not deleted in assetentry table and dlfileshortcut

    Details

    • Branch Version/s:
      6.1.x
    • Backported to Branch:
      Committed
    • Story Points:
      2

      Description

      The issue only occured in 6.1.x. On trunk, the issue have been fixed in https://issues.liferay.com/browse/LPS-27510
      1. Create folder in Global named "test global folder"
      2. Upload a document into "test global folder" (I am uploading testGlobal.doc)
      3. Create one blank site name “test site”
      4. Create a folder in "test site"'s document library and name it “test site folder”
      5. Create shortcut in "test site folder" within “test site" and link to Global >>test global folder>>testGlobal.doc
      6. Delete site “test site”
      7. Now try to edit document in Global >> Document Library >> test global folder >> testGlobal.doc, click publish.
      8. It throws the error saying Document and Media is temporarily unavailable.

      I found some data(in assetentry table and dlfileshortcut) was not deleted after deleting the new site. I can see those unclean(orphaned) records by using the following SQL:
      1. unclean(orphaned) records in dlfileshortcut:
      select * from dlfileshortcut where groupId not in (select groupId from group_)
      2. unclean(orphaned) records in assetentry:
      select * from assetentry where groupId not in (select groupId from group_)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sharry.shi Sharry Shi
                Reporter:
                hai.yu Hai Yu
                Participants of an Issue:
                Recent user:
                Esther Sanz
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Days since last comment:
                  3 years, 30 weeks, 1 day ago