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: $filename = db_result(db_query("SELECT filename FROM {system} WHERE type = 'module' AND name = 'advanced_help'")); ./sites/all/modules/ubercart/docs/hooks.php: $filename = db_result(db_query("SELECT filename FROM {uc_files} WHERE fid = %d", $file_id)); ./sites/all/modules/ubercart/uc_file/uc_file.module: $files = db_query("SELECT filename FROM {uc_files} WHERE filename LIKE LOWER('%s')", '%'. strtolower($url[1]) .'%'); ./sites/all/modules/ubercart/uc_file/uc_file.module: $filename = db_result(db_query("SELECT filename FROM {uc_files} WHERE fid = %d", $fid)); ./sites/all/ubercart/docs/hooks.php: $filename = db_result(db_query("SELECT filename FROM {uc_files} WHERE fid = %d", $file_id)); ./sites/all/ubercart/uc_file/uc_file.module: $files = db_query("SELECT filename FROM {uc_files} WHERE filename LIKE LOWER('%s')", '%'. strtolower($url[1]) .'%'); ./sites/all/ubercart/uc_file/uc_file.module: $filename = db_result(db_query("SELECT filename FROM {uc_files} WHERE fid = %d", $fid)); ./modules/system/system.module: $result = db_query("SELECT filename, name, type, status, throttle, schema_version FROM {system} WHERE type = '%s'", $type); ./includes/bootstrap.inc: elseif (db_is_active() && (($file = db_result(db_query("SELECT filename FROM {system} WHERE name = '%s' AND type = '%s'", $name, $type))) && file_exists($file))) { [root@server public_html]# please advise. thanks On Fri, Feb 28, 2014 at 4:57 PM, Reindl Harald <h.rei...@thelounge.net>wrote: > > 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* > >