ActionView :: Template :: Error（PG :: UndefinedFunction：错误：运算符不存在：整数~~未知 [英] ActionView::Template::Error (PG::UndefinedFunction: ERROR: operator does not exist: integer ~~ unknown

问题描述

我从MySQL切换到PostgreSQL以在Heroku中使用。现在，我的搜索将无法进行。无法确定操作员出了什么问题。 ActionView :: Template :: Error（PG :: UndefinedFunction：ERROR：运算符不存在：整数~~未知。

I switched from MySQL to PostgreSQL for use in Heroku. Now my search will not work. Can't figure out what is wrong with the operator. ActionView::Template::Error (PG::UndefinedFunction: ERROR: operator does not exist: integer ~~ unknown.

   2014-11-11T19:59:58.082607+00:00 app[web.1]: Processing by AllListingsController#search_listings as JS
    2014-11-11T19:59:58.105074+00:00 app[web.1]:     4: <% @listings.each do |listing| %>
    2014-11-11T19:59:58.102205+00:00 app[web.1]:                                                           ^
    2014-11-11T19:59:58.105066+00:00 app[web.1]: HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
    2014-11-11T19:59:58.105083+00:00 app[web.1]:   app/controllers/all_listings_controller.rb:14:in `search_listings'
    2014-11-11T19:59:58.110318+00:00 heroku[router]: at=info method=GET path="/search_listings?q=500&_=1415735994648" host=subleasy.herokuapp.com request_id=24a21078-d3fd-4bce-9afb-bfc9d976c0a7 fwd="50.247.32.153" dyno=web.1 connect=1ms service=35ms status=500 bytes=1754
    2014-11-11T19:59:58.103449+00:00 app[web.1]: Completed 500 Internal Server Error in 21ms
    2014-11-11T19:59:58.102207+00:00 app[web.1]: HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
    2014-11-11T19:59:58.105076+00:00 app[web.1]:     5:   $("div.search_list").append("<%= escape_javascript(render('all_listings/listings_partial', a_listing: listing )) %>")
    2014-11-11T19:59:58.105073+00:00 app[web.1]:     3:
    2014-11-11T19:59:58.103270+00:00 app[web.1]:   Rendered all_listings/search_listings.js.erb (5.1ms)
    2014-11-11T19:59:58.105071+00:00 app[web.1]:     2: $("div.search_list").html("")
    2014-11-11T19:59:58.105081+00:00 app[web.1]:   app/views/all_listings/search_listings.js.erb:4:in `_app_views_all_listings_search_listings_js_erb___729824412217144086_70218143810320'
    2014-11-11T19:59:58.102209+00:00 app[web.1]: : SELECT  "listings".* FROM "listings"  WHERE (rent LIKE '%500%' OR city LIKE '%500%' OR state LIKE '%500%' OR address LIKE '%500%')  ORDER BY rent asc LIMIT 5 OFFSET 0
    2014-11-11T19:59:58.105078+00:00 app[web.1]:     6: <% end %>
    2014-11-11T19:59:58.102199+00:00 app[web.1]: PG::UndefinedFunction: ERROR:  operator does not exist: integer ~~ unknown
    2014-11-11T19:59:58.105068+00:00 app[web.1]: : SELECT  "listings".* FROM "listings"  WHERE (rent LIKE '%500%' OR city LIKE '%500%' OR state LIKE '%500%' OR address LIKE '%500%')  ORDER BY rent asc LIMIT 5 OFFSET 0):
    2014-11-11T19:59:58.105084+00:00 app[web.1]:
    2014-11-11T19:59:58.082630+00:00 app[web.1]:   Parameters: {"q"=>"500", "_"=>"1415735994648"}
    2014-11-11T19:59:58.105058+00:00 app[web.1]:
    2014-11-11T19:59:58.105061+00:00 app[web.1]: ActionView::Template::Error (PG::UndefinedFunction: ERROR:  operator does not exist: integer ~~ unknown
    2014-11-11T19:59:58.105063+00:00 app[web.1]: LINE 1: SELECT  "listings".* FROM "listings"  WHERE (rent LIKE '%500...
    2014-11-11T19:59:58.105065+00:00 app[web.1]:                                                           ^
    2014-11-11T19:59:58.077155+00:00 app[web.1]: Started GET "/search_listings?q=500&_=1415735994648" for 50.247.32.153 at 2014-11-11 19:59:58 +0000
    2014-11-11T19:59:58.102203+00:00 app[web.1]: LINE 1: SELECT  "listings".* FROM "listings"  WHERE (rent LIKE '%500...
    2014-11-11T19:59:58.105070+00:00 app[web.1]:     1:
    2014-11-11T19:59:58.105085+00:00 app[web.1]:
    2014-11-11T19:59:58.105079+00:00 app[web.1]:     7: $(".hidetable").hide()

我的方法

def search_listings
    @listings = Listing.where("rent LIKE ? OR city LIKE ? OR state LIKE ? OR address LIKE ?", "%#{params[:q]}%", "%#{params[:q]}%", "%#{params[:q]}%", "%#{params[:q]}%").order(sort_column + " " + sort_direction).paginate(:per_page => 5, :page => params[:page])
    respond_to do |format|
      format.js
    end
end
def sort_column
      Listing.column_names.include?(params[:sort]) ? params[:sort] : "rent"
    end 
def sort_direction
    %w[asc desc].include?(params[:direction]) ? params[:direction] : "asc"
end

schema.rb

schema.rb

create_table "listings", force: true do |t|
    t.integer  "user_id"
    t.string   "address"
    t.string   "city"
    t.string   "state"
    t.date     "lease_start"
    t.string   "lease_length"
    t.string   "lease_type"
    t.integer  "rooms"
    t.text     "description"
    t.string   "email"
    t.string   "phone"
    t.integer  "rent"
    t.integer  "zipcode"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "photo_file_name"
    t.string   "photo_content_type"
    t.integer  "photo_file_size"
    t.datetime "photo_updated_at"
    t.float    "latitude",           limit: 24
    t.float    "longitude",          limit: 24
  end

当它在Mysql中完美运行时，为什么在postgreSQL中不起作用？

why won't this work in postgreSQL when it works flawlessly in Mysql???

推荐答案

似乎您正在尝试在 integer <上使用 Like 运算符列（即 rent ）。我不认为这行得通（至少在postgres中有效）。

It seems that you are trying to use a LIKE operator on an integer column (namely rent). I don't believe this will work (at least in postgres).

根据答案此处，您可能想要尝试添加强制转换：

According to the answers here you might want to try to add a cast:

@listings = Listing.where("cast(rent as text) LIKE ? OR city LIKE ? OR ...

这篇关于ActionView :: Template :: Error（PG :: UndefinedFunction：错误：运算符不存在：整数~~未知的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！