Hi
I have some strange mysql error when I try to select Max(field1) and
field2. if I select only Max(field1) ( SELECT Max(Alias.field1) as field1
>From table ) it works.
Ok this error probably comes from the mysql version ( ovh server : mysql
client Api Version 5.0.32 ) because everything works with all my other
configuration.
*This error is easy to fix* : I add 'group'=>array('Alias.primaryKey') in
the options of the find function.
but the TreeBehavior for example frequently ask for the Max(Tree.rght) with
other fields (during Insertion for example) and doesn't group rows.
So when I create Menu (using Tree behavior) I have a mysql error.
*Is it a cakePhp bug or is there a way to make it works?* (currently I've
added 'group' option to the TreeBehavior::_getMax(...) function )
Thanks for reading me (and my poor english) and for all the great work
you're doing!!
Quentin
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
