unknown type 'mysql'; skipping_思考sphinx未知类型'mysql'; 跳绳

我使用的是ts版本2.0.5,rails 3.0.9和mysql2 0.2.11

当尝试使用rake ts:index创建索引时,出现以下错误:

ERROR: source 'technical_core_0': unknown type 'mysql'; skipping.

我的development.sphinx.conf包含:

source technical_core_0

{

type = mysql

sql_host = localhost

sql_user = root

sql_pass =

sql_db = ps_development

sql_sock = /tmp/mysql.sock

sql_query_pre = SET NAMES utf8

sql_query_pre = SET TIME_ZONE = '+0:00'

sql_query = SELECT SQL_NO_CACHE `technicals`.`id` * CAST(1 AS SIGNED) + 0 AS `id` , `orders`.`name` AS `author`, `technicals`.`id` AS `sphinx_internal_id`, 0 AS `sphinx_deleted`, 488243725 AS `class_crc`, IFNULL(`orders`.`name`, '') AS `author_sort`, `technicals`.`order_id` AS `order_id`, UNIX_TIMESTAMP(`technicals`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`technicals`.`updated_at`) AS `updated_at` FROM `technicals` LEFT OUTER JOIN `orders` ON `orders`.`id` = `technicals`.`order_id` WHERE (`technicals`.`id` >= $start AND `technicals`.`id` <= $end) GROUP BY `technicals`.`id`, , `orders`.`name`, `technicals`.`id`, `orders`.`name`, `technicals`.`order_id`, `technicals`.`created_at`, `technicals`.`updated_at` ORDER BY NULL

sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `technicals`

sql_attr_uint = sphinx_internal_id

sql_attr_uint = sphinx_deleted

sql_attr_uint = class_crc

sql_attr_uint = order_id

sql_attr_timestamp = created_at

sql_attr_timestamp = updated_at

sql_attr_str2ordinal = author_sort

sql_query_info = SELECT * FROM `technicals` WHERE `id` = (($id - 0) / 1)

}

这有点奇怪,因为我的database.yml文件包含mysql2和root密码.

你能帮助我度过这个阶段吗?我还尝试使用以下命令创建sphinx.yml文件:

development:

adapter: mysql2

但这也失败了.

- 更新 -

我将其添加到开发初始化文件中:

ThinkingSphinx.database_adapter = :mysql2

这给出了仅支持MySQL的错误.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值