oh god I though it was SQL instead is going into Shpinx's query. Thanks a lot
On Mar 3, 12:30 pm, Pat Allan <[email protected]> wrote: > It's because of the first line in your index action: > > > conditions = (current_user && current_user.is_power? ? {} : {:show > > => true}) > > If a user is logged in and has power, then it adds :show => true to the > conditions. Perhaps you want to remove that line? > > -- > Pat > > On 03/03/2011, at 10:24 PM, rtacconi wrote: > > > Hi, > > > I have this code (developed by someone else: > > > def index > > conditions = (current_user && current_user.is_power? ? {} : {:show > > => true}) > > if params[:search] > > conditions = conditions.merge({:home_climate_zones => > > params[:climate_zone]}) if params[:climate_zone].present? > > @users = User.search(params[:search] || "", :conditions => > > conditions ) > > @users = @users.select {|u| u.has_user_type?(params[:type])} if > > params[:type].present? > > @total = @users.size > > @users = @users.sort_by {|e| [e.posts.last.try(:created_at) || > > 10.years.ago] }.reverse > > @users = @users.paginate(:per_page => 9, :page => params[:page] > > || 1) > > else > > @users = User.paginate(:conditions => conditions, :per_page => > > 9, :page => params[:page], :include => :posts, :order => > > "posts.created_at DESC, users.created_at DESC") # Not you! > > @total = User.count > > end > > @featured = User.featured > > @map_users = User.with_lat_lng.all(:select => 'id, lat, > > lng', :include => :posts, :order => "posts.created_at DESC") > > end > > > The output of the rebuild: > > > indexing index 'project_core'... > > collected 234 docs, 0.9 MB > > sorted 0.1 Mhits, 100.0% done > > total 234 docs, 870847 bytes > > total 0.454 sec, 1917016 bytes/sec, 515.10 docs/sec > > indexing index 'project_delta'... > > collected 0 docs, 0.0 MB > > total 0 docs, 0 bytes > > total 0.011 sec, 0 bytes/sec, 0.00 docs/sec > > distributed index 'project' can not be directly indexed; skipping. > > indexing index 'user_core'... > > collected 722 docs, 0.0 MB > > sorted 0.0 Mhits, 100.0% done > > total 722 docs, 26907 bytes > > total 0.036 sec, 727570 bytes/sec, 19523.01 docs/sec > > distributed index 'user' can not be directly indexed; skipping. > > total 10 reads, 0.002 sec, 50.8 kb/call avg, 0.2 msec/call avg > > total 21 writes, 0.001 sec, 55.9 kb/call avg, 0.0 msec/call avg > > Started successfully (pid 3304). > > > I want to mention the show is a user field but it is a reserved word > > in Mysql. I have been thinking to rename it, but I still do not > > understand why Shinx is 'interested' in the show field. > > > On Mar 3, 12:19 pm, Pat Allan <[email protected]> wrote: > >> What is your search query? And what's the output when you run ts:rebuild? > > >> -- > >> Pat > > >> On 03/03/2011, at 10:08 PM, rtacconi wrote: > > >>> I the Usr model I have the following index > > >>> define_index do > >>> indexes first_name, :sortable => true > >>> indexes last_name, :sortable => true > >>> indexes city > >>> indexes state > >>> indexes country > >>> # indexes aid_work > >>> # indexes consultant > >>> # indexes home_climate_zones > >>> # indexes pdc_teacher > >>> # has show > > >>> set_property :delta => true > > >>> # indexes posts.created_at, :as => :posts > >>> end > > >>> I am getting this error: > > >>> index user_core,user_delta: query error: no field 'show' found in > >>> schema > > >>> I rebuild the index but still getting that error. Any idea why? > > >>> -- > >>> 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.
