Try this instead:
:::::::::::::Subalbum model:::::::
var $belongsTo = array('Album');
Jeremy Burns
Class Outfit
[email protected]
http://www.classoutfit.com
On 22 Jun 2011, at 08:54, madusanka hettiarachchi wrote:
> HI guys,
>
> Im new to cake! I made a association between two models called "Album" and
> "Subalbum".
> association should be like this,
>
> Subalbum hasOne Album
> Album hasMany Subalbums
>
> bt I got error like this,
>
> 1054: Unknown column 'Album.subalbum_id' in 'on clause'
> [CORE\cake\libs\model\datasources\dbo_source.php, line 684]
>
> SELECT `Subalbum`.`id`, `Subalbum`.`sub_album_name`,
> `Subalbum`.`date_created`, `Subalbum`.`last_modified_date`,
> `Subalbum`.`music_id`, `Subalbum`.`size`, `Subalbum`.`album_id`,
> `Album`.`id`, `Album`.`album_name`, `Album`.`sub_directory`,
> `Album`.`create_date`, `Album`.`last_modified_date`, `Album`.`music_id`,
> `Album`.`album_category`, `Album`.`album_description`, `Album`.`user_id`,
> `Album`.`size` FROM `subalbums` AS `Subalbum` LEFT JOIN `albums` AS `Album`
> ON (`Album`.`subalbum_id` = `Subalbum`.`id`) WHERE 1 = 1
>
> error occuerd due to highlighted part of the query, it should be
> (`Album`.`subalbum_id` = `Subalbum`.`id`)
>
> here are my codes
>
> :::::::::::::Subalbum model:::::::
>
> var $hasOne = array('Album');
>
> :::::::::::::Album model ::::::::::::::::::::
>
> var $hasMany = 'Subalbum';
>
>
> can any body help me?
> --
> Ganganath Hettiarachchi
>
> --
> 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
> [email protected] For more options, visit this group at
> http://groups.google.com/group/cake-php
--
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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
