Hi, I have 4 models to index, 3 of them work fine but 1 keeps hanging when building the indexes. Ive trawled the forums and read solutions for similar issues but these don't seem to work for me.
The problem table which hangs the indexing is called Category and has the appropriate id key field etc so should in essence work so i am a bit stumped on that one. I have read about the issue with the large id's and this does apply to my tables. All 4 tables id's are pretty big for example 1900639709 is an id field for one of the models called product. This table seems to index ok but the category model who's id starts at 1600578709 just hangs. In the config file i see the id * 4 which is probably causing the issue. Basically what can i do to fix this. Below is the output distributed index 'host_application' can not be directly indexed; skipping. indexing index 'manufacturer_core'... ERROR: index 'manufacturer_core': sql_range_query: ERROR: integer out of range (DSN=pgsql://postgres:*...@localhost:2810/av3_live). total 0 docs, 0 bytes total 0.010 sec, 0.00 bytes/sec, 0.00 docs/sec distributed index 'manufacturer' can not be directly indexed; skipping. indexing index 'product_core'... ERROR: index 'product_core': sql_range_query: ERROR: integer out of range (DSN=pgsql://postgres:*...@localhost:2810/av3_live). total 0 docs, 0 bytes total 0.014 sec, 0.00 bytes/sec, 0.00 docs/sec distributed index 'product' can not be directly indexed; skipping. Loaded suite /opt/local/bin/rake Started thanks JB -- 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.
