Page search index showing deleted pages too
Permalink
Hey there! I have a problem, with page search indexing. I am not using the built-in search block, I written my own code to get data from the pagesearchindex table - ofcourse through the standard C5 interfaces, with some low level adodb stuff. My problem is, that my page search index table contains entries to pages, that have been deleted. I tried clearing the cache and rerunning the page indexing job, I tried deleting the problematic rows by hand, from the table, clearing the cache and rerunning page index, and all possible permutations of these activities without luck. So, anyone got any idea where to now? Could I simply just delete everything from the page index search table? I don't know if it would help though, because I already tried deleteing the unwanted entries, and they reappear even though the pages do not exist anymore... I also checked in the collections table, thinking that maybe some trash was left there, which is picked up, but there weren't any false entries there.
or delete them under the trash page, try that first :)
Hey, thanks for the answer, and sorry for replying so late. It turned out, that MySQL workbench does NOT delete any rows when I simply say delete rows... I have to explicitly 'activate' the changes I made. This confusion caused the pain in my ass. :/
the exclude any pages from your search index that have a cParentID of this page.
That make sense?