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 => '['.$field . '] ' . $dir . ' ' . $shift), $conditions); https://trac.cakephp.org/ticket/4052 Spark On Feb 1, 2008 3:31 PM, BravoFoxtrot <[EMAIL PROTECTED]> wrote: > > 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 for the > ACO table. So far problem is only occurring when I try to update the > ACO table. When I update any of the tables that I created, the update > works fine. > > I grabbed the latest code from the datasouces directory in SVN today > but it didn't seem to help. > > I'm not sure where to start looking for this problem. Any ideas? > > I made a quick hack to dbo_souce.php in _prepareUpdateFields() to > stip out the alias. This of course is the wrong place but I need to > get this working ASAP. > > thanks. > > > > -- [livesets] http://djspark.com.br/ [web] http://sydi.net [filmes] http://melhoresfilmes.com.br --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
