yes it appears in my searchd.query.log file whein i searchd it gave me this result
[Tue Oct 5 13:51:40.301 2010] 0.000 sec [scan/3/rel 0 (0,20)] [non_profit_core,non_profit_delta] [Tue Oct 5 13:51:46.358 2010] 0.000 sec [scan/2/rel 14 (0,20)] [non_profit_core,non_profit_delta] [Tue Oct 5 13:51:47.492 2010] 0.000 sec [scan/3/rel 0 (0,20)] [non_profit_core,non_profit_delta] On Oct 5, 12:57 pm, Pat Allan <[email protected]> wrote: > 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 > > ... > > read more » -- 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.
