When you run a search on NonProfit, does it appear in the searchd.query.log
file? Your config file below looks fine.
--
Pat
On 04/10/2010, at 11:16 PM, thunderz14enator wrote:
> 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.
>
--
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.
