Re: how to set "SET SQL_BIG_SELECTS=1" ?

2014-02-28 Thread Reindl Harald
ot;, > $type); > > ./includes/bootstrap.inc: elseif (db_is_active() && (($file = > db_result(db_query("SELECT filename FROM {system} WHERE name = '%s' AND > type = '%s'", $name, $type))) && file_exists($file))) { > > On Fri, Feb 2

Re: how to set "SET SQL_BIG_SELECTS=1" ?

2014-02-28 Thread Madan Thapa
RE name = '%s' AND type = '%s'", $name, $type))) && file_exists($file))) { [root@server public_html]# please advise. thanks On Fri, Feb 28, 2014 at 4:57 PM, Reindl Harald wrote: > > Am 28.02.2014 12:17, schrieb Madan Thapa: > > > After up

Re: how to set "SET SQL_BIG_SELECTS=1" ?

2014-02-28 Thread Reindl Harald
Am 28.02.2014 12:17, schrieb Madan Thapa: > After upgrading from mysql 5.0 to mysql 5.1, i am getting the follwing > error: > > how to set "SET SQL_BIG_SELECTS=1"? just type it before your query in question? as you can see below if you try such things and they are not s

how to set "SET SQL_BIG_SELECTS=1" ?

2014-02-28 Thread Madan Thapa
Dear all, After upgrading from mysql 5.0 to mysql 5.1, i am getting the follwing error: how to set "SET SQL_BIG_SELECTS=1" ? Error is *Warning*: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECT