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 at http://groups.google.com/group/thinking-sphinx?hl=en.
