Re: Error updating an ACO in Cake1.2 beta using a postgres DB

2008-02-04 Thread snowdog
Thanks man, you saved me couple hours of code digging with this hint --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from

Re: Error updating an ACO in Cake1.2 beta using a postgres DB

2008-02-01 Thread BravoFoxtrot
Thanks! I'll make the changes in my code. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email

Re: Error updating an ACO in Cake1.2 beta using a postgres DB

2008-02-01 Thread DJ Spark
just filled a ticket for this problem. by now, changing the last line of the __sync() function, in TreeBehaviour, seems to work from $model->updateAll(array($model->escapeField($field) => $model->escapeField($field) . ' ' . $dir . ' ' . $shift), $conditions); TO $model->updateAll(array($field =

Error updating an ACO in Cake1.2 beta using a postgres DB

2008-02-01 Thread BravoFoxtrot
When I try to update an ACO I get the following error: LINE 1: UPDATE "acos" SET "Aco"."lft" = "Aco"."lft" + 2 WHERE "id" ... ^ [CORE/cake/libs/model/ datasources/dbo/dbo_postgres.php, line 122] Some where along the way an alias is being added to the SQL