Sphinx Search

SphinxSearch WARNING: word overrun buffer, clipped!!!

Tagged: "search engine", chinese, CJK, index, phpbb, Sphinx Search, warning

It is a warning information when the cronjob running every night. This cronjob is used to update or re-index the phpBB powered forum, which is a Chinese forum. The whole error is a kind of a list of warning with same problem. How to solve the problem with the overrunContinue Reading

How to use Sphinx Search Engine on phpBB 3.1.6

In: L.A.M.P., phpBB Mod & Tips

Tagged: Centos, how-to, phpBB 3.1.x, Sphinx Search

This how-to is made on Centos6.7 64bit. It is a phpBB forum in Chinese with more than 680K posts. If I use phpBB native Fulltext or MySQL Fulltext search, the search tables are over 1.4GB. Too big. And it is very slow when do the search. Now, my solution isContinue Reading