Friday, September 24, 2010

Re: Problem with internal Database interaction at getting Classinfo

How do you execute the query?

On Thu, Sep 23, 2010 at 10:44 PM, Senpu <kheid@gmx.de> wrote:
I'm sorry to explain it like this, but i can't describe it better, its
strange

I get this Error-message at index-action:

Warning (512): SQL Error: 1054: Unknown column 'buildings.village_id'
in 'where clause' [CORE\cake\libs\model\datasources\dbo_source.php,
line 681]

correspondending query:
Query: SELECT `Building`.`id`, `Building`.`village_id`,
`Building`.`building_id`, `Building`.`level`, `Building`.`modified`,
`Building`.`created` FROM `buildings` AS `Building` WHERE
`buildings`.`village_id` = `villages`.`id` AND `Building`.`village_id`
= (1) ORDER BY `buildings`.`building_id` ASC

Now, i can see why the error occurs (where needs to be "Building" not
"buildings") but how can i solve it? its automatically created by cake
and i didnt find any options to change it..

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.
 
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en

No comments: