How does one search this forum?
I'm new here, but I could see clearly there was a thread about "RENAME COLUMN", but when I type that text into the "Search Forum" field, it got no matches.
So, how do I search the forum? Pardon me if this is an idiotic question.
You are probably doing it correctly. That particular posting does not appear to have been indexed at all so no matter what you try and search for from that particular post, you will never find it.
Note that the Natural Sort thread does not appear to be indexed either as none of the messages in that thread can be located by search.
The FTS engine currently indexes the post bodies only, not the subject. This was previously reported a few weeks ago.
(5.1) By Keith Medcalf (kmedcalf) on 2020-04-04 03:16:56 edited from 5.0 in reply to 4 [link] [source]
And what exactly does your comment have to do with the fact that NONE of the postings in the mentioned threads ARE INDEXED AT ALL?
Pick a word, any word, from the CONTENT (BODY) of one of those threads and put it in the search box AND IT WILL NOT BE FOUND. NADA. NOTHING. ZILCH. DICK.
Well, now they appear to be in the index however at the time I complained that they were not in the index, they were not in the index.
Note that a search for rename column now finds something.
How does one "kick off" the index process when cron is busted?
As of today, searching seems to be working much better. I don't know what changed or who changed it, but thank you!
There is a bug in the search logic for Forum posts that I am still trying to track down. New posts are not being added to the FTS index, for some reason. I have to manually rebuild the index in order to get new posts to show up in search. I have added additional debugging logic to Fossil to help track down the problem. Hopefully I will be able to find and fix it soon.
In the meantime maybe it would be a good idea to rebuils the index periodically in a cron job?
I think I fixed the search index bug on 2020-04-05. Are you still having trouble? What search string is not working for you?