The issue: in some cases, when an editor removes a category from the list of categories on a page, this page still shows up in faceted search (EPiServer Find) on that same category, as if it was not removed after all. When exploring the index, we can see that the category id is part of the page's list, but in the editor ui it's not there anymore.
When we explore the database we find the following entries for the page in tblContentCategory:
pkID
fkContentID
fkCategoryID
CategoryType
fkLanguageBranchID
ScopeName
1690
4006
2
0
1
0
1691
4006
3
0
1
0
1692
4006
4
0
1
0
1693
4006
5
0
1
0
1694
4006
8
0
1
0
1695
4006
11
0
1
0
1696
4006
12
0
1
0
2500
4006
2
0
15
0
2501
4006
3
0
15
0
2502
4006
4
0
15
0
2503
4006
5
0
15
0
2504
4006
11
0
15
0
2505
4006
12
0
15
0
2506
4006
13
0
15
0
2507
4006
25
0
15
0
The page id is 4006. LanguageBranchID 1 is en and 15 is nb (norsk bokmål). The category we removed from the page was id = 8. We later tried to add two more categories to the page - 13 and 25. As you can see, category 8 still exists in english. The two new categories exists in norwegian. The weird part is that the page only exist in norwegian and nevertheless; the category property is not culture specific. The categories presented in the edit ui are the ones with fkLanguageBranchID = 15 (norwegian). If I make an english translation of the page, I am still only presented with these "norwegian" categories in the edit ui. The categories presented in the Find index seems to be all distinct categories for the page in this table regardless of fkLanguageBranchID.
Has anyone else had this or a similar problem? I can't see any solution to the problem right now other than to manually delete the entries with fkLanguageBranchID = 1 from the this table.
The issue: in some cases, when an editor removes a category from the list of categories on a page, this page still shows up in faceted search (EPiServer Find) on that same category, as if it was not removed after all. When exploring the index, we can see that the category id is part of the page's list, but in the editor ui it's not there anymore.
When we explore the database we find the following entries for the page in tblContentCategory:
The page id is 4006. LanguageBranchID 1 is en and 15 is nb (norsk bokmål). The category we removed from the page was id = 8. We later tried to add two more categories to the page - 13 and 25. As you can see, category 8 still exists in english. The two new categories exists in norwegian. The weird part is that the page only exist in norwegian and nevertheless; the category property is not culture specific. The categories presented in the edit ui are the ones with fkLanguageBranchID = 15 (norwegian). If I make an english translation of the page, I am still only presented with these "norwegian" categories in the edit ui. The categories presented in the Find index seems to be all distinct categories for the page in this table regardless of fkLanguageBranchID.
Has anyone else had this or a similar problem? I can't see any solution to the problem right now other than to manually delete the entries with fkLanguageBranchID = 1 from the this table.