Hi,
I'm stumbling across bug number 4194. https://trac.cakephp.org/ticket/4194
I have a User model, which has a `name` field.
This User hasMany Accounts, which also have a `name` field.
The User also hasAndBelongsToMany other Users as a friend relationship.
User (`name`, ...)
|
|- hasMany
| |- Accounts (`name`, ...)
|
|- hasAndBelongsToMany
|- User
When I try to save such a User-User HABTM relationship, Cake is doing
all sorts of lookups, apparently for every linked model.
What it fails at is this query:
SELECT COUNT(*) AS `count` FROM `users` AS `User`
LEFT JOIN `accounts` AS `DefaultAccount`
ON (`User`.`default_account_id` = `DefaultAccount`.`id`)
WHERE ((`name` = '<username>')) AND `User`.`id` != 1
1052: Column 'name' in where clause is ambiguous
The WHERE clause would need to be extended to query for `User`.`name`
instead of just `name`, since both tables have a column called `name`.
I'm not quite sure why Cake is doing all these queries in the first
place, guess it's just being extra paranoid.
Anyway, the above mentioned bug seems to be very related, but nate
insists on a test case.
I have no idea how to write test cases for something like this, so
could a kind soul jump in?
Chrs,
Dav
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
