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
Feb 28
Reindl Harald Re: how to set "SET SQL_BIG_SELECTS=1" ?
Feb 28, 2014; 12:27
Reindl Harald
Re: how to set "SET SQL_BIG_SELECTS=1" ?
Feb 28
Madan Thapa Re: how to set "SET SQL_BIG_SELECTS=1" ?
Feb 28, 2014; 17:23
Madan Thapa
Re: how to set "SET SQL_BIG_SELECTS=1" ?
Feb 28
Reindl Harald Re: how to set "SET SQL_BIG_SELECTS=1" ?
Feb 28, 2014; 13:02
Reindl Harald
Re: how to set "SET SQL_BIG_SELECTS=1" ?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!