Did you find the answer to this? I'm experiencing similar problems with the lft and rght value in the ARO table sometimes being zero. I can't reproduce this problem though, so it's hard to fix.
Vincent On Sep 6, 4:31 pm, euromark <dereurom...@googlemail.com> wrote: > What the ... is the acl behavior doing? > > The user just updates his password (nothing else) > after that he cannot log in anymore because the aro/aco table gets > messed up really bad > > Cake1.3.3 HEAD > > Any ideas? > > 23 SELECT COUNT(*) AS `count` FROM `users` AS `User` WHERE > `User`.`id` = '499949c6-c204-4c89-8dce-1918ab957338' > 1 1 > 0 > 24 UPDATE `users` SET `password` = > '651220fc90f09cdc7de34b3b2b5b6a9b91ed0031', `modified` = > '2010-09-06 15:13:03' WHERE `users`.`id` = '499949c6- > c204-4c89-8dce-1918ab957338' 1 1 > 25 SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`model`, > `Aro`.`foreign_key`, `Aro`.`alias` FROM `aros` AS `Aro` LEFT JOIN > `aros` AS `Aro0` ON (`Aro`.`lft` <= `Aro0`.`lft` AND `Aro`.`rght` > >= `Aro0`.`rght`) WHERE `Aro0`.`model` = 'User' AND > `Aro0`.`foreign_key` = '499949c6- > c204-4c89-8dce-1918ab957338' ORDER BY `Aro`.`lft` DESC 2 > 2 1 > 26 SELECT COUNT(*) AS `count` FROM `aros` AS `Aro` WHERE `Aro`.`id` > = 129 1 1 0 > 27 SELECT `Aro`.`parent_id` FROM `aros` AS `Aro` WHERE `Aro`.`id` = > 129 LIMIT 1 1 1 0 > 28 SELECT COUNT(*) AS `count` FROM `aros` AS `Aro` WHERE `Aro`.`id` > = 129 1 1 0 > 29 UPDATE `aros` SET `parent_id` = NULL, `model` = 'User', > `foreign_key` = '499949c6-c204-4c89-8dce-1918ab957338', `id` > = 129 WHERE `aros`.`id` = 129 1 0 > 30 SELECT `Aro`.`id`, `Aro`.`parent_id`, `Aro`.`lft`, `Aro`.`rght` > FROM `aros` AS `Aro` WHERE 1 = 1 AND `Aro`.`id` = 129 LIMIT 1 > 1 > 1 0 > 31 SELECT MAX(`Aro`.`rght`) AS `rght` FROM `aros` AS `Aro` WHERE 1 = > 1 LIMIT 1 1 1 0 > 32 UPDATE `aros` AS `Aro` SET `Aro`.`lft` = `Aro`.`lft` + 31 WHERE > `Aro`.`lft` BETWEEN 104 AND 105 1 0 > 33 UPDATE `aros` AS `Aro` SET `Aro`.`rght` = `Aro`.`rght` + 31 WHERE > `Aro`.`rght` BETWEEN 104 AND 105 1 0 > 34 UPDATE `aros` AS `Aro` SET `Aro`.`lft` = `Aro`.`lft` - 2 WHERE > `Aro`.`lft` > 104 14 1 > 35 UPDATE `aros` AS `Aro` SET `Aro`.`rght` = `Aro`.`rght` - 2 WHERE > `Aro`.`rght` > 104 15 1 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
