than that is no longer a MySQL question and you should consult
the guy who wrote the code, there are reasons for such limits
and blindly disable them may reuslt in the server going down
because you disable a barrier for crap code
Am 28.02.2014 12:53, schrieb Madan Thapa:
> Thank you , however i am
Thank you , however i am newbie to mysql and not sure where to put that (
SET SQL_BIG_SELECTS=1;) :
when i grep , i see following files for example that has query code:
[root@server public_html]# grep -R "SELECT filename" . | grep -v error_lo
./sites/all/modules/views/includes/admin.inc:
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 supported or you have a t
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_SELECTS=1 or SET MAX_JOIN_
