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" wrote: > I should have add that in emergency you can add lin

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" wrote: > I should have add that in emergency you can add lin

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 wrote: > Hi, > > As my database hoster seems to havesetthe limit for no

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 wrote: > Hi, > > As my database hoster seems to have set the limit for no of joins > relativly low, I need to set the SQL system variableSQL_BI

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 Cak