netKeywordSave proc

Thomas Andreassen

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

#15785

Sep 24, 2007 13:43

Linus Ekström

Vote:

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

Thomas Andreassen

Vote:

I am running the release version. Thomas Andreassen

#16359

Sep 27, 2007 14:32

Christina Norberg

Vote:

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

Thomas Andreassen

Vote:

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:


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

#16361

Oct 01, 2007 12:29