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
-~----------~----~----~----~------~----~------~--~---
