Yes, the WHERE clause should have `Subscription`.`user_id` . It looks like you have your primary key as a combination of 'user_id' and 'community_id', rather than just a normal 'id' field, correct? I'm not actually sure how you'd have done this (I thought the $primaryKey model attribute could only be a single field name), but however you've done it, you've probably just put 'user_id' and 'community_id', and you should change these to 'Subscription.user_id' and 'Subscription.community_id'.
An alternative method is just to avoid the LEFT JOIN in this query. You can do this with $this->Subscription->recursive = -1 before your save query. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
