Okay, I've fixed this. Give 1.4.0 (Rails 1 & 2) or 2.0.0 (Rails 3) a try.
-- Pat On 09/11/2010, at 6:48 AM, Pat Allan wrote: > Right. Well, given the crc function is something I wrote, I better fix that! > > I'm surprised it's not come up before, to be honest. > > -- > Pat > > On 09/11/2010, at 9:46 AM, crazy_matt wrote: > >> They both throw the same error. I tried all NULLs and all empties. >> >> On Nov 8, 3:28 pm, Pat Allan <[email protected]> wrote: >>> Hmm, what happens if you change all the empty strings to NULLs? It's a bug >>> either way, for sure, but I just want to check as to which scenario we're >>> having the problem with. >>> >>> -- >>> Pat >>> >>> On 09/11/2010, at 4:23 AM, crazy_matt wrote: >>> >>>> I thought of that over the weekend and gave it a try. I converted all >>>> NULL values in one of those columns to empty strings, added the column >>>> back into my index and go that same error: "sql_range_query: ERROR: >>>> index 0 out of valid range, 0..-1 CONTEXT: PL/pgSQL function "crc32" >>>> line 10 at assignment" >>> >>>> However, when I filled them with an arbitrary, non-empty string value >>>> the indexing succeeded. So the CRC is failing on NULL values but also >>>> on empty strings in Postgres. >>> >>>> I suppose I can think of some default value for those rows, but I'd >>>> love to have the CRC function not fail on NULL values. If I felt >>>> qualified to tackle that I would give it a try, but I'm definitely a >>>> noob when it comes to sphinx. >>> >>>> On Nov 5, 4:15 pm, Pat Allan <[email protected]> wrote: >>>>> Hi Matt >>> >>>>> What are the values in the columns you want to facet? Is there anything >>>>> particularly odd? I'm wondering if NULL values are failing in CRC >>>>> conversion... if there are NULL values in audience_type, author_type or >>>>> format, perhaps try changing them to blank strings? >>> >>>>> Cheers >>> >>>>> -- >>>>> Pat >>> >>>>> On 06/11/2010, at 5:19 AM, crazy_matt wrote: >>> >>>>>> Interesting. I have no IDs with a value of 0. As I mentioned, when I >>>>>> remove the three columns I was trying to facet on, the indexing >>>>>> succeeded. It has something to do with the CRCs for the facted >>>>>> columns. >>> >>>>>> On Nov 5, 12:13 pm, Luciano Sousa <[email protected]> wrote: >>>>>>> if you have some id 0 in your table, the sphinx can not index it, so you >>>>>>> will not have the sphinx functioning properly. I believe this is your >>>>>>> problem. >>>>>>> I had a similar problem and removed all the values id = 0 in my >>>>>>> database. >>> >>>>>>> 2010/11/5 crazy_matt <[email protected]> >>> >>>>>>>> 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]> >>>>>>>> <thinking-sphinx%[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]<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 >>>>>> 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. >> > > -- > 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. > -- 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.
