Cuniquevalidator And Cexistvalidator Do Not Respect Table Alias While Creating Db Query Condition

Yii 1.1 General Discussion
1

CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t.email’ in ‘where clause’. The SQL statement executed was: SELECT * FROM contact contact WHERE (contact.status = ‘1’) AND (t.email=:ycp0) ORDER BY contact.created DESC, contact.id DESC LIMIT 2. Bound with :ycp0=‘xxx@yahoo.com’

Version 1.1.11 July 29, 2012 changelog

CUniqueValidator and CExistValidator now respect table alias while creating db query condition (klimov-paul)

seems to me unique validator is still not respecting aliases in tables, as you can see one field was aliased "status" but email was not

can you guys help? this happened when i tried updating column data, table is aliased

2

got this fixed, by adding a default scope and using $this->getTableAlias(false,false) as name of alias