CakePHP isUnique doesn't work

Question

I prepare some registration form (the simplest) and in my Model i prepare some validation for email field:

'email' => array(
    'mail' => array(  
        'rule' => array('email', true),  
        'required' => false,  
        'message' => 'Not correct e-mail!'),  
    'unique' => array(  
        'rule' => 'isUnique',  
        'message' => 'E-mail was registered!'))

But the rule isUnique doesn't work.
Addition i change in MySQL field email to unique, but still doesn't work.
I use CakePHP 2.3.7

Problem is when we use Translate behavior with model.

The query:

SELECT COUNT(DISTINCT(`User`.`id`)) AS count FROM `sometable`.`users` AS `User` INNER JOIN `sometable`.`i18n` AS `I18nModel` ON (`User`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'User' AND `I18nModel`.`locale` = 'pl') WHERE `User`.`email` = '[email protected]'

Field email isn't translated.

Check the sql log - If there is no query for select count(*) from users where email = "text you entered" - it's likely the rule is not defined correctly. — AD7six
@AD7six Problem is when we use Translate with model and i show query bellow — kicaj

cartina cartina · Accepted Answer · 2013-08-02T06:37:29

Try this.

array(
    'email' => array(
        'notEmpty' => array(
            'rule' => 'notEmpty',
            'message' => 'Provide an email address'
        ),
        'validEmailRule' => array(
            'rule' => array('email'),
            'message' => 'Invalid email address'
        ),
        'uniqueEmailRule' => array(
            'rule' => 'isUnique',
            'message' => 'Email already registered'
        )
    )
);

CakePHP isUnique doesn't work

2 Answers