作者:凨
配置mysql/mariadb sphinxSE 时出现如下错误:
[Err] 1430 - There was a problem processing the query on the foreign data source. Data source error: INTERNAL ERROR: 1st column must be bigint to accept 64-bit DOCID
解决方法:
sphinxse搜索表中的 documents_sphinxse 主键ID字段类型改为 bigint 类型即可解决.
如还不能解决,
把sphinx重新编译一下,编译参数加上 --enable-id64
本人安装环境:
ubuntu 14.04 + php5.5.12 +mariadb10.0.12+nginx + sphinx-for-chinese-2.2.1