My script states that the MAX_JOIN_SIZE setting in MySQL set to low. How do I increase it?

MySQL will refuse to execute select statements that process a very large number of rows. You should either adjust your select statement to make it more efficient, or set SQL_BIG_SELECTS=1 in the session before executing the large select statement. Use something like this to do that ..

$db->sql_query("SET OPTION SQL_BIG_SELECTS=1");

  • 76 Users Found This Useful
Was this answer helpful?

Related Articles

My PHP script gives the error 'Call to undefined function: mysql_connect()'

This error is usually caused by unecessary or incorrect directives in a custom php.ini file.We...

Possible issues with OSCommerce and MySQL5

We have been made aware that some customers may have issues with their OSCommerce installations...

I'm getting SQL errors on MySQL 5 saying it can't find a column - but it's there!

1054 - Unknown column 'a.c' in 'on clause'This can happen if you're doing something like:SELECT *...

I have software that requires MySQL 4 can this be provided instead of the current version.

MySQL 4 was less compliant with ANSI SQL - this was improved in version 5 and there are many...

Why am I getting a host blocked with 'mysqladmin flush-hosts' error?

Errors such as:-Host 'xxx.xxx.xxx.xxx' is blocked because of many connection errors; unblock with...