Column not found: 1054 Unknown column 'Contact.name' in 'field list'
With this Query :: SELECT `Project`.`id`, (CONCAT(`Project`.`name`, " ", `Contact`.`name`, "")) AS `Project__displayName` FROM `projects` AS `Project` INNER JOIN `used` AS `Used` ON (`Used`.`foreign_key` = `Project`.`id` AND `Used`.`model` = 'Project' AND `Used`.`user_id` = 1) WHERE 1 = 1 ORDER BY `Project`.`name` ASC
Mind you this query works in every other place in our app because the Contact table is automatically joined with containable. Just in this one plugin it seems to be impossible to get contain to work when its called from this plugin to another plugin.
Here is the line that is creating this query in TimesheetsController.php :
$projects = $this->TimesheetTime->Project->find('list');
Here is the output from beforeFind($queryData) { debug($queryData) } in the Project model (most notably is that 'contain' => Contact.name exists in the queryData)
Array ( [conditions] => [fields] => Array ( [0] => Project.id [1] => Project.displayName ) [joins] => Array ( [0] => Array ( [table] => used [alias] => Used [type] => INNER [conditions] => Array ( [0] => Used.foreign_key = Project.id [1] => Used.model = 'Project' [2] => Used.user_id = 1 ) ) ) [limit] => [offset] => [order] => Array ( [0] => Array ( [0] => Project.name ) ) [page] => 1 [group] => [callbacks] => 1 [contain] => Array ( [0] => Contact.name ) [recursive] => -1 [list] => Array ( [groupPath] => [valuePath] => {n}.Project.displayName [keyPath] => {n}.Project.id ) )
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
No comments:
Post a Comment