Hello,
This is my problem:
I have a user model which is linked to a role model via a HABTM
association.
When a new record is added all the associations are added correctly,
the problem is when I delete a record, the associated records are not
deleted as expected.
Cake also showed the following error:
Warning (512): SQL Error: 1054: Unknown column 'RolesUser.id' in
'field list' [CORE\cake\libs\model\datasources\dbo_source.php, line
521]
So to solve the problem I over wrote the following function from the
core model file located at: app\cake\libs\model\model.php
/**
* Cascades model deletes to HABTM join keys.
*
* @param string $id ID of record that was deleted
* @return void
* @access protected
*/
function _deleteLinks($id) {
$db =& ConnectionManager::getDataSource($this->useDbConfig);
pr($this->hasAndBelongsToMany);
foreach ($this->hasAndBelongsToMany as $assoc => $data) {
$records = $this->{$data['with']}->find('all', array(
'conditions' => array($data['foreignKey'] =>
$id),
'fields' => $this->{$data['with']}->primaryKey,
'recursive' => -1
));
if (!empty($records)) {
foreach ($records as $record) {
$this->{$data['with']}->delete($record[$this->{$data['with']}-
>alias][$this->{$data['with']}->primaryKey]);
}
}
}
}
------------------------------------------------
with this function in app_model.php
/**
* Cascades model deletes to HABTM join keys.
*
* @param string $id ID of record that was deleted
* @return void
* @access protected
*/
function _deleteLinks($id) {
foreach ($this->hasAndBelongsToMany as $assoc => $data) {
$records = $this->{$data['with']}->find('all', array(
'conditions' => array($data['foreignKey'] =>
$id),
//'fields' =>
$this->{$data['with']}->primaryKey,
'fields' => $data['foreignKey'],
'recursive' => -1
));
if (!empty($records)) {
foreach ($records as $record) {
//added this line;
$this->{$data['with']}->primaryKey =
$data['foreignKey'];
$this->{$data['with']}->delete($record[$this->{$data['with']}-
>alias][$this->{$data['with']}->primaryKey]);
}
}
}
}
It now works fine, but I am not really if can consider the problem
solved.
Can someone with more experience take a look and let me that it will
not cause any issues.
I did rather not touch the Cake core files...
Many thanks in advance.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
