Hey, Thanks for your help.
What I did was re-configure index keys in the db for the ones most used, cleared app/temp/cache/models and it worked. Thought it seems for me to run buildAcl again I have to clear the cache or I get the error again. Thanks, Dave -----Original Message----- From: John Andersen [mailto:j.andersen...@gmail.com] Sent: May-14-09 3:32 AM To: CakePHP Subject: Re: ACL issue Ok, I will try to look at it in between working :) ... Hopefully someone else may know about this too, and reply to you while I am looking! John On May 13, 5:06 pm, "Dave Maharaj :: WidePixels.com" <d...@widepixels.com> wrote: > Hello John, > > This is what I see when I run buildAcl from the browser (x 238 times > just the alias` = 'apply' changes for each controller action) > > Query: SELECT `Aco`.`id`, `Aco`.`parent_id`, `Aco`.`model`, > `Aco`.`foreign_key`, `Aco`.`alias` FROM `acos` AS `Aco` LEFT JOIN > `acos` AS `Aco0` ON (`Aco0`.`alias` = 'controllers') LEFT JOIN `acos` > AS `Aco1` ON (`Aco1`.`lft` > `Aco0`.`lft` AND `Aco1`.`rght` < > `Aco0`.`rght` AND `Aco1`.`alias` = 'Applicants') LEFT JOIN `acos` AS > `Aco2` ON (`Aco2`.`lft` > `Aco1`.`lft` AND `Aco2`.`rght` < > `Aco1`.`rght` AND `Aco2`.`alias` = 'apply') WHERE ((`Aco`.`lft` <= > `Aco0`.`lft` AND `Aco`.`rght` >= `Aco0`.`rght`) OR (`Aco`.`lft` <= > `Aco2`.`lft` AND `Aco`.`rght` >= `Aco2`.`rght`)) ORDER BY > `Aco`.`lft` DESC > > Now there is one of these statements it seems for every action up to a > certin point > > Array > ( > [0] => Created Aco node for apply > .... > .... > .... > [238] => Created Aco node for admin_edit > ) > > It stops at 238 but looking thru the array I can clearly see missing > actions not in the array, check the db and nothing was created > > Ideas? > > -----Original Message----- > From: John Andersen [mailto:j.andersen...@gmail.com] > Sent: May-13-09 3:47 AM > To: CakePHP > Subject: Re: ACL issue > > 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" > <d...@widepixels.com> 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:d...@widepixels.com] > > Sent: May-12-09 9:29 PM > > To: cake-php@googlegroups.com > > 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 cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---