hasOne not automatically bound when calling $Model::find('list');

[cdvrooman]

I'm trying to do this:

$this->Group->find('list');

and my SQL is coming out like this:

SELECT Group.id, Group.name, GroupPermission.* FROM groups AS Group WHERE 1 = 1

In permisssionable/models/behaviors/permissionable.php, when I debugged the $Model before and after this line of the beforeFind() function:

$this->_bind($Model, array( ... ));

the $Model did not and then did have a 'hasOne' binding to GroupPermission however for some reason it isn't being applied to the ->find('list') query.

I tried to do a $this->Group->find('all'); and that did work as expected.

I'm calling $this->Group from my users_controller where I have:

var $uses = array('User', 'Group');

I have User HABTM Group and Group HABTM User defined in the appropriate model files.

[cdvrooman]

I did some poking around in /cake/libs/model/model.php and in the _findList() function, I found this: if (!isset($query['recursive']) || $query['recursive'] === null) { $query['recursive'] = -1; } Which could definitely be screwing things up if 'recursive' is not being explicitly set by Permissionable', perhaps only when the find is of the 'list' variety?

[cdvrooman]

On a related note, I'm running into a similar problem when trying to save something to the Group table, where first the ability to write to the table is verified. The SQL is appearing as: SELECT COUNT() AS count, GroupPermission. FROM groups AS Group WHERE Group.name = 'Root' AND Group.id != ' ... uuid ...'

In \models\behaviors\permissionable.php I tried adding 'recursive' => 1 to hasPermissions() here: $perm = $Model->{$alias}->find('count', array( ... )); but it didn't have any effect.

I also tried modifying $queryData['recursive'] directly in the beforeFind() function, but that caused my browser to be unable to resolve the page.

[cdvrooman]

Two alternatives are:

1. Adding 'permissionable' => false to the find parameters, i.e.: $users = $this->User->find('list', array( 'permissionable' => false, 'conditions' => array('User.name <>' => 'guest') )); or, using find('all') but specifying the fields, i.e. $users = $this->User->find('all', array( 'recursive' => -1, 'conditions' => array('User.name <>' => 'guest'), 'fields' => array('User.id', 'User.name') ));

[cdvrooman]

Of course in the second case you would have to use Set::extract() or something similar on the results to leave only the 'user_id' => 'user_name'.

[afrance]

Any real solution to this? The same issue crops up when attempting to use the tree behavior.