Hi Arun I did get your email - just haven't had time to look into it yet. Hopefully in the next 24 hours.
-- Pat On 29/06/2010, at 3:59 PM, Arun wrote: > Hi Pat, > Do you got my email about this issue,i have waiting for your > suggestion . > > Thanks for your previous suggestions > > On Jun 28, 5:40 pm, Pat Allan <[email protected]> wrote: >> Okay, this is a really confusing issue then... Is it possible for you to >> email me (not the list) your Rails app? I'd like to try and reproduce the >> issue on my machine... >> >> -- >> Pat >> >> On 28/06/2010, at 10:34 PM, Arun wrote: >> >> >> >>> Hi Pat, >>> I am working in the localhost,i need to work on cache ,so i used the >>> demo env in the development mode,even database and everything same. >> >>> On Jun 28, 5:04 pm, Pat Allan <[email protected]> wrote: >>>> Ah, wait... the issue isn't that the column isn't there, it's that the >>>> JOINs aren't there... your Rails app code is the same on both dev and demo >>>> machines, yes? >> >>>> -- >>>> Pat >> >>>> On 28/06/2010, at 9:54 PM, Pat Allan wrote: >> >>>>> Is your demo environment on the same machine? Or a different machine? If >>>>> it's a different machine, what version of Thinking Sphinx do you have >>>>> installed on the demo server? >> >>>>> And on the demo server, can you run 'script/dbconsole -p', and then the >>>>> following SQL statement: >> >>>>> SELECT DISTINCT name FROM countries; >> >>>>> Does it work? >> >>>>> -- >>>>> Pat >> >>>>> On 28/06/2010, at 9:44 PM, Arun wrote: >> >>>>>> Hi Pat, >> >>>>>> I have run all the migration in the demo environment >>>>>> Development: >>>>>> See CAST(`countries`.`name` AS CHAR) AS `country_name` >>>>>> so it is not throwing any error in development env >>>>>> Demo: >> >>>>>> See CAST(`profiles`.`name` AS CHAR) AS `country_name` >>>>>> The same define_index is generating this in demo env.And this is what >>>>>> make TS throw sq >>>>>> l_query_range error . >> >>>>>> Even though demo and Development have same configuration >>>>>> demo: >>>>>> # enable_star: false >>>>>> # min_infix_len: 0 >>>>>> # min_prefix_len: 0 >>>>>> sql_range_step: 10000000 >>>>>> mem_limit: 128M >>>>>> max_matches: 10000 >>>>>> allow_star: false >>>>>> bin_path: /usr/local/bin >>>>>> searchd_binary_name: searchd >>>>>> indexer_binary_name: indexer >> >>>>>> development: >>>>>> # enable_star: false >>>>>> # min_infix_len: 0 >>>>>> # min_prefix_len: 0 >>>>>> sql_range_step: 10000000 >>>>>> allow_star: false >>>>>> max_matches: 10000 >>>>>> Any suggestions , >> >>>>>> On Jun 28, 4:21 pm, Pat Allan <[email protected]> wrote: >>>>>>> Have you run all your migrations in your demo environment? I think this >>>>>>> query generation bug can happen when columns don't exist in the >>>>>>> association tables... >> >>>>>>> -- >>>>>>> Pat >> >>>>>>> On 28/06/2010, at 3:50 PM, Arun wrote: >> >>>>>>>> Hi Pat, >> >>>>>>>> i made a mistake so do not consider whatever posted above. >> >>>>>>>> Here is detailed version of this error: >> >>>>>>>> Here is my define_index method looks like: >> >>>>>>>> define_index do >>>>>>>> indexes :preferred_name >>>>>>>> indexes self.user.address.country.name, :as => :country_name >>>>>>>> end >> >>>>>>>> See this doesn't trow any error when I rebuild TS in development env >> >>>>>>>> The value for sql_query in development.sphinx.conf looks like: >>>>>>>> SELECT SQL_NO_CACHE `profiles`.`id` * 1 + 0 AS `id` , >>>>>>>> CAST(`profiles`.`preferred_name` AS CHAR) AS `preferred_name`, >>>>>>>> CAST(`countries`.`name` AS CHAR) AS `country_name`, `profiles`.`id` AS >>>>>>>> `sphinx_internal_id`, 1323996051 AS `class_crc`, '1323996051' AS >>>>>>>> `subclass_crcs`, 0 AS `sphinx_deleted` FROM `profiles` LEFT OUTER >>>>>>>> JOIN `users` ON `users`.id = `profiles`.user_id LEFT OUTER JOIN >>>>>>>> `addresses` ON `addresses`.id = `users`.address_id LEFT OUTER JOIN >>>>>>>> `countries` ON `countries`.id = `addresses`.country_id WHERE >>>>>>>> `profiles`.`id` >= $start AND `profiles`.`id` <= $end GROUP BY >>>>>>>> `profiles`.`id` ORDER BY NULL >> >>>>>>>> See CAST(`countries`.`name` AS CHAR) AS `country_name` >>>>>>>> so it is not trowing any error in development env >> >>>>>>>> But While rebuilding TS in demo env gives me following error >>>>>>>> ERROR: index 'profile_core': sql_range_query: Unknown column >>>>>>>> 'profiles.name' >> >>>>>>>> Here is sql_query value in demo.sphinx.conf looks like: >> >>>>>>>> SELECT SQL_NO_CACHE `profiles`.`id` * 1 + 0 AS `id` , >>>>>>>> CAST(`profiles`.`preferred_name` AS CHAR) AS `preferred_name`, >>>>>>>> CAST(`profiles`.`name` AS CHAR) AS `country_name`, `profiles`.`id` AS >>>>>>>> `sphinx_internal_id`, 1323996051 AS `class_crc`, '1323996051' AS >>>>>>>> `subclass_crcs`, 0 AS `sphinx_deleted` FROM `profiles` WHERE >>>>>>>> `profiles`.`id` >= $start AND `profiles`.`id` <= $end GROUP BY >>>>>>>> `profiles`.`id` ORDER BY NULL >> >>>>>>>> See CAST(`profiles`.`name` AS CHAR) AS `country_name` >>>>>>>> The same define_index is generating this in demo env.And this is what >>>>>>>> make TS throw sq >>>>>>>> l_query_range error >> >>>>>>>> Any help would be greatly appreciated. >> >>>>>>>> Thanks in advance. >> >>>>>>>> On Jun 26, 11:12 am, Pat Allan <[email protected]> wrote: >>>>>>>>> Hi Arun >> >>>>>>>>> In your config/development.sphinx.conf file, you'll find the >>>>>>>>> profile_core_0 source - what's the sql_query value in that source? >> >>>>>>>>> -- >>>>>>>>> Pat >> >>>>>>>>> On 26/06/2010, at 3:38 PM, Arun wrote: >> >>>>>>>>>> Hi, >>>>>>>>>> I want retrieve the company name in the profile model but due to >>>>>>>>>> relationship ,it is not get indexed. >> >>>>>>>>>> I am using the Profile model for indexes >>>>>>>>>> 1.In the profile model >>>>>>>>>> belongs_to :user >>>>>>>>>> 2. In the user model >>>>>>>>>> belongs_to :address, :dependent => :destroy >>>>>>>>>> 3. In the address model >>>>>>>>>> belongs_to :country >>>>>>>>>> so i given the indexes like this >>>>>>>>>> indexes user.address.country.name but it is throwing error like this >>>>>>>>>> "indexing index 'profile_core'... >>>>>>>>>> ERROR: index 'profile_core': sql_range_query: Unknown column >>>>>>>>>> 'profiles.name' in 'field list' (DSN=mysql://root:*...@localhost:" >> >>>>>>>>>> -- >>>>>>>>>> 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 >>>>>> 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 >>> 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.
