Skip to main content
Search by subject Started by badmonkey · · Read 2351 times 0 Members and 1 Guest are viewing this topic. previous topic - next topic

Search by subject

A member on my large board pointed out searching by subject isn't working properly.  Using a search term, which should be a common term on the board, only returns two results total.  Manually navigating comes up with more matches on the first couple of pages. 

Search settings are to use a Fulltext Index.  The index exists, according to the ACP.  Where is a logical starting point?  Thanks!

Re: Search by subject

Reply #1

I might be off in the woods on this one, but I think fulltext actually only creates an index on the message body column so the search by subject using that index might be kind of BS

Do you have the option "force the use of a search index" checked, if so try un checking that and see if it helps,

Re: Search by subject

Reply #2

Thanks spuds.  Tried unchecking as suggested.  The results were the same.  It's interesting it comes up with exactly two results, the same ones every time.  What else should I try?

Re: Search by subject

Reply #3

Try not using fulltext search?
Bugs creator.
Features destroyer.
Template killer.

Re: Search by subject

Reply #4

Should have mentioned it, but sure did.   ;)

Re: Search by subject

Reply #5

Did a very quick look at the code and we only create the fulltext on the body col not on the subject col.

I don't know the reason for this, could have been a limitation of fulltext on some older versions of mysql, but one could create a second fulltext on the subject, or even (I think) a combination index based of both.   If that is correct then we have some work to do  to make improvements.

So all that said, I'd feel you should use the custom search index (that should work) and drop the fulltext until we get this sorted.


Re: Search by subject

Reply #6

Cool!  Thanks Spuds!  :)