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