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-30909 Categories have wrong leftCategoryId/rightCategoryId values when removing categories with children 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 LPS-21304 Categories Navigation: Categories work wierdly when Categories are also created in global scope LPS-24826 Duplicated id causes troubles in "viewable by" setting of categories
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.