find_by_email dynamic method returning new

rubyonrails-talk
1

Hello everyone,

I have a rails app which uses email as login name. At some point, I have to search the user, in the User model by email. For some reason, the method User.find_by_email(email) returns nil, even though the user is in the database.

The same applies for any find_by_* method that searches by any database column. I was able to find the user using the User.find

Does anyone have an idea of what might be going on?

thanks, -fred

2

Is this ruby 1.9?

Maybe … this is related to string encoding of the columns ?

Check the string encoding of the string by which you are searching and the one that is used in the database.

Please show exact code samples for how you used User.find (with

succesful result) and User.find_by_email (without result).

For this scenario of encoding issues, please show the email.encoding

on the result from from the find

=> User.first.email.encoding

HTH,

Peter

3

Hi Fred,

I was having the same issue. I finally resolved it by defining the find_by_email method in my app/models/user.rb file...

Example: