配置 mysql/mariadb sphinxSE 错误解决 1st column must be bigint to accept 64-bit DOCID
来源：互联网 发布：专业海报制作软件 编辑：程序博客网 时间：2024/05/05 18:33
作者：凨
配置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
0 0
- 配置 mysql/mariadb sphinxSE 错误解决 1st column must be bigint to accept 64-bit DOCID
- change column to bigint
- sphinxse mysql 5.6编译错误
- 解决Service Intent must be explicit错误
- ora-01440:column to be modified must be empty to decrease precision or scale
- ORA-01439: column to be modified must be empty to change datatype
- mysql bigint to int
- matlab中的svm配置详解及y must be avector or a character array.错误解决！！！
- Use JsonReader.setLenient(true) to accept malformed JSON at line 1 column 1 path可能解决方式
- su: must be suid to work properly错误
- su: must be suid to work properly错误
- CDLinux su: must be suid to work properly错误
- 报错解决Argument 1 passed to model::get***() must be an instance of Entity_hotel, instance
- cantos 7 解决libgcc_s.so.1 must be installed for pthread_cancel to work
- ORA-01758: table must be empty to add mandatory (NOT NULL) column
- must be an instance of com.sun错误的解决
- An SDK Target must be specified.错误解决
- This attribute must be localized.错误解决方式
- Google C++ style guide——格式
- Android开发实用技巧：Drawable和Bitmap之间的转换
- OGG-COLMAP-列映射
- RFID学些（五）防冲突
- SM$TS
- 配置 mysql/mariadb sphinxSE 错误解决 1st column must be bigint to accept 64-bit DOCID
- nutch-1.7-学习笔记（2）-org.apache.nutch.crawl.Generator.java-关于Hadoop的partition
- 最新做项目用到的一些js整理
- C#按字节截取字符串的扩展方法
- 灰度变换与空间滤波-学习提纲
- ioctlsocket函数说明
- HDU 1372 Knight Moves【BFS】
- 安装R语言在Linux环境
- Shadow of the Eternals' crowdfunding Buy ESO Gold
