Tuesday, October 28, 2014

[Question] Acl query error

Hello guys, I'm totally newbie in CakePHP.
Now I'm working on acl. I've set my access to administrator which can do anything. 
But when i call method/action add or anything that i don't allow in beforeFilter() method there is an error like this 

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Aro0.foreignKey' in 'where clause' 
SQL Query: SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, `Aro`.`foreign_key`, `Aro`.`alias` FROM `dotcore`.`aros` AS `Aro` INNER JOIN `dotcore`.`aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'Group' AND `Aro0`.`foreignKey` = '1' ORDER BY `Aro`.`lft` DESC


Please help me 

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

No comments: