Thank you pat,i am waiting for your reply On Jun 29, 12:08 pm, Pat Allan <[email protected]> wrote: > 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 > > 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.
