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

Categories are assigned duplicative leftcategoryid and rightcategoryid values from preceding categories following removal of vocabularies

    Details

    • Branch Version/s:
      6.1.x, 6.0.x
    • Backported to Branch:
      Committed

      Description

      ISSUE
      In an environment where multiple vocabularies contain categories, deleting a vocabulary will cause the next vocabulary's categories to have duplicate leftcategoryid and rightcategoryids from preceding entries. Essentially, the categoryids are not rebuilt correctly upon deletion of a vocabulary.

      STEPS TO REPRODUCE
      1. Create vocabulary Vocab1
      2. Add categories Cat1, Cat2, Cat3, Cat4, and Cat5 to Vocab1
      3. Create vocabulary Vocab2
      4. Add categories CatA, CatB, CatC, CatD, and CatE to Vocab2
      5. Perform query SELECT * FROM assetcategory; (SEE IMAGE 1)
      6. Left and right category ids are in order (for all cases)
      7. Delete vocabulary Vocab1
      8. Query SELECT * FROM assetcategory; again (SEE IMAGE 2)

      EXPECTED RESULTS
      The categories' leftcategoryid and rightcategoryid will be rebuilt, and the categories will inherit values that take up the missing numbers left by the deletion in chronological order.

      ACTUAL RESULTS
      The categories' leftcategoryid and rightcategoryid duplicate as seen in IMAGE 2.

      Replicated the issue in TRUNK REV 127687 and BRANCH REV 127687.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

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

                  Subcomponents