I've been hosting my CakePHP apps with Surpass Hosting (http:// www.surpasshosting.com) and ACL works fine. Their developer plan is pretty nice...latest version of PHP/MySQL/PostgreSQL/SQLite and version control (SVN, GIT, CVS):
http://www.surpasshosting.com/surpass-developer-resources.php On Mar 9, 7:13 pm, "Dave Maharaj :: WidePixels.com" <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
