My development.sphinx.conf looks like this
indexer
{
mem_limit = 128M
}
searchd
{
listen = 127.0.0.1:9312
log = /home/pc15/Projects/vivendosdevelopment/log/searchd.log
query_log = /home/pc15/Projects/vivendosdevelopment/log/
searchd.query.log
pid_file = /home/pc15/Projects/vivendosdevelopment/log/
searchd.development.pid
}
source donate_core_0
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = vivendos_development
sql_query_pre = UPDATE `donates` SET `delta` = 0 WHERE `delta` = 1
sql_query_pre = SET NAMES utf8
sql_query_pre = SET TIME_ZONE = '+0:00'
sql_query = SELECT SQL_NO_CACHE `donates`.`id` * 2 + 0 AS `id` ,
`donates`.`title` AS `title`, `donates`.`zip` AS `zip`,
`donates`.`description` AS `description`, `events`.`name` AS `name`,
`non_profits`.`nonprofit_name` AS `nonprofit_name`, `donates`.`id` AS
`sphinx_internal_id`, 3658350919 AS `class_crc`, 0 AS
`sphinx_deleted`, `donates`.`county_id` AS `county_id`,
`donates`.`category_id` AS `category_id`, `donates`.`non_profit_id` AS
`non_profit_id`, `donates`.`event_id` AS `event_id` FROM
`donates` LEFT OUTER JOIN `events` ON `events`.`id` =
`donates`.`event_id` LEFT OUTER JOIN `non_profits` ON
`non_profits`.`id` = `donates`.`non_profit_id` WHERE
(`donates`.`id` >= $start AND `donates`.`id` <= $end AND
`donates`.`delta` = 0) GROUP BY `donates`.`id` ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
FROM `donates` WHERE `donates`.`delta` = 0
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = county_id
sql_attr_uint = category_id
sql_attr_uint = non_profit_id
sql_attr_uint = event_id
sql_query_info = SELECT * FROM `donates` WHERE `id` = (($id - 0) /
2)
}
index donate_core
{
source = donate_core_0
path = /home/pc15/Projects/vivendosdevelopment/db/sphinx/development/
donate_core
charset_type = utf-8
min_infix_len = 3
enable_star = 1
}
source donate_delta_0 : donate_core_0
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = vivendos_development
sql_query_pre =
sql_query_pre = SET NAMES utf8
sql_query_pre = SET TIME_ZONE = '+0:00'
sql_query = SELECT SQL_NO_CACHE `donates`.`id` * 2 + 0 AS `id` ,
`donates`.`title` AS `title`, `donates`.`zip` AS `zip`,
`donates`.`description` AS `description`, `events`.`name` AS `name`,
`non_profits`.`nonprofit_name` AS `nonprofit_name`, `donates`.`id` AS
`sphinx_internal_id`, 3658350919 AS `class_crc`, 0 AS
`sphinx_deleted`, `donates`.`county_id` AS `county_id`,
`donates`.`category_id` AS `category_id`, `donates`.`non_profit_id` AS
`non_profit_id`, `donates`.`event_id` AS `event_id` FROM
`donates` LEFT OUTER JOIN `events` ON `events`.`id` =
`donates`.`event_id` LEFT OUTER JOIN `non_profits` ON
`non_profits`.`id` = `donates`.`non_profit_id` WHERE
(`donates`.`id` >= $start AND `donates`.`id` <= $end AND
`donates`.`delta` = 1) GROUP BY `donates`.`id` ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
FROM `donates` WHERE `donates`.`delta` = 1
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = county_id
sql_attr_uint = category_id
sql_attr_uint = non_profit_id
sql_attr_uint = event_id
sql_query_info = SELECT * FROM `donates` WHERE `id` = (($id - 0) /
2)
}
index donate_delta : donate_core
{
source = donate_delta_0
path = /home/pc15/Projects/vivendosdevelopment/db/sphinx/development/
donate_delta
}
index donate
{
type = distributed
local = donate_delta
local = donate_core
}
source non_profit_core_0
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = vivendos_development
sql_query_pre = UPDATE `non_profits` SET `delta` = 0 WHERE `delta` =
1
sql_query_pre = SET NAMES utf8
sql_query_pre = SET TIME_ZONE = '+0:00'
sql_query = SELECT SQL_NO_CACHE `non_profits`.`id` * 2 + 1 AS
`id` , `non_profits`.`nonprofit_name` AS `nonprofit_name`,
`non_profits`.`city` AS `city`, `non_profits`.`id` AS
`sphinx_internal_id`, 1641007040 AS `class_crc`, 0 AS
`sphinx_deleted`, `non_profits`.`county_id` AS `county_id` FROM
`non_profits` WHERE (`non_profits`.`id` >= $start AND
`non_profits`.`id` <= $end AND `non_profits`.`delta` = 0) GROUP BY
`non_profits`.`id` ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
FROM `non_profits` WHERE `non_profits`.`delta` = 0
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = county_id
sql_query_info = SELECT * FROM `non_profits` WHERE `id` = (($id -
1) / 2)
}
index non_profit_core
{
source = non_profit_core_0
path = /home/pc15/Projects/vivendosdevelopment/db/sphinx/development/
non_profit_core
charset_type = utf-8
min_prefix_len = 1
min_infix_len = 3
enable_star = 1
}
source non_profit_delta_0 : non_profit_core_0
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass =
sql_db = vivendos_development
sql_query_pre =
sql_query_pre = SET NAMES utf8
sql_query_pre = SET TIME_ZONE = '+0:00'
sql_query = SELECT SQL_NO_CACHE `non_profits`.`id` * 2 + 1 AS
`id` , `non_profits`.`nonprofit_name` AS `nonprofit_name`,
`non_profits`.`city` AS `city`, `non_profits`.`id` AS
`sphinx_internal_id`, 1641007040 AS `class_crc`, 0 AS
`sphinx_deleted`, `non_profits`.`county_id` AS `county_id` FROM
`non_profits` WHERE (`non_profits`.`id` >= $start AND
`non_profits`.`id` <= $end AND `non_profits`.`delta` = 1) GROUP BY
`non_profits`.`id` ORDER BY NULL
sql_query_range = SELECT IFNULL(MIN(`id`), 1), IFNULL(MAX(`id`), 1)
FROM `non_profits` WHERE `non_profits`.`delta` = 1
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = county_id
sql_query_info = SELECT * FROM `non_profits` WHERE `id` = (($id -
1) / 2)
}
index non_profit_delta : non_profit_core
{
source = non_profit_delta_0
path = /home/pc15/Projects/vivendosdevelopment/db/sphinx/development/
non_profit_delta
}
index non_profit
{
type = distributed
local = non_profit_delta
local = non_profit_core
}
On Oct 4, 4:00 pm, Pat Allan <[email protected]> wrote:
> What does the source definition for your NonProfit model look like in
> development.sphinx.conf? Make sure you remove your database password.
>
> --
> Pat
>
> On 04/10/2010, at 4:41 PM, thunderz14enator wrote:
>
> > location(params[:locations]) returns the value of the checkbox which
> > is an ID of the data
>
> > I did rake ts:stop and rebuld the sphinx also
> > and one thing that i ran this command in my rails console also
>
> > irb(main):004:0> @nonprofits = NonProfit.search "",:with =>
> > {:county_id => 2}
> > => []
> > irb(main):005:0>
>
> > though i have the fields related to county id in my database
>
> > ----
>
> > On Oct 1, 7:11 pm, Pat Allan <[email protected]> wrote:
> >> Can you give us an example of what location(params[:locations]) returns?
>
> >> Also, can you run ts:stop, and then confirm there are no other searchd
> >> instances running, and then run ts:rebuild? Sometimes nil results are
> >> obtained because there's a different Sphinx instance running that's
> >> looking at other index files, hence the mismatch.
>
> >> Cheers
>
> >> --
> >> Pat
>
> >> On 01/10/2010, at 6:42 PM, thunderz14enator wrote:
>
> >>> Hi,
>
> >>> I have a secnario where i m searching the result on the basis of
> >>> checkbox,when i check the particual check box it passes an id called
> >>> as "county_id", no i have county_id in my database and when i m trying
> >>> to search the data according to "county_id", its gives me a nil
> >>> result ,though i have data with that particular county id ..
>
> >>> the steps i follwoed are
>
> >>> 1 created a filed in my table naming county id.
>
> >>> 2 in my model i added these lines
>
> >>> define_index do
> >>> indexes nonprofit_name
> >>> indexes city
> >>> has county_id
> >>> # has city
> >>> set_property :delta => true
> >>> set_property :enable_star => true
> >>> set_property :min_prefix_len => 1
> >>> end
>
> >>> 3 in my controller
>
> >>> def nonprofit_sort
> >>> if !params[:locations].blank? && !params[:search].blank?
> >>> �...@nonprofits = NonProfit.search params[:search],:with =>
> >>> {:county_id=> location(params[:locations])},:star => true
>
> >>> elsif !params[:locations].blank?
>
> >>> �...@nonprofits = NonProfit.search params[:search],:with =>
> >>> {:county_id => location(params[:locations])},:star => truep "finished
> >>> search"
> >>> elsif !params[:search].blank?
>
> >>> �...@nonprofits = NonProfit.search params[:search],:star => true
> >>> else
> >>> �...@nonprofits= NonProfit.search params[:search],:star => true
> >>> end
> >>> end
>
> >>> 4. Rebuilded the index
>
> >>> I m totally clueless about getting the nill result
>
> >>> --
> >>> You received this message because you are subscribed to the Google Groups
> >>> "Thinking Sphinx" group.
> >>> To post to this group, send email to [email protected].
> >>> To unsubscribe from this group, send email to
> >>> [email protected].
> >>> For more options, visit this group
> >>> athttp://groups.google.com/group/thinking-sphinx?hl=en.
>
> > --
> > You received this message because you are subscribed to the Google Groups
> > "Thinking Sphinx" group.
> > To post to this group, send email to [email protected].
> > To unsubscribe from this group, send email to
> > [email protected].
> > For more options, visit this group
> > athttp://groups.google.com/group/thinking-sphinx?hl=en.
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
