When deleting and rebuilding the index (in that case native fulltext search), the "Total number of indexed words:" stays the same before and after. The "Total number of word to post relations indexed:" decreases.
Prior to deleting and rebuilding the index I was able to search (and find) a specific word and got all threads listed where the searchword was in the topic or in the text.
After deleting and rebuilding the index the search results only contained threads where the searchword was in the text.
Obviously rebuilding the index does index both topics and text, but the word to post relation index only contains references to word in the text.
Bug tracker
Search index not build correctly (not a bug)
Comments / History
Posted by naderman (Development Team Leader) on Dec 8th 2006, 21:46
As this uses the same function as indexing the post I can't quite believe that, can you maybe give a specific (as small as possible example for this behaviour) and link to your board?
Posted by naderman (Development Team Leader) on Dec 8th 2006, 23:03
Got a demo from the reporter, needs to be investigated.
Posted by naderman (Development Team Leader) on Dec 10th 2006, 17:48
Can you update to the latest CVS version and try it again? I'm not 100% sure I really fixed it.
Posted by michael.b on Dec 11th 2006, 09:49
Fetched CVS shortly after midnight, updated files and manually updated database schema.
Before update: 5364 / 14606
Installed
Deleted and recreated index: 5364 / 14606
Posted two posts in one topic: 5369 / 14644
Deleted and recreated index: 5369 / 14630
So at all: seems not ok, sorry.
Before update: 5364 / 14606
Installed
Deleted and recreated index: 5364 / 14606
Posted two posts in one topic: 5369 / 14644
Deleted and recreated index: 5369 / 14630
So at all: seems not ok, sorry.
Posted by NeverPleat on Dec 17th 2006, 13:34
Before update: 19 / 20
Installed
Deleted and recreated index: 19 / 20
Posted two posts in one topic: 21 / 26
Deleted and recreated index: 19 / 20
Installed
Deleted and recreated index: 19 / 20
Posted two posts in one topic: 21 / 26
Deleted and recreated index: 19 / 20
Posted by naderman (Development Team Leader) on Dec 17th 2006, 14:31
NeverPleat: as that looks like smaller numbers which are easier to test with, can you give me the exact contents of your posts, including the ones you created when testing this? Would probably help a lot 
Posted by Acyd Burn (Server Manager) on Dec 27th 2006, 18:09
I am experiencing some problems too - i wanted to test the above and noticed that if i delete the index it sometimes works, sometimes not, sometimes it tries to continue deleting but already said it is completed. The same for creating the index, sometimes it works, sometimes it is trying to continue the index creating, then the second value is doubled. This could be related to the popup code i implemented previously...
Posted by michael.b on Dec 29th 2006, 10:23
With the latest CVS and the common words threshold (thanks! 
) set to 0 the problem is not reproducable any more.
) set to 0 the problem is not reproducable any more.