执行以下，
CREATE TABLE IF NOT EXISTS sphinxc (
id int(11) NOT NULL,
weight int(11) NOT NULL,
query varchar(255) NOT NULL,
INDEX(query)
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION=’sphinx://localhost:3312/yicike_search_ctitle’;
错误如下：
sphinx: 1st column (docid) MUST be unsigned integer or bigint’ (errno: -1)
解决如下：
CREATE TABLE IF NOT EXISTS sphinxc (
id int(10) unsigned not null,
weight int(11) NOT NULL,
query varchar(255) NOT NULL,
INDEX(query)
) ENGINE=SPHINX DEFAULT CHARSET=utf8 CONNECTION=’sphinx://localhost:3312/yicike_search_ctitle’;
原创文章，转载请注明： 转载自亿赐客比较购物搜索网
本文链接地址: 解决错误sphinx: 1st column (docid) MUST be unsigned integer or bigint’ (errno: -1)