List:General Discussion« Previous MessageNext Message »
From:Madan Thapa Date:February 28 2014 11:53am
Subject:Re: how to set "SET SQL_BIG_SELECTS=1" ?
View as plain text  
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.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*
>
>

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