A rails 3.2.18 application is being created, migrating data from a rails 2.3.10 application. Data is being ported over via pg_dump and loaded via psql command, without any errors.
One model of the 13 that are indexed via thinking_sphinx is getting some errors. Only 1 in 8.5 docs is being indexed overall.
indexing index 'norm_core'...
ERROR: index 'norm_core': sql_range_query: ERROR: integer out of range
(DSN=pgsql://jerdvo:***@localhost:5432/fna_development).
total 1019 docs, 234688 bytes
The index file is
ThinkingSphinx::Index.define :norm, :with => :active_record do
indexes data
indexes titolo
indexes massima
indexes numero
indexes norm_fulltext
indexes region.name, :as => :region
indexes normtype.name, :as => :normtype
has region_id
has normtype_id
has data, :as => :data_timestamp
end
I'm unsure about the syntax of the last element with data_timestamp
, as it could be legacy syntax... It applies to a date field - from schema:
t.date "data"
Other models have the same indexing scenario on a date. But none have generated the error.
[assuming that line has to change, should one first doe rake ts:configure
before index or rebuild?]