Re: Where to SET SQL_BIG_SELECTS=1 in cakephp

2009-01-04 Thread eMarcus
Hi Raphaele, Thanks! that did the trick! Maybe this would be something for the developers, that it would nice to have a possibility to set SQL parameters centrally... bye Marcus. On Dec 26 2008, 8:58 am, raphaele.gior...@gmail.com raphaele.gior...@gmail.com wrote: I should have add that in

Re: Where to SET SQL_BIG_SELECTS=1 in cakephp

2009-01-04 Thread eMarcus
Hi Raphaele, Thanks! that did the trick! Maybe this would be something for the developers, that it would nice to have a possibility to set SQL parameters centrally... bye Marcus. On Dec 26 2008, 8:58 am, raphaele.gior...@gmail.com raphaele.gior...@gmail.com wrote: I should have add that in

Re: Where to SET SQL_BIG_SELECTS=1 in cakephp

2008-12-26 Thread raphaele.gior...@gmail.com
Hello, i have the same error and would be interested to know where you set thoses parameters i you found out Thanks Raphaele On Dec 23, 3:20 pm, eMarcus marcus.er...@gmail.com wrote: Hi, As my database hoster seems to have set the limit for no of joins relativly low, I need to set the SQL

Re: Where to SET SQL_BIG_SELECTS=1 in cakephp

2008-12-26 Thread raphaele.gior...@gmail.com
I should have add that in emergency you can add line 129 of \cake\libs \model\db_acl.php that line to solve your pb $db-query('SET SQL_BIG_SELECTS=1'); i'm looking for a correct way of doing it ! On Dec 23, 3:20 pm, eMarcus marcus.er...@gmail.com wrote: Hi, As my database hoster seems to

Where to SET SQL_BIG_SELECTS=1 in cakephp

2008-12-23 Thread eMarcus
Hi, As my database hoster seems to have set the limit for no of joins relativly low, I need to set the SQL system variable SQL_BIG_SELECTS to on. Otherwise, CakePHP does not work here (especially authentication/ACL check does not work). Where is the best place to set SQL systems variables in