配置 mysql/mariadb sphinxSE 错误解决 1st column must be bigint to accept 64-bit DOCID

作者:凨

配置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
 


上一篇:医疗保健领域的云计算解决方案


下一篇:跨域请求出现preflight request失败的问题的解决