$this->Model->find('list'); fails on models with permissionable attached

[jmcneese]

$this->Model->find('list'); fails on models with permissionable attached

[darxmac]

And you can fix it by adding 'recursive' => 0 to your $params array.

[jmcneese]

strange. i'll see if i can track down what is causing it.

[richardsession]

I'm getting the same thing. I set the params variable to array('permissionable'=>false) to get it to work properly.

I'm getting the same issue on mysql,

SELECT Store.*, StorePermissionBit.* FROM storesASStoreWHERE 1 = 1 ORDER BYnumber asc LIMIT 20

1051: Unknown table 'StorePermissionBit'

Any workaround that doesn't disable the permissionable behavior like above?

Thanks

Hi guys, as a workaround you can put the following in your app model, credit to @darxmac for tracking down recursive=>0 being the problem:

       switch ($type) {
           case 'list':
                 $options['recursive'] = 0;
                 return parent::find('list', $options); 
           break;  
           default:  
               return parent::find($type, $options);
           break;
       }
   }