Wildcard search not working on Heroku

Question

I have the following method in my model:

 #find all the manufacturers names and ids or those matching a search string
  def self.find_all(manufacturer="")
       m_name =  manufacturer.gsub(" ", '%') if manufacturer
    find(:all, :select => 'id, name', :order => "name", :conditions => ["name like ?", "%#{m_name.capitalize}%"])
  end

This works perfectly on my local machine, but when I put it on Heroku it works less well: if I do a search and enter more than one word it won't return any values.

What is different about Heroku?

score 1 · Answer 1 · answered Sep 11 '11 at 11:23

1

Two thoughts. Firstly, try running it in production mode locally:

rails server -e production

Also it may be that your remote database is very different to your local one.

Make sure you have done

rake db:migrate

You could optionally also do

rake db:push

(see http://devcenter.heroku.com/articles/taps for more info)

answered Sep 11 '11 at 11:23

David

844
6
14

Thanks David for your answer. You are right. I was running MYSQL locally and its Postgres on HEROKU. – chell Sep 11 '11 at 14:11

score 1 · Accepted Answer · edited May 23 '17 at 11:55

1

i think it has something to do with the "Like" statement. mysql and heroku's postgresql sometime needs code modifications when switching between the two.

maybe try

"name ILIKE ?"

also checkout this answer here. Always best to use same database in development and production.

edited May 23 '17 at 11:55

Community

1
1

answered Sep 11 '11 at 11:33

Hishalv

3,052
3
29
52

I did not know about the ilike sql statement for postgresql. Once I used that it all worked. Thanks HIshalv – chell Sep 11 '11 at 14:10
@chell glad to help, i ran into a similar problem some time back. Also try checking out this page here – Hishalv Sep 11 '11 at 14:15

Wildcard search not working on Heroku

2 Answers2