List:General Discussion« Previous MessageNext Message »
From:Reindl Harald Date:February 28 2014 12:02pm
Subject:Re: how to set "SET SQL_BIG_SELECTS=1" ?
View as plain text  
than that is no longer a MySQL question and you should consult
the guy who wrote the code, there are reasons for such limits
and blindly disable them may reuslt in the server going down
because you disable a barrier for crap code

Am 28.02.2014 12:53, schrieb Madan Thapa:
> 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))) {
> 
> On Fri, Feb 28, 2014 at 4:57 PM, Reindl Harald <h.reindl@stripped>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*


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
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