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

版权声明:原创文章欢迎转载,不过要记得加出处哦 https://blog.csdn.net/wljk506/article/details/38084901

作者:凨

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


阅读更多

扫码向博主提问

风.foxwho

非学,无以致疑;非问,无以广识
  • 擅长领域:
  • php
  • java
  • go
  • 架构
  • more
去开通我的Chat快问
换一批

没有更多推荐了,返回首页