Hi all,
I am using Postgres for the first time and I am running into problems when
using the Tree behavior on my Page model. I am familiar with the Tree
behavior and have used it many times with MySQL so I know my pages table is
set up correctly.
I can insert new records and the lft, rght and parent_id fields appear to
be updating OK, but when I run the recover() function on the tree, or I try
to use moveUp() or moveDown() I get an error from a specific query:
ERROR: column "Page.lft" must appear in the GROUP BY clause or be used in
an aggregate function
^
In statement:
SELECT MAX("Page"."rght") AS "rght" FROM "public"."pages" AS "Page" WHERE 1
= 1 ORDER BY "Page"."lft" ASC LIMIT 1
Anyone encountered this before or know of a solution?
Thanks very much,
Alex
--
Alex Bovey
Web Developer | Alex Bovey Consultancy Ltd
Registered in England & Wales no. 6471391 | VAT no. 934 8959 65
[email protected] | t 0844 567 8995 | m 07828 649386 | f 0870 288 9533
PHP | CakePHP | MySQL | jQuery | HTML5 | CSS3 | Drupal | Wordpress | Hosting
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
