define_index do
where "searchable = true"
indexes only_admin, :as => :only_admin
indexes first_name, middle_name, last_name
indexes preferences.name, :as => :preferences_name
indexes preferences.value, :as => :preferences_value
indexes current_contact.location.country.name, :as
=> :current_country, :facet => true
indexes current_contact.location.state.name, :as
=> :current_state, :facet => true
indexes current_contact.location.city.name, :as
=> :current_city, :facet => true
set_property :delta => :delayed
end
I have other models which i am indexing . all of them have search-able
column in their table.
Will that create a problem here ?
I still having the mysql error .
Mysql is taking 100% memory when i do rake ts:rebuild
also when i save the user model from console.
it eats up the /tmp memory and the system shows warning and ask for
disk cleanup
i am really worried about this behavior.
On Jan 21, 4:54 am, Pat Allan <[email protected]> wrote:
> What does your index definition look like for your user model?
>
> And I'm guessing you got the other issue (for MySQL) fixed, since it's no
> longer happening when you're indexing?
>
> --
> Pat
>
> On 20/01/2011, at 10:42 PM, Z@M wrote:
>
> > indexing index 'users_core'...
> > ERROR: index 'users_core': sql_range_query: Column 'searchable' in
> > where clause is ambiguous (DSN=mysql://root:***@localhost:3306/
> > myname).
>
> > cant i use the searchable keyword . is it reserved ?
>
> > --
> > 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.
