mysqli::query(): (HY000/3): Error writing file '/tmp/MYfd=154' (OS errno 28 - No space left on device) (500 Whoops, looks like something went wrong.)

mysqli::query(): (HY000/3): Error writing file '/tmp/MYfd=154' (OS errno 28 - No space left on device)

Exception

ErrorException

  1.     $queryHash md5($query);
  2.     if (isset($queries[$queryHash]) && $queries[$queryHash] instanceof mysqli_result && $cache_queries) {
  3.         $result $queries[$queryHash];
  4.         $result->data_seek(0);
  5.     } else {
  6.         $queries[$queryHash] = $result DB()->query($query);
  7.     }
  8.     //forget cache by tables names
  9.     if ($cache_queries && !empty($tables) && $action && in_array($action, ['insert''update''insertodku''delete'])) {
  10.         $tables is_array($tables) ? $tables : [$tables];
HandleExceptions->handleError(2, 'mysqli::query(): (HY000/3): Error writing file \'/tmp/MYfd=154\' (OS errno 28 - No space left on device)', '/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/database.php', 92) in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/bootstrap/HandleExceptions.php (line 32)
  1.         //ini_set('error_log' , '/home/solomono/web/solomono.net/sites/dev/php.log');
  2.         error_reporting(E_ALL);
  3.         set_error_handler(function ($level$message$file ''$line 0) {
  4.             $this->handleError($level$message$file$line);
  5.         });
  6.         set_exception_handler(function ($e) {
  7.             $this->handleException($e);
  8.         });
HandleExceptions->Bootstrap\{closure}(2, 'mysqli::query(): (HY000/3): Error writing file \'/tmp/MYfd=154\' (OS errno 28 - No space left on device)', '/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/database.php', 92, array('query' => 'select products_options_id, products_options_name, products_options_length, products_options_comment, products_options_sort_order, products_options_type from products_options where language_id = \'5\' ORDER BY pag, products_options_sort_order, LPAD(REGEXP_SUBSTR(REPLACE(products_options_name, \' \', \'\'), \'^[0-9]+\'), 10, \'0\'), REPLACE(products_options_name, \' \', \'\') COLLATE utf8mb4_unicode_ci ASC', 'tables' => array(), 'action' => false, 'cache_queries' => true, 'queries' => array('d0db508d5f374498761783b079c41051' => object(mysqli_result), '41d2deb682aae4a129b6cbbd7901b482' => object(mysqli_result), '8d36dceb7ec0a533ce4d8db21023dd7d' => object(mysqli_result), '1e1a4e94aede0448fbe50d6900069c16' => object(mysqli_result), '1b6e6faf8354ef39831491a2ade01b07' => object(mysqli_result), '10ce500110c3f6d7a49a46e53b99f57c' => object(mysqli_result), '64ba7381ddeed7576f2b74b341ad3391' => object(mysqli_result), '9ab07b4754a2c0fbb89244d1989f7363' => object(mysqli_result), 'bd3b7cc2d37ee2a2818b9dfc311434f7' => object(mysqli_result), '7a5a1399ab04a714a3378fbfe4686d65' => object(mysqli_result), '9345241fc0ffd62144f2d0b17f70771d' => object(mysqli_result), '793531fdde696e64183c7677ba6ddb8d' => object(mysqli_result), 'b0136642ea4cd97c5c6ae17584f7ffe1' => object(mysqli_result), '09bef5352992d47499e4494de3aaa8c1' => object(mysqli_result), 'c6868db5b642be73ca0cebb3b4f4f780' => object(mysqli_result), '150751247be95c1d170fd0a247376434' => object(mysqli_result), '6c4a79455867de95e918cf4ef9d74339' => object(mysqli_result), 'dca0eccea4166662b2562cef3b6d1c24' => object(mysqli_result), 'c577f8b98f3d7b6d1294a104c5ad76cd' => object(mysqli_result), '1bd91dc2a73b0aadedd0d72aa4e931cf' => object(mysqli_result), 'e7777afb7faff6ce4bd90791073715f9' => object(mysqli_result), 'f8b2838e00e24121b8c9ac6b87a469ac' => object(mysqli_result), 'bd202ba1b342a0ede7fe6ce5a60b1f82' => object(mysqli_result), '21a7f987c68d98d0d38c5ec354f8880c' => object(mysqli_result), '4e900e7f68e27ff7c7d45718abdad467' => object(mysqli_result), '946fe0cb6747226f29d6983823325948' => object(mysqli_result), 'add374c0554634689c7501e5cb9d0251' => object(mysqli_result), '078710e532185e05df82ede2d02e2375' => object(mysqli_result), '738d9d4d645dbcc81883c6be6cf38820' => object(mysqli_result), '0dd60040f55cc4ac21b5d33e74fb82a3' => object(mysqli_result)), 'query_counts' => 30, 'query_total_time' => 0.3, 'start' => 1773740167.050243, 'queryHash' => '99650ca65b8e2ea550a933a8a11d9763'))
mysqli->query('select products_options_id, products_options_name, products_options_length, products_options_comment, products_options_sort_order, products_options_type from products_options where language_id = \'5\' ORDER BY pag, products_options_sort_order, LPAD(REGEXP_SUBSTR(REPLACE(products_options_name, \' \', \'\'), \'^[0-9]+\'), 10, \'0\'), REPLACE(products_options_name, \' \', \'\') COLLATE utf8mb4_unicode_ci ASC') in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/database.php (line 92)
  1.     $queryHash md5($query);
  2.     if (isset($queries[$queryHash]) && $queries[$queryHash] instanceof mysqli_result && $cache_queries) {
  3.         $result $queries[$queryHash];
  4.         $result->data_seek(0);
  5.     } else {
  6.         $queries[$queryHash] = $result DB()->query($query);
  7.     }
  8.     //forget cache by tables names
  9.     if ($cache_queries && !empty($tables) && $action && in_array($action, ['insert''update''insertodku''delete'])) {
  10.         $tables is_array($tables) ? $tables : [$tables];
tep_db_query('select products_options_id, products_options_name, products_options_length, products_options_comment, products_options_sort_order, products_options_type from products_options where language_id = \'5\' ORDER BY pag, products_options_sort_order, LPAD(REGEXP_SUBSTR(REPLACE(products_options_name, \' \', \'\'), \'^[0-9]+\'), 10, \'0\'), REPLACE(products_options_name, \' \', \'\') COLLATE utf8mb4_unicode_ci ASC') in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/attributes.php (line 206)
  1.         $attributesOptionsBuffer FileCacheHelper::remember(
  2.             FileCacheHelper::PRODUCTS_OPTIONS_KEY '_language(' $languagesId ')',
  3.             function() use ($languagesId) {
  4.                 $query tep_db_query("select products_options_id, products_options_name, products_options_length, products_options_comment, products_options_sort_order, products_options_type
  5.                                from " TABLE_PRODUCTS_OPTIONS 
  6.                                where language_id = '{$languagesId}'
  7.                                ORDER BY pag,  products_options_sort_order, 
  8.                                LPAD(REGEXP_SUBSTR(REPLACE(products_options_name, ' ', ''), '^[0-9]+'), 10, '0'), REPLACE(products_options_name, ' ', '') COLLATE utf8mb4_unicode_ci ASC");
  9.                 $i 0;
  10.                 $attributesOptions = [];
  11.                 while ($row tep_db_fetch_array($query)) {
  1.                         $key,
  2.                         $ttl,
  3.                         $closure
  4.                     );
  5.             } else {
  6.                 return $closure();
  7.             }
  8.         } catch (\Exception $exception) {
  9.             Log::critical($exception->getMessage(), [
  10.                 'driver' => 'file'
  11.             ]);
FileCacheHelper::remember('products_options_language(5)', object(Closure), null) in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/attributes.php (line 219)
  1.                     $row['show_in_product_listing'] = (bool)$row['products_options_comment'] == '1';
  2.                     $attributesOptions[$row['products_options_id']] = $row;
  3.                 }
  4.                 return $attributesOptions;
  5.             },
  6.             null
  7.         );
  8.     }
  9.     return $attributesOptionsBuffer ?: [];
  10. }
  1.     $languagesId $languagesId ?: \language::get()->language['id'];
  2.     $useCache = !isset($_GET["filter_id"]) && !$force;
  3.     if ($useCache) {
  4.         foreach (getAttributesOptions($languagesId$force) as $attributeOption) {
  5.             if (isset($_GET[$attributeOption['products_options_id']])) {
  6.                 $useCache false;
  7.             }
  8.         }
  9.     }
  1.     $salemakers_array get_salemakers($specials);
  2.     mysqli_data_seek($specials0);
  3.     if ($specials->num_rows and $tpl_settings['disable_listing'] != true) {
  4.         $tpl_settings['request'] = $specials;
  5.         getArrayWithAllAttributes();
  6.         include(DIR_WS_MODULES FILENAME_PRODUCT_LISTING_COL);
  7.     }
  8. }
include('/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/modules/default_specials.php') in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/boxes/mainpage_modules/default_specials.php (line 34)
  1.             'MAINPAGE',
  2.             'M_DEFAULT_SPECIALS',
  3.             'content_width'
  4.         ) ? 'container' 'container-fluid') . '">';
  5.     }
  6.     include(DIR_WS_MODULES 'default_specials.php');
  7.     if (!$template->getMainconf('MC_SHOW_LEFT_COLUMN') || isMobile()) {
  8.         echo '</div>';
  9.     }
  10. }
  11. if ($module_is_ajax && !isset($_POST['render'])) {
require_once('/var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/boxes/mainpage_modules/default_specials.php') in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/content/index_default.tpl.php (line 6)
  1. <?php
  2. foreach ($template->settings['MAINPAGE'] as $const => $arr) {
  3.     if ($file $template->getFiles('MAINPAGE'$const$config)) {
  4.         if (file_exists($file)) {
  5.             require_once $file;
  6.         }
  7.     }
  8. }
require('/var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/content/index_default.tpl.php') in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/main_page.tpl.php (line 107)
  1.             <?php echo $breadcrumb->trail(' '); ?>
  2.             <!-- END BREADCRUMBS -->
  3.             <!-- CONTENT -->
  4.             <?php
  5.             if (file_exists(DIR_WS_TEMPLATES TEMPLATE_NAME '/content/' $content '.tpl.php')) {
  6.                 require(DIR_WS_TEMPLATES TEMPLATE_NAME '/content/' $content '.tpl.php'); // content from current template (if exists)
  7.             } else {
  8.                 require(DIR_WS_CONTENT $content '.tpl.php'); // content from default template
  9.             }
  10.             ?>
  11.             <!-- END CONTENT -->
require('/var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/main_page.tpl.php') in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/index.php (line 512)
  1. }
  2. if ($_SERVER['HTTP_X_REQUESTED_WITH'] == 'XMLHttpRequest') {
  3.     require(DIR_WS_MODULES FILENAME_PRODUCT_LISTING_COL);
  4. } else {
  5.     require(DIR_WS_TEMPLATES TEMPLATE_NAME '/' TEMPLATENAME_MAIN_PAGE);
  6. }
  7. require(DIR_WS_INCLUDES 'application_bottom.php');

Stack Trace

ErrorException
ErrorException:
mysqli::query(): (HY000/3): Error writing file '/tmp/MYfd=154' (OS errno 28 - No space left on device)

  at /var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/database.php:92
  at Bootstrap\HandleExceptions->handleError(2, 'mysqli::query(): (HY000/3): Error writing file \'/tmp/MYfd=154\' (OS errno 28 - No space left on device)', '/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/database.php', 92)
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/bootstrap/HandleExceptions.php:32)
  at Bootstrap\HandleExceptions->Bootstrap\{closure}(2, 'mysqli::query(): (HY000/3): Error writing file \'/tmp/MYfd=154\' (OS errno 28 - No space left on device)', '/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/database.php', 92, array('query' => 'select products_options_id, products_options_name, products_options_length, products_options_comment, products_options_sort_order, products_options_type                               from products_options                                where language_id = \'5\'                               ORDER BY pag,  products_options_sort_order,                                LPAD(REGEXP_SUBSTR(REPLACE(products_options_name, \' \', \'\'), \'^[0-9]+\'), 10, \'0\'), REPLACE(products_options_name, \' \', \'\') COLLATE utf8mb4_unicode_ci ASC', 'tables' => array(), 'action' => false, 'cache_queries' => true, 'queries' => array('d0db508d5f374498761783b079c41051' => object(mysqli_result), '41d2deb682aae4a129b6cbbd7901b482' => object(mysqli_result), '8d36dceb7ec0a533ce4d8db21023dd7d' => object(mysqli_result), '1e1a4e94aede0448fbe50d6900069c16' => object(mysqli_result), '1b6e6faf8354ef39831491a2ade01b07' => object(mysqli_result), '10ce500110c3f6d7a49a46e53b99f57c' => object(mysqli_result), '64ba7381ddeed7576f2b74b341ad3391' => object(mysqli_result), '9ab07b4754a2c0fbb89244d1989f7363' => object(mysqli_result), 'bd3b7cc2d37ee2a2818b9dfc311434f7' => object(mysqli_result), '7a5a1399ab04a714a3378fbfe4686d65' => object(mysqli_result), '9345241fc0ffd62144f2d0b17f70771d' => object(mysqli_result), '793531fdde696e64183c7677ba6ddb8d' => object(mysqli_result), 'b0136642ea4cd97c5c6ae17584f7ffe1' => object(mysqli_result), '09bef5352992d47499e4494de3aaa8c1' => object(mysqli_result), 'c6868db5b642be73ca0cebb3b4f4f780' => object(mysqli_result), '150751247be95c1d170fd0a247376434' => object(mysqli_result), '6c4a79455867de95e918cf4ef9d74339' => object(mysqli_result), 'dca0eccea4166662b2562cef3b6d1c24' => object(mysqli_result), 'c577f8b98f3d7b6d1294a104c5ad76cd' => object(mysqli_result), '1bd91dc2a73b0aadedd0d72aa4e931cf' => object(mysqli_result), 'e7777afb7faff6ce4bd90791073715f9' => object(mysqli_result), 'f8b2838e00e24121b8c9ac6b87a469ac' => object(mysqli_result), 'bd202ba1b342a0ede7fe6ce5a60b1f82' => object(mysqli_result), '21a7f987c68d98d0d38c5ec354f8880c' => object(mysqli_result), '4e900e7f68e27ff7c7d45718abdad467' => object(mysqli_result), '946fe0cb6747226f29d6983823325948' => object(mysqli_result), 'add374c0554634689c7501e5cb9d0251' => object(mysqli_result), '078710e532185e05df82ede2d02e2375' => object(mysqli_result), '738d9d4d645dbcc81883c6be6cf38820' => object(mysqli_result), '0dd60040f55cc4ac21b5d33e74fb82a3' => object(mysqli_result)), 'query_counts' => 30, 'query_total_time' => 0.3, 'start' => 1773740167.050243, 'queryHash' => '99650ca65b8e2ea550a933a8a11d9763'))
  at mysqli->query('select products_options_id, products_options_name, products_options_length, products_options_comment, products_options_sort_order, products_options_type                               from products_options                                where language_id = \'5\'                               ORDER BY pag,  products_options_sort_order,                                LPAD(REGEXP_SUBSTR(REPLACE(products_options_name, \' \', \'\'), \'^[0-9]+\'), 10, \'0\'), REPLACE(products_options_name, \' \', \'\') COLLATE utf8mb4_unicode_ci ASC')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/database.php:92)
  at tep_db_query('select products_options_id, products_options_name, products_options_length, products_options_comment, products_options_sort_order, products_options_type                               from products_options                                where language_id = \'5\'                               ORDER BY pag,  products_options_sort_order,                                LPAD(REGEXP_SUBSTR(REPLACE(products_options_name, \' \', \'\'), \'^[0-9]+\'), 10, \'0\'), REPLACE(products_options_name, \' \', \'\') COLLATE utf8mb4_unicode_ci ASC')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/attributes.php:206)
  at {closure}()
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/app/Classes/Cache/Helpers/FileCacheHelper.php:166)
  at App\Classes\Cache\Helpers\FileCacheHelper::remember('products_options_language(5)', object(Closure), null)
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/attributes.php:219)
  at getAttributesOptions('5', false)
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/attributes.php:387)
  at getArrayWithAllAttributes()
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/modules/default_specials.php:45)
  at include('/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/modules/default_specials.php')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/boxes/mainpage_modules/default_specials.php:34)
  at require_once('/var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/boxes/mainpage_modules/default_specials.php')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/content/index_default.tpl.php:6)
  at require('/var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/content/index_default.tpl.php')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/main_page.tpl.php:107)
  at require('/var/www/roverhub_com_usr/data/www/roverhub.com.ua/templates/default/main_page.tpl.php')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/index.php:512)                
{"errno":3,"error":"Error writing file '\/tmp\/MYfd=154' (OS errno 28 - No space left on device)","query":"select products_options_id, products_options_name, products_options_length, products_options_comment, products_options_sort_order, products_options_type\n from products_options \n where language_id = '5'\n ORDER BY pag, products_options_sort_order, \n LPAD(REGEXP_SUBSTR(REPLACE(products_options_name, ' ', ''), '^[0-9]+'), 10, '0'), REPLACE(products_options_name, ' ', '') COLLATE utf8mb4_unicode_ci ASC","SERVER_NAME":"roverhub.com.ua","REMOTE_ADDR":"216.73.216.103","HTTP_REFERER":null,"REQUEST_URI":"\/"}