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
    • Similar Issues:
      Show 5 results 

      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_)

        Issue Links

          Activity

          Hide
          Sharry Shi added a comment -

          PASSED Manual Testing following the steps in the description.

          Reproduced on:
          Tomcat 7.0.27 + MySQL 5.5.21 Portal 6.1.30 EE GA3.

          The related data in assetentry table and dlfileshortcut table still exist after the site is deleted.

          Fixed on:
          Tomcat 7.0.40 + MySQL 5.5.21 Portal 6.1.x.EE GIT ID: eae2b9417961f70c55d0e391f239c1b18ee85c55.

          The related data in assetentry table and dlfileshortcut table are cleared after the site is deleted.

          Show
          Sharry Shi added a comment - PASSED Manual Testing following the steps in the description. Reproduced on: Tomcat 7.0.27 + MySQL 5.5.21 Portal 6.1.30 EE GA3. The related data in assetentry table and dlfileshortcut table still exist after the site is deleted. Fixed on: Tomcat 7.0.40 + MySQL 5.5.21 Portal 6.1.x.EE GIT ID: eae2b9417961f70c55d0e391f239c1b18ee85c55. The related data in assetentry table and dlfileshortcut table are cleared after the site is deleted.

            People

            • Assignee:
              Sharry Shi
              Reporter:
              Hai Yu
              Recent user:
              Gabor Kovacs
              Participants of an Issue:
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                1 year, 35 weeks, 6 days ago

                Development

                  Subcomponents

                    Structure Helper Panel