Re: Possible bug in Tree, recover

Interesting. You should post a ticket here:

http://cakephp.lighthouseapp.com/dashboard

On Tue, Jun 22, 2010 at 9:22 AM, Erik Starck <erik.starck@gmail.com> wrote:
> Hi group!
> My first post to this list so here goes...
>
> I may have found a bug in the recover method in Tree.php, cake 1.3.2.
> I was getting an SQL error when calling recover:
>
> SQL Error: 1062: Duplicate entry '20' for key 'PRIMARY'
>
> Here is an example of the SQL:
> UPDATE `categories` SET `id` = 20, `parent_id` = 17, `name` = 'Beauty
> tools', `lft` = 1, `rght` = 2  WHERE `categories`.`id` = 4
>
> Obviously this is wrong since it's trying to update the id which is
> the primary key.
>
> The error pointed to:
> TreeBehavior::recover() - CORE/cake/libs/model/behaviors/tree.php,
> line 606
>
> I made debug prints on the variables used before the save method
> called on line 606 and noticed that the $Model->id was different from
> the id in $Model->data. In fact, the $Model->data contained a
> completely different object than the one with the current id.
> So I added:
>        $Model->data = $array;
> on line 604 and now it works. The tree is updated with correct lfts
> and rghts.
>
> The tree is a small one with about 20 nodes and it has correct
> parent_ids.
>
> Haven't dug any deeper in to this than the above. I've executed the
> individual test case: libs/model/behaviors/tree.test.php before and
> after the change and it passes both times.
>
>
> Erik S.
> @erikstarck
> http://www.softwaresweden.com
>
> 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