Skip to content
Fetching contributors…
Cannot retrieve contributors at this time
129 lines (118 sloc) 5.98 KB
indexer
{
}
searchd
{
listen = 127.0.0.1:3312
log = /Users/Digidave/spot-us/log/searchd.log
query_log = /Users/Digidave/spot-us/log/searchd.query.log
pid_file = /Users/Digidave/spot-us/log/searchd.development.pid
}
source news_item_core_0
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = spotus_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 `news_items`.`id` * 3 + 0 AS `id` , `news_items`.`headline` AS `headline`, `news_items`.`slug` AS `slug`, `news_items`.`excerpt` AS `excerpt`, `news_items`.`short_description` AS `short_description`, `news_items`.`extended_description` AS `extended_description`, `news_items`.`status` AS `status`, `news_items`.`id` AS `sphinx_internal_id`, CASE IFNULL(`news_items`.`type`, '') WHEN 'Story' THEN 714550076 WHEN 'Pitch' THEN 3864957405 WHEN 'Tip' THEN 1892613804 ELSE 3062079150 END AS `class_crc`, 0 AS `sphinx_deleted`, IFNULL(`news_items`.`headline`, '') AS `headline_sort`, IFNULL(`news_items`.`slug`, '') AS `slug_sort`, IFNULL(`news_items`.`excerpt`, '') AS `excerpt_sort`, IFNULL(`news_items`.`short_description`, '') AS `short_description_sort`, IFNULL(`news_items`.`extended_description`, '') AS `extended_description_sort`, IFNULL(`news_items`.`status`, '') AS `status_sort`, `news_items`.`user_id` AS `user_id`, UNIX_TIMESTAMP(`news_items`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`news_items`.`updated_at`) AS `updated_at` FROM `news_items` WHERE `news_items`.`id` >= $start AND `news_items`.`id` <= $end GROUP BY `news_items`.`id`, `news_items`.`type` ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `news_items`
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = user_id
sql_attr_timestamp = created_at
sql_attr_timestamp = updated_at
sql_attr_str2ordinal = headline_sort
sql_attr_str2ordinal = slug_sort
sql_attr_str2ordinal = excerpt_sort
sql_attr_str2ordinal = short_description_sort
sql_attr_str2ordinal = extended_description_sort
sql_attr_str2ordinal = status_sort
sql_query_info = SELECT * FROM `news_items` WHERE `id` = (($id - 0) / 3)
}
index news_item_core
{
source = news_item_core_0
path = /Users/Digidave/spot-us/db/sphinx/development/news_item_core
charset_type = utf-8
charset_table = 0..9, a..z, _, @, A..Z->a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
}
index news_item
{
type = distributed
local = news_item_core
}
source post_core_0
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = spotus_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 `posts`.`id` * 3 + 1 AS `id` , `posts`.`title` AS `title`, `posts`.`body` AS `body`, `posts`.`id` AS `sphinx_internal_id`, 4206412723 AS `class_crc`, 0 AS `sphinx_deleted`, IFNULL(`posts`.`title`, '') AS `title_sort`, IFNULL(`posts`.`body`, '') AS `body_sort`, `posts`.`user_id` AS `user_id`, UNIX_TIMESTAMP(`posts`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`posts`.`updated_at`) AS `updated_at` FROM `posts` WHERE `posts`.`id` >= $start AND `posts`.`id` <= $end GROUP BY `posts`.`id` ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `posts`
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = user_id
sql_attr_timestamp = created_at
sql_attr_timestamp = updated_at
sql_attr_str2ordinal = title_sort
sql_attr_str2ordinal = body_sort
sql_query_info = SELECT * FROM `posts` WHERE `id` = (($id - 1) / 3)
}
index post_core
{
source = post_core_0
path = /Users/Digidave/spot-us/db/sphinx/development/post_core
charset_type = utf-8
charset_table = 0..9, a..z, _, @, A..Z->a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
}
index post
{
type = distributed
local = post_core
}
source user_core_0
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = spotus_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 `users`.`id` * 3 + 2 AS `id` , `users`.`about_you` AS `about_you`, `users`.`first_name` AS `first_name`, `users`.`last_name` AS `last_name`, `users`.`organization_name` AS `organization_name`, `users`.`email` AS `email`, `users`.`id` AS `sphinx_internal_id`, CASE IFNULL(`users`.`type`, '') WHEN 'Reporter' THEN 2409661092 WHEN 'Admin' THEN 1238311538 WHEN 'Sponsor' THEN 1311895624 WHEN 'Organization' THEN 3655317636 WHEN 'Citizen' THEN 1726885557 ELSE 765557111 END AS `class_crc`, 0 AS `sphinx_deleted`, IFNULL(`users`.`about_you`, '') AS `about_you_sort`, IFNULL(`users`.`first_name`, '') AS `first_name_sort`, IFNULL(`users`.`last_name`, '') AS `last_name_sort`, IFNULL(`users`.`organization_name`, '') AS `organization_name_sort`, IFNULL(`users`.`email`, '') AS `email_sort`, UNIX_TIMESTAMP(`users`.`created_at`) AS `created_at`, UNIX_TIMESTAMP(`users`.`updated_at`) AS `updated_at` FROM `users` WHERE `users`.`id` >= $start AND `users`.`id` <= $end GROUP BY `users`.`id`, `users`.`type` ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1) FROM `users`
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_timestamp = created_at
sql_attr_timestamp = updated_at
sql_attr_str2ordinal = about_you_sort
sql_attr_str2ordinal = first_name_sort
sql_attr_str2ordinal = last_name_sort
sql_attr_str2ordinal = organization_name_sort
sql_attr_str2ordinal = email_sort
sql_query_info = SELECT * FROM `users` WHERE `id` = (($id - 2) / 3)
}
index user_core
{
source = user_core_0
path = /Users/Digidave/spot-us/db/sphinx/development/user_core
charset_type = utf-8
charset_table = 0..9, a..z, _, @, A..Z->a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
}
index user
{
type = distributed
local = user_core
}
Something went wrong with that request. Please try again.