On Mon, Mar 9, 2009 at 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 think it's safe to assume that the problem lies with your app and not the JOIN limitation, so I'd look at that before thinking about switching providers. That said, I don't know what the specific problem might be aside from some recursion somewhere (likely involving parent_id). --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
