Re: cake model association error
Hi Jeramy,
thank you very much, As u said error was there. thanks you again for saving
my time!
-- Forwarded message --
From: Jeremy Burns | Class Outfit
Date: Wed, Jun 22, 2011 at 1:38 PM
Subject: Re: cake model association error
To: cake-php@googlegroups.com
Try this instead:
:Subalbum model:::
var $belongsTo = array('Album');
Jeremy Burns
*Class Outfit*
*
*
jeremybu...@classoutfit.com
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
cake-php+unsubscr...@googlegroups.com 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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
--
Ganganath Hettiarachchi
Faculty of Information Technology
UOM
--
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+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: cake model association error
Try this instead:
:Subalbum model:::
var $belongsTo = array('Album');
Jeremy Burns
Class Outfit
jeremybu...@classoutfit.com
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
> cake-php+unsubscr...@googlegroups.com 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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
cake model association error
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
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
