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
-~----------~----~----~----~------~----~------~--~---
