Hi,
I have a problem with cakephp.
I have just migrate cake php from 1.1 to 1.2 and cake php make a
mistake with an autogenerated query.
It is very strange.
look : it is the cakePhp generated query
SELECT `User`.`id`, `User`.`group_id`, `User`.`access_id`,
`User`.`status_id`, `User`.`firstname`, `User`.`lastname`,
`User`.`address`, `User`.`address2`, `User`.`city`, `User`.`state`,
`User`.`zipcode`, `User`.`country`, `User`.`phone`,
`User`.`cellphone`, `User`.`fax`, `User`.`email`, `User`.`password`,
`User`.`created`, `User`.`login`, `User`.`filename`,
`User`.`location`, `User`.`order_list`, `User`.`defaultview`,
`User`.`defaulttime`, `User`.`activated`, `User`.`ban`,
`Group`.`group_id`, `Group`.`manager_id`, `Group`.`groupname`,
`Group`.`email`, `Group`.`filename`, `Group`.`location`,
`Statu`.`status_id`, `Statu`.`name`, `Access`.`access_id`,
`Access`.`access`, `Access`.`name`, `Access`.`admin` FROM `users` AS
`User` LEFT JOIN `groups` AS `Group` ON (`User`.`group_id` =
`Group`.`group_id`) LEFT JOIN `status` AS `Statu` ON
(`User`.`statu_id` = `Statu`.`status_id`) LEFT JOIN
^^^^^^^^^^
`accesses` AS `Access` ON (`User`.`access_id` = `Access`.`access_id`)
WHERE `User`.`email` = '[EMAIL PROTECTED]' LIMIT 1;
The result is :
SQL Error: 1054: Unknown column 'User.statu_id' in 'on clause'.
That is normal because there is no statu_id in the User table but
status_id (with an 's')
when I execute the query with status_id instead of statu_id it works.
I realy don't know where are the problem from.
Why cakephp generate this query with a mistake ?
Thanks for your help.
Seb
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
