List:General Discussion« Previous MessageNext Message »
From:Madan Thapa Date:February 28 2014 11:17am
Subject:how to set "SET SQL_BIG_SELECTS=1" ?
View as plain text  
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_SIZE=# if the
SELECT is okay query: drupal_get_filename /* Guest : drupal_get_filename */
SELECT filename FROM system WHERE name = 'user' AND type = 'module' in
*/home/User/public_html/includes/database.mysql.inc* on line *136*

*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_SIZE=# if the
SELECT is okay query: drupal_lookup_path /* Guest : drupal_lookup_path */
SELECT src FROM url_alias WHERE dst = 'welcome' AND language IN('en', '')
ORDER BY language DESC, pid DESC in
*/home/User/public_html/includes/database.mysql.inc* on line *136*

*Fatal error*: Call to undefined function filter_xss_admin() in
*/home/User/public_html/includes/common.inc* on line
*369*##############################


Thank you

Thread
how to set "SET SQL_BIG_SELECTS=1" ?Madan Thapa28 Feb 2014
  • Re: how to set "SET SQL_BIG_SELECTS=1" ?Reindl Harald28 Feb 2014
    • Re: how to set "SET SQL_BIG_SELECTS=1" ?Madan Thapa28 Feb 2014
      • Re: how to set "SET SQL_BIG_SELECTS=1" ?Reindl Harald28 Feb 2014