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 typo you get a crear error, otherwise OK MariaDB [(none)]> SET SQL_BIG_SELECTS=1; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> SET SQL_BIG_SELEtCTS=1; ERROR 1193 (HY000): Unknown system variable 'SQL_BIG_SELEtCTS' > *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*
signature.asc
Description: OpenPGP digital signature