Re: Forum search kaput?
- Posted by jimcbrown (admin) Nov 23, 2010
- 1463 views
My sql full text search does not index words shorter than four letters. You would have to recompile my sql to fix this, which wouldnt be doable anyway if eu forum ever moved back to shared hosting. You could use LIKE assuming its not hideously slow (probably would be on a forum this big), recompile my sql (which would mean never being able to use shared hosting), create your own indexing system (php scripts exist already to do this), or simply make the forum search refuse short words.
This turns out to be incorrect. From Jeremy: http://dev.mysql.com/doc/refman/5.1/en/fulltext-fine-tuning.html
Lowering this value to index even 1-char words turns out to be a config option in /etc/mysql/my.cnf followed by restarting mysqld
Then, manually reindex each table (REPAIR TABLE table_name QUICK) and it's done.
So, this has now been fixed.
