Can I get some feedback on the hosting companies people use to host cake sites? I am using hostmonster and when I setup ACL it will not run. I get SQL Error: 1104: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay [CORE/cake/libs/model/datasources/dbo_source.php, line 514]
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')................. I checked the MAX_JOIN_SIZE they have and it is 100,000,000 which I can not image why it would not work but for some reason its not working for me. I contacted hostmonster and their response for increasing MAX_JOIN_SIZE is: Dear Customer, Thanks for contacting us. We apologize for the trouble you've been having, but we are unable to raise MAX_JOIN_SIZE. If it needs joins that big then it won't work on our servers unfortunately. Thanks, JM Level 2 Scripting Specialist hostmonster.com 866.573.4678 Can someone let me know how to fix this error or suggest a hosting company that you use and have the AUTH ACL setup running on? Thanks 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 -~----------~----~----~----~------~----~------~--~---
