ERROR: index 'game_core': sql_range_query: ERROR: date/time field
value out of range: "0"
LINE 1: ...rray_agg(COALESCE("release_dates"."release_date", '0')), '
'...
^
HINT: Perhaps you need a different "datestyle" setting.
ERROR: index 'game_delta': sql_range_query: ERROR: date/time field
value out of range: "0"
LINE 1: ...rray_agg(COALESCE("release_dates"."release_date", '0')), '
'...
^
HINT: Perhaps you need a different "datestyle" setting.
I get these to errors I use thinking sphinx and PostgreSQL.
Is this a PostgreSQL or a Sphinx error or both?
What can I do about it? I want to sort the games with release_date.
The release_date migration looks like this:
change_table :release_dates do |t|
t.date :release_date
end
And the index looks like this:
define_index do
indexes release_dates.release_date, as: :release_date, sortable:
true
end
Hope I have provided enough info, :)
--
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.
