Affects Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2
Environment:LIFERAY VERSION: 6.0 SP 1
APPLICATION SERVER: Tomcat 6.x
JAVA VIRTUAL MACHINE: Java 6
DATABASE: MySQL 5.1
Branch Version/s:6.1.x, 6.0.x
Backported to Branch:Committed
Similar Issues:Show 5 results
LPS-44898 Categories are assigned duplicative leftcategoryid and rightcategoryid values from preceding categories following removal of vocabularies LPS-30909 Categories have wrong leftCategoryId/rightCategoryId values when removing categories with children LPS-44676 Removing vocabulary causes categories to have duplicate left/right categoryIds LPS-30926 Deleting categories sometimes have wrong leftCategoryId/rightCategoryId values LPS-21928 Parent category needs to be cleared from Hibernate Session Cache(first level cache) during categories hierarchy building
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)
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.
The categories' leftcategoryid and rightcategoryid duplicate as seen in IMAGE 2.
Replicated the issue in TRUNK REV 127687 and BRANCH REV 127687.