I've tried commenting out the code and running prd($this->Category-
>movedown(2, abs(1))); only, but no joy.  The primary id, 2 does
exist.  If i change the id to a random number that's not an id, i get
the following:

array_values() [function.array-values]: The argument should be an
array [CORE/cake/libs/model/behaviors/tree.php, line 448]
SQL Error: 1064: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right
syntax to use near 'AND' at line 1
Query: UPDATE `categories` AS `Category` SET `Category`.`lft` =
`Category`.`lft` + 46 WHERE `Category`.`lft` BETWEEN AND

Query: UPDATE `categories` AS `Category` SET `Category`.`rght` =
`Category`.`rght` + 46 WHERE `Category`.`rght` BETWEEN AND

So if the value id exists in the db, i get no update query, but if i
change the id to a random number the update query gets ran??

On 21 Feb, 10:40, WebbedIT <[email protected]> wrote:
> Are you sure your controller action is executing the $this->Category-
>
> >moveDown($this->Category->id, abs($delta)); command?

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 [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

Reply via email to