I'm new to rails, so I'm doing everything in a standard way. All models points to the same database, and I have only one connection. All table are in the same database, but I have diferents schema path. The models work nicely, and everything is going ok. I would like to add sphinx + thinking to improve search response etc.
So the Dishes and categories tables are in the same schema, and works normally. Any clue? :-) ---- Jorge On 29 nov, 03:41, Pat Allan <[email protected]> wrote: > No, it's not your fault, it's Google's. > > Looks like the table's there. Are you doing anything particularly > different with database connections? Are all the models in the same > database? Are the connection details in the dish source the same as > those in the category source? > > -- > Pat > > On 29/11/2009, at 1:24 PM, scriptbox wrote: > > > > > Thank you again for your help; > > > The answer is: > > >>> Dish.connection.select_all('SELECT COALESCE(MIN("id"), 1::bigint), > > COALESCE(MAX("id"), 1::bigint) FROM "dishes"') > > => [{"coalesce"=>"10337"}] > > > (I'm sorry but I don't know if it is my mistake if the mail is > > missing, but I'm new to google groups) > > > -- > > Jorge > > > On 29 nov, 03:19, Pat Allan <[email protected]> wrote: > >> Doesn't look like Thinking Sphinx is doing anything odd... > > >> Can you try the following in script/console? > >> Dish.connection.select_all('SELECT COALESCE(MIN("id"), 1::bigint), > >> COALESCE(MAX("id"), 1::bigint) FROM "dishes"') > > >> (And your email was missing again from google's moderation queue, but > >> I've now flagged your account as not needing moderation, so hopefully > >> that'll fix that problem). > > >> -- > >> Pat > > >> On 29/11/2009, at 1:09 PM, scriptbox wrote: > > >>> Hi Pat Alan; > > >>> First of all, thank you very much for helping me. I just don't know > >>> what to do. > > >>> I checked the content for this file, and the user, pass, host, db > >>> seems nice, but there is no schema. Here is the content for > >>> dish_core_0: > > >>> source dish_core_0 > >>> { > >>> type = pgsql > >>> sql_host = localhost > >>> sql_user = ********** > >>> sql_pass = > >>> sql_db = amv > >>> sql_query = SELECT "dishes"."id" * 3 + 1 AS "id" , "dishes"."label" > >>> AS "label", "dishes"."id" AS "sphinx_internal_id", 894378886 AS > >>> "class_crc", '894378886' AS "subclass_crcs", 0 AS "sphinx_deleted" > >>> FROM "dishes" WHERE "dishes"."id" >= $start AND "dishes"."id" <= > >>> $end GROUP BY "dishes"."id", "dishes"."label", "dishes"."id" > >>> sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE > >>> (MAX > >>> ("id"), 1::bigint) FROM "dishes" > >>> sql_attr_uint = sphinx_internal_id > >>> sql_attr_uint = class_crc > >>> sql_attr_uint = sphinx_deleted > >>> sql_attr_multi = uint subclass_crcs from field > >>> sql_query_info = SELECT * FROM "dishes" WHERE "id" = (($id - 1) / > >>> 3) > >>> } > > >>> On 29 nov, 03:01, Pat Allan <[email protected]> wrote: > >>>> Hi Jorge > > >>>> This is a new issue, but let's start with the generated config > >>>> file, > >>>> config/development.sphinx.conf. What's the sql_query value for your > >>>> dish_core_0 source? > > >>>> -- > >>>> Pat > > >>>> On 29/11/2009, at 11:06 AM, Pat Allan wrote: > > >>>>> (Was in the moderation queue according to my email, but not > >>>>> Google's > >>>>> site. Have forwarded this on. Originally from scriptbox/ > >>>>> [email protected] > >>>>> ) > > >>>>> Hello, > > >>>>> For three days I'm facing a very weird problem. I have a script > >>>>> that > >>>>> works fine, so I started using Thinking Sphinx to improve > >>>>> performance. > >>>>> So I installed and added two indexes, as following: > > >>>>> class Category < ActiveRecord::Base > > >>>>> # relation entre les tables > >>>>> belongs_to :macrocategory > > >>>>> define_index do > >>>>> indexes terms > >>>>> end > > >>>>> end > > >>>>> class Dish < ActiveRecord::Base > > >>>>> # Rélation entre les tables > >>>>> belongs_to :partner > >>>>> has_one :decomposition > >>>>> has_many :dish_combos > > >>>>> define_index do > >>>>> indexes label > >>>>> end > > >>>>> # Named Scopes > >>>>> named_scope :get_distinct_macrocategories, :select => 'DISTINCT ON > >>>>> (combo_macrocategory) combo_macrocategory' > >>>>> named_scope :not_decomposed_dishes, :select => 'id, > >>>>> label', :conditions => ['combo_categories IS NULL'] > >>>>> end > > >>>>> The problem is that everytime I launch the indexing action with > >>>>> rake > >>>>> thinking_sphinx:index the first model table is indexed, but not > >>>>> the > >>>>> second one. And I got the following output: > > >>>>> Generating Configuration to /Users/jorgegomes/Sites/amv/config/ > >>>>> development.sphinx.conf > >>>>> Sphinx 0.9.9-rc2 (r1785) > >>>>> Copyright (c) 2001-2009, Andrew Aksyonoff > > >>>>> using config file '/Users/jorgegomes/Sites/amv/config/ > >>>>> development.sphinx.conf'... > >>>>> indexing index 'category_core'... > >>>>> collected 151 docs, 0.0 MB > >>>>> collected 0 attr values > >>>>> sorted 0.0 Mvalues, 100.0% done > >>>>> sorted 0.0 Mhits, 100.0% done > >>>>> total 151 docs, 13516 bytes > >>>>> total 0.015 sec, 894862 bytes/sec, 9997.35 docs/sec > >>>>> distributed index 'category' can not be directly indexed; > >>>>> skipping. > >>>>> indexing index 'dish_core'... > >>>>> ERROR: index 'dish_core': sql_query_range: : range-query failed: > >>>>> ERROR: relation "dishes" does not exist > >>>>> (DSN=pgsql://gomesjorge:*...@localhost:5432/amv). > >>>>> total 0 docs, 0 bytes > >>>>> total 0.061 sec, 0 bytes/sec, 0.00 docs/sec > >>>>> distributed index 'dish' can not be directly indexed; skipping. > >>>>> indexing index 'macrocategory_core'... > >>>>> collected 23 docs, 0.0 MB > >>>>> collected 0 attr values > >>>>> sorted 0.0 Mvalues, 100.0% done > >>>>> sorted 0.0 Mhits, 100.0% done > >>>>> total 23 docs, 443 bytes > >>>>> total 0.012 sec, 35318 bytes/sec, 1833.69 docs/sec > >>>>> distributed index 'macrocategory' can not be directly indexed; > >>>>> skipping. > >>>>> total 10 reads, 0.000 sec, 13.8 kb/call avg, 0.0 msec/call avg > >>>>> total 18 writes, 0.000 sec, 2.3 kb/call avg, 0.0 msec/call avg > > >>>>> But the table exists and the model works fine, can you help please > >>>>> I'm > >>>>> really stucked in this problem. > > >>>>> Thank you very much! > > >>>>> -- > > >>>>> 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.
