Hi,
I have problem with ORM (m-n) to relationship.
http://farm4.static.flickr.com/3171/2950137747_b098638c67.jpg?v=0 ERD
image
The table categories is related to itself using m-n relationship. To
make this possible I created a new mapping table called as
categories_categories.
This is the HBTM I came up with
-----------------------------------------------------------------------------------------------
var $hasAndBelongsToMany = array(
'Category' => array(
'className' => 'Category',
'joinTable' => 'categories_categories',
'foreignKey' => 'parent_category_id',
'associationForeignKey' =>
'child_category_id',
'conditions' => '',
'order' => '',
'limit' => '',
'unique' => true,
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
),
'Category' => array(
'className' => 'Category',
'joinTable' => 'categories_categories',
'foreignKey' => 'child_category_id',
'associationForeignKey' =>
'parent_category_id',
'conditions' => '',
'order' => '',
'limit' => '',
'unique' => true,
'finderQuery' => '',
'deleteQuery' => '',
'insertQuery' => ''
)
);
----------------------------------------------------------------------------------------------
I think I didnt get the relationshp right. And ended up with this
error (below).
----------------------------------------------------------------------------------------------
Warning (512): SQL Error: 1048: Column 'parent_category_id' cannot be
null [CORE/cake/libs/model/datasources/dbo_source.php, line 521]
Code | Context
$sql = "INSERT INTO `categories_categories`
(`parent_category_id`,`child_category_id`) VALUES (NULL,'1')"
$error = "1048: Column 'parent_category_id' cannot be null"
$out = null
$out = null;
if ($error) {
trigger_error("<span style = \"color:Red;text-
align:left\"><b>SQL Error:</b> {$this->error}</span>",
E_USER_WARNING);
DboSource::showQuery() - CORE/cake/libs/model/datasources/
dbo_source.php, line 521
DboSource::execute() - CORE/cake/libs/model/datasources/
dbo_source.php, line 208
DboSource::fetchAll() - CORE/cake/libs/model/datasources/
dbo_source.php, line 344
DboSource::query() - CORE/cake/libs/model/datasources/dbo_source.php,
line 228
DboMysql::insertMulti() - CORE/cake/libs/model/datasources/dbo/
dbo_mysql.php, line 502
Model::__saveMulti() - CORE/cake/libs/model/model.php, line 1254
Model::save() - CORE/cake/libs/model/model.php, line 1180
Scaffold::__scaffoldSave() - CORE/cake/libs/controller/scaffold.php,
line 298
Scaffold::__scaffold() - CORE/cake/libs/controller/scaffold.php, line
424
Scaffold::__construct() - CORE/cake/libs/controller/scaffold.php, line
193
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 248
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 213
[main] - APP/webroot/index.php, line 90
Query: INSERT INTO `categories_categories`
(`parent_category_id`,`child_category_id`) VALUES (NULL,'1')
----------------------------------------------------------------------------------------------
My ERD is like this, I have two tables one is categories table and
other is the mapping table to make the m-n relationship possible
called as categories_categories.
----------------------------------------------------------------------------------------------
CREATE TABLE IF NOT EXISTS `categories_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_category_id` int(11) NOT NULL,
`child_category_id` int(11) NOT NULL,
`created` datetime default NULL,
`modified` datetime default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
----------------------------------------------------------------------------------------------
My problem is smilar to the financial example in this link
http://www.tdan.com/view-special-features/5400/
Please, Help me with the HBTM relationship????
Imranullah Mohammed
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
