Hi Dave, Can you post the created sql statements, that may help to discover why! MAX_JOIN_SIZE is the limit on number of records that one SELECT using JOINs may process. As specified in the MySql forum, either set the number bigger or use SET SQL_BIG_SELECTS=1 before your select (a little difficult using CakePHPs built-in sql statement generator).
I agree that with 10 records in each, it shouldn't reach the limit, but let's see what the statements may tell us :) John On May 13, 5:57 am, "Dave Maharaj :: WidePixels.com" <[email protected]> wrote: > The server I am hosting with cannot have anything changed so this is it > > max_allowed_packet 33554432 > max_binlog_cache_size 18446744073709547520 > max_binlog_size 1073741824 > max_connect_errors 10 > max_connections 600 > max_delayed_threads 20 > max_error_count 64 > max_heap_table_size 268435456 > max_insert_delayed_threads 20 > max_join_size 100000000 > max_length_for_sort_data 1024 > max_prepared_stmt_count 16382 > max_relay_log_size 0 > max_seeks_for_key 18446744073709551615 > max_sort_length 1024 > max_sp_recursion_depth 0 > max_tmp_tables 1024 > max_user_connections 60 > max_write_lock_count 18446744073709551615 > > Does this look normal to what you are using for your apps? > > ________________________________ > > From: Dave Maharaj :: WidePixels.com [mailto:[email protected]] > Sent: May-12-09 9:29 PM > To: [email protected] > Subject: ACL issue > > 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 > onhttp://realm3.com/articles/setting_up_users_groups_withacl_and_auth_i... > 1.2.php > <http://realm3.com/articles/setting_up_users_groups_withacl_and_auth_i... > _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 -~----------~----~----~----~------~----~------~--~---
