Ok, I'll try updating and see if that helps.
On Oct 8, 2:29 am, Wolf <[EMAIL PROTECTED]> wrote:
> You need to update TS.
>
> "sql_query_range = SELECT MIN(`id` * 3 + 0), MAX(`id` * 3 + 0)" is an
> outdated and wrong statement.
>
> regards,
> Wolf
>
> On 7 Okt., 22:54, Steve Eichert <[EMAIL PROTECTED]> wrote:
>
> > It returns all the records when I strip off the id range portion of
> > the query. I don't see anything out of the ordinary in the SQL. Any
> > ideas for further investigation?
>
> > sql_query_pre = SET NAMES utf8
>
> > sql_query_pre =
> > sql_query = SELECT `territories`.`id` * 3 + 2 AS `id` ,
> > CAST(`territories`.`name` AS CHAR) AS `name`,
> > CAST(`territories`.`number` AS CHAR) AS `number`, `territories`.`id`
> > AS `sphinx_internal_id`, 1803926469 AS `class_crc`, '1803926469' AS
> > `subclass_crcs`, 0 AS `sphinx_deleted` FROM territories WHERE
> > `territories`.`id` * 3 + 2 >= $start AND `territories`.`id` * 3 + 2
> > <= $end GROUP BY `territories`.`id` ORDER BY NULL
> > sql_query_range = SELECT MIN(`id` * 3 + 0), MAX(`id` * 3 + 0) FROM
> > `territories`
> > sql_query_info = SELECT * FROM `territories` WHERE `id` = (($id -
> > 2) / 3)
> > sql_attr_uint = sphinx_internal_id
> > sql_attr_uint = class_crc
> > sql_attr_uint = subclass_crcs
> > sql_attr_uint = sphinx_deleted
>
> > }
>
> > index territory_core
> > {
> > source = territory_0_core
> > path = /path/to/territory_core
> > charset_type = utf-8
> > morphology = stem_en
> > enable_star = 1
> > min_prefix_len = 1}
>
> > index territory
> > {
> > type = distributed
> > local = territory_core
> > charset_type = utf-8
>
> > }
>
> > On Sep 18, 2:49 am, Pat Allan <[EMAIL PROTECTED]> wrote:
>
> > > Yeah, looking at the sql_query for the source in question is where I'd
> > > start. If you strip off the id range part of the WHERE clause, how
> > > many records does it return?
>
> > > Cheers
>
> > > --
> > > Pat
>
> > > On 18/09/2008, at 10:17 AM, Blake Watters wrote:
>
> > > > Try examining the SQL generated in your sphinx.conf file for the
> > > > index in question. It may have insight.
>
> > > > On Wed, Sep 17, 2008 at 5:03 PM, Steve Eichert <[EMAIL PROTECTED]
> > > > > wrote:
>
> > > > When running rake ts:in ThinkingSphinx is excluding a row form the
> > > > index that is created. I have 68 rows in the database and when
> > > > indexing it says "collected 67 docs". My index doesn't have any
> > > > filters:
>
> > > > class Territory < ActiveRecord::Base
> > > > #...
>
> > > > define_index do
> > > > indexes :name, number
> > > > end
>
> > > > #...
> > > > end
>
> > > > What would cause TS to exclude a row from the index it creates? From
> > > > evaluating the data in the table there doesn't appear to be anything
> > > > unique to the excluded row. Below is the migration for the table that
> > > > is having a row excluded.
>
> > > > create_table :territories do |t|
> > > > t.integer :study_id, :null => false
> > > > t.string :name, :null => false
> > > > t.string :number, :null => false
> > > > t.string :region_name, :null => false
> > > > t.string :region_number, :null => false
> > > > t.string :district_name, :null => false
> > > > t.string :district_number, :null => false
>
> > > > t.timestamps
> > > > end
>
> > > > Any ideas?
>
> > > > Thanks,
> > > > Steve
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
