Don't miss out Virtual Happy Hour this Friday (April 26).
Try our conversational search powered by Generative AI!
AI OnAI Off
netKeywordSave proc
Vote:
I have a web site with all pages existing in two languages, but searching is only possible in one of them. I have traced this down to the netKeywordSave stored proc, which seems to delete all indexed keywords for previously processed language branches, before adding keywords for the current language branch. Is this an error, or am I missing something? (I have not experienced this problem with multilanguage pages in 4.61)
Thomas Andreassen
Sep 24, 2007 13:43
Hi Thomas!
I know that there were some bugfixes in this area pretty near the release. Are you running on a release or rc version on your site?
#16358
Sep 27, 2007 12:11
Hi Thomas
I have tried to reproduce this problem, but I was unable to do so. I also checked the netKeyWordSave's history and it has not been changed since 4.61.
Is the word gone for the language that is not working in tblKeyWord?
#16360
Sep 28, 2007 14:41
Yes, the entries are still in tblKeyword. I have been testing this a little now, and it seems to me that this statement in netKeywordSave causes the problems:
#16361
DELETE FROM tblPageKeyword
FROM tblPageKeyword
JOIN tblKeyword ON tblKeyword.pkID=tblPageKeyword.fkKeywordID
WHERE fkPageID=@PageID
AND EXISTS( SELECT * FROM tblTempKeyword WHERE fkPageID=@PageID AND tblTempKeyword.fkLanguageBranchID=tblKeyword.fkLanguageBranchID)
After this statement has been run, all entries from the tblPageKeyword table is deleted for the page being processed.
If I change the EXISTS clause to SELECT * FROM tblTempKeyword WHERE PageID=@PageID AND tblTempKeyword.fkLanguageBranchID=tblKeyword.fkLanguageBranchID, then only the rows for current page and languagebranch is deleted from tblPageKeyword. I can't say if this has any undesired side effects though. I tested this on an MS SQL Server 9.0.1406.
Thomas Andreassen
Oct 01, 2007 12:29
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
