Is there a best practice or rule of thumb to work from when defining model associations? It seems pretty cut and dry and there's not much that you can really mess up.
I know this problem has been brought up here in the past but I'm still unable to find a solution after reviewing older threads. I'm getting the MAX_JOIN_SIZE error when attempting to login. "The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay" It's my User model that is triggering this error. There are about 10 $hasMany and 5 $hasOne assocs for this model. This really doesn't seem like too much does it? Is there an approximate number of relationships I should try no exceed? I still have more to add to it. I found an older thread that "claimed" ACL was to blame for this and the problem did go away for a while after I stopped using ACL but I really don't think ACL has anything to do with it. I'm guessing the I screwed something up with model associations but I'm not sure what or where the problem is. Any ideas where I may have gone wrong here? - Ed Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. 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
