Rails Validates_uniqueness of scope not working

Question

My validations raise an "Email already taken" error on the create method.

I have this validation in my Customer model:

validates :email, :uniqueness => {:scope => :account_id, :case_sensitive => false}

and this is what I'm seeing in my logs:

Customer Load (0.4ms)  SELECT `customers`.* FROM `customers` WHERE `customers`.`account_id` = 2 AND `customers`.`email` = 'xxxxx@gmail.com' LIMIT 1
(0.1ms)  BEGIN
Customer Exists (0.8ms)  SELECT 1 AS one FROM `customers` WHERE `customers`.`email` = BINARY 'xxxxx@gmail.com' LIMIT 1
Customer Exists (0.3ms)  SELECT 1 AS one FROM `customers` WHERE (`customers`.`email` = 'xxxxx@gmail.com' AND `customers`.`account_id` = 2) LIMIT 1
(0.2ms)  ROLLBACK

Thanks for the help.

it looks like you try to use same account_id = 2, isn't it? – gayavat Jul 10 '12 at 08:11 — gayavat, Jul 10 '12 at 08:11

score 0 · Answer 1 · answered Jul 11 '12 at 06:24

Your scope is narrowing the email search to a given account_id (= 2). Not sure if this is your intended behavior, but you should remove the scope if you want it to search other account ids as well.

The validations are failing because the email you've entered is already taken. Thus, they are doing exactly what you've told them to do...

Rails Validates_uniqueness of scope not working

1 Answers1