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.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*
signature.asc
Description: OpenPGP digital signature
