search

isohuntto / openbay

Other
3.52k stars 902 forks source link

Getting error "Server sent charset unknown to the client." #86

Closed no1453 closed 9 years ago

no1453 commented 9 years ago

This is related to the issue https://github.com/isohuntto/openbay/issues/2 , but I wasn't sure if developers would still be checking that.

I enabled debug info, and with "(MY_DOMAIN)/src/www/search?q=farm" got CDbException

CDbConnection failed to open the DB connection: SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers

I got this even though my sphinx.conf reads in part... index opb_common { source = opbtorrents path = /var/lib/sphinxsearch/data/opb_common docinfo = extern charset_type = utf-8 charset_table = 0..9, A..Z->a..z, a..z, U+410..U+42F->U+430..U+44F, U+430..U +44F

The sphinx database is remotely acessible, indexing is working fine, but the openbay code reports that error.

EDIT: tried compiling sphinxsearch 2.2.6 to replace my distro's 2.0.4 release, but the new one doesn't respond to "service" commands (so I'm having trouble starting it), they must have changed something.

no1453 commented 9 years ago

Finally got sphinxsearch 2.2.6 working, and now the search is actually producing results (:D). I had to go into /src/protected/config and edit config.php, removing the line "charset = utf-8". I assume this change was necessary because of the updated sphinxsearch.