Hey , No need for sorry actually i resolved it .the problem was with the indexing it was not refreshing properly , that was my silly mistake.
On Oct 16, 11:33 am, Pat Allan <[email protected]> wrote: > Sorry, I'm really stuck on both of your issues... > > I guess let's take a step back, and compare Sphinx to SQL queries: > > NonProfit.search_count(:with => {:county_id => 2}) > NonProfit.count(:condititions => {:county_id => 2}) > > What are the values returned by both lines of code? > > -- > Pat > > On 05/10/2010, at 7:24 PM, thunderz14enator wrote: > > > 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 > > ... > > 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.
