When I remove the faceted fields, the indexing job runs just fine. But I kinda wanna get those working.
On Nov 5, 11:40 am, crazy_matt <[email protected]> wrote: > Obviously. That is why I'm confused about this error. The TS-generated > SQL looks like this: > > sql_query = SELECT "books"."id" * 2 + 0 AS "id" , "books"."title" AS > "title", "books"."subtitle" AS "subtitle", "books"."keywords" AS > "keywords", "books"."pub_year" AS "pub_year", "books"."id" AS > "sphinx_internal_id", 1809255439 AS "class_crc", 0 AS > "sphinx_deleted", COALESCE("books"."title", '') AS "title_sort", > COALESCE("books"."audience_type", '') AS "audience_type", > crc32("books"."audience_type") AS "audience_type_facet", > COALESCE("books"."author_type", '') AS "author_type", > crc32("books"."author_type") AS "author_type_facet", > COALESCE("books"."format", '') AS "format", crc32("books"."format") AS > "format_facet" FROM "books" WHERE ("books"."id" >= $start > AND "books"."id" <= $end) GROUP BY "books"."id", "books"."title", > "books"."subtitle", "books"."keywords", "books"."pub_year", > "books"."id", "books"."title", "books"."audience_type", > "books"."audience_type", "books"."author_type", "books"."author_type", > "books"."format", "books"."format" > > On Nov 5, 11:17 am, Luciano Sousa <[email protected]> wrote: > > > tables are not indexed with id = 0 > > > 2010/11/5 crazy_matt <[email protected]> > > > > I keep getting the following error when I index: > > > > ERROR: index 'book_core': sql_range_query: ERROR: index 0 out of > > > valid range, 0..-1 > > > CONTEXT: PL/pgSQL function "crc32" line 10 at assignment > > > > The only information I could find about the index out of range error > > > was for IDs that were enormous. I'm at a loss. Any ideas what may be > > > causing this? > > > > Matt > > > > -- > > > 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]<thinking-sphinx%[email protected]> > > > . > > > For more options, visit this group at > > >http://groups.google.com/group/thinking-sphinx?hl=en. > > > -- > > att: Luciano Sousahttp://www.lucianosousa.net > > <http://www.lucianosousa.net>http://twitter.com/lucianosousa > > *Ruby on Rails Developer > > *Linux User #456387 > > *Contato: (21) 7639-5049 > > -- 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.
