Thursday, August 27, 2009

Weird SQL requests with CakePHP on an Oracle DataBase ?!!

Hi everyone,

I've transfered all my data from MySQL to an Oracle Database.
It used to work very well with MySQL.

Now, when i try to launch my application, i've got weird request.

I respected all tablename conventions from the CakePHP sites so i've
set plural tablenames. For examples for the table "groups" here is the
sql request from CakePHP :

SELECT Group.id, Group.name, Group.parent_id, Group.lft, Group.rght,
Group.commentaires, Group.created, Group.modified FROM groups Group
WHERE 1 = 1 ORDER BY Group.lft asc

Notice that it don't use the plural of Group AND at the end, in the
"FROM", i've got the tablename two times.. I don't have any clue from
where does it come and how can i fix this.:(

Thanks in advance for any help
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---

No comments: