Asked this before but did some more testing and the problem has come up again. When building an ACL app i followed the cookbook and initBD and buildACL work fine. When I add tables to that setup and then I get MAX_JOIN error in SQL? What would cause this? I checked mySQL settings and MAX_JOIN_SIZE is listed at 100,000,000. If i run the exact same table structure locally where my MAX_JOIN_SIZE is 4,294,967,295 it runs the initBD and buildAcl fine with no errors reported. Tested using cake 1.2.3.8166 There are 40 tables in the db 10 are HABTM tables. Is there a limitation of any kinds using HABTM or something thats causing this error? What is MAX_JON_SIZE exactly? And what would cause it to be over? My tables are only populated with 10 entries each with dummy info as its just in development. All my tables have ID PRIMARY key INT (10) AUTO INCREMENT There is a patch i found on <http://realm3.com/articles/setting_up_users_groups_withacl_and_auth_in_cake _1.2.php> http://realm3.com/articles/setting_up_users_groups_withacl_and_auth_in_cake_ 1.2.php and if i modify the db_acl.php it runs with no errors but still patching the app is not what i want. Just to find out why it does this. Could I get some feed back on people usingACL with large database tables who could give me an idea of the size of their tables and let me know what your MAX_JOIN_SIZE is listed at for your mySQL? Maybe its a hosting issue and nothing to do with cake at all. Thanks in advance. Dave
--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
