ErrorException

HTTP 500 Whoops, looks like something went wrong.

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

Exception

ErrorException

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.     }
  9.     //forget cache by tables names
  10.     if ($cache_queries && !empty($tables) && $action && in_array($action, ['insert', 'update', 'insertodku', 'delete'])) {
  11.         $tables = is_array($tables) ? $tables : [$tables];
HandleExceptions->handleError(2, 'mysqli::query(): (HY000/3): Error writing file \'/tmp/MYfd=247\' (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');
  3.         error_reporting(E_ALL);
  5.         set_error_handler(function ($level, $message, $file = '', $line = 0) {
  6.             $this->handleError($level, $message, $file, $line);
  7.         });
  9.         set_exception_handler(function ($e) {
  10.             $this->handleException($e);
  11.         });
HandleExceptions->Bootstrap\{closure}(2, 'mysqli::query(): (HY000/3): Error writing file \'/tmp/MYfd=247\' (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 distinct p.products_id from products_to_categories p2c, products_description pd, products p where p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name', '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), '4767955ec3c57a25bc3ebc824868f593' => object(mysqli_result), '12a437a0622f6b28b096998bed6293ee' => object(mysqli_result), '9ab07b4754a2c0fbb89244d1989f7363' => object(mysqli_result), 'bd3b7cc2d37ee2a2818b9dfc311434f7' => object(mysqli_result), '1b762b841913cddfc8b6da44559cec06' => object(mysqli_result), '6b8a1c6de3e11d5f486a6778ab33b7e1' => object(mysqli_result), '793531fdde696e64183c7677ba6ddb8d' => object(mysqli_result), 'b0136642ea4cd97c5c6ae17584f7ffe1' => object(mysqli_result), '2119e890f7b5a6ae8569583677d3ce17' => object(mysqli_result), 'c6868db5b642be73ca0cebb3b4f4f780' => object(mysqli_result), '72f32c43a8b60d38ea2fe86b2f106896' => object(mysqli_result), '5eea5d7515d5cae70a341eab52592b25' => object(mysqli_result), '868c77e161ec700236cdfbe97d21ba4b' => object(mysqli_result), '880598bc2c130fa4df7370ac3448eb56' => object(mysqli_result), '6c4a79455867de95e918cf4ef9d74339' => object(mysqli_result), 'dca0eccea4166662b2562cef3b6d1c24' => object(mysqli_result), '202eb2d8cc9c4b6425f23c07baac6fdb' => object(mysqli_result)), 'query_counts' => 23, 'query_total_time' => 0.48000000000000004, 'start' => 1768840217.072391, 'queryHash' => '770e99a91fcca0832af787c1058838bf'))
mysqli->query('select distinct p.products_id from products_to_categories p2c, products_description pd, products p where p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name') 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.     }
  9.     //forget cache by tables names
  10.     if ($cache_queries && !empty($tables) && $action && in_array($action, ['insert', 'update', 'insertodku', 'delete'])) {
  11.         $tables = is_array($tables) ? $tables : [$tables];
tep_db_query('select distinct p.products_id from products_to_categories p2c, products_description pd, products p where p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name') in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/general.php (line 39)
  1. function tep_get_all_sql_products_ids($listing_sql)
  2. {
  3.     return FileCacheHelper::remember(
  4.         md5($listing_sql) . '_' . __METHOD__,
  5.         fn() => array_column(
  6.             tep_db_query($listing_sql)->fetch_all(MYSQLI_ASSOC),
  7.             'products_id'
  8.         ),
  9.         60 * 60
  10.     );
  11. }
{closure}() in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/app/Classes/Cache/Helpers/FileCacheHelper.php (line 166)
  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('770e99a91fcca0832af787c1058838bf_tep_get_all_sql_products_ids', object(Closure), 3600) in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/general.php (line 42)
  1.         md5($listing_sql) . '_' . __METHOD__,
  2.         fn() => array_column(
  3.             tep_db_query($listing_sql)->fetch_all(MYSQLI_ASSOC),
  4.             'products_id'
  5.         ),
  6.         60 * 60
  7.     );
  8. }
  10. function tep_get_all_pids_price_exclude($listing_sql, $excluded_statement)
  11. {
tep_get_all_sql_products_ids('select distinct p.products_id from products_to_categories p2c, products_description pd, products p where p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name') in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/general.php (line 50)
  2. function tep_get_all_pids_price_exclude($listing_sql, $excluded_statement)
  3. {
  4.     $cleared_listing_sql = str_replace($excluded_statement, '', $listing_sql);
  6.     return tep_get_all_sql_products_ids($cleared_listing_sql);
  7. }
  9. function tep_get_query_products_info($listing_sql, $limit = 10)
  10. {
  11.     global $languages_id, $customer_price, $listing_add_fields, $spec_array, $all_pids;
tep_get_all_pids_price_exclude('select distinct p.products_id from products_to_categories p2c, products_description pd, products p where p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name', '') in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/index.php (line 338)
  2.         $listing_sql_raw = $listing_sql;
  3.         // split query to 2 small queries: 1) find all products ids, 2) get info for each product
  5.         //products ids for filters
  6.         $pids_price_filter_excluded = tep_get_all_pids_price_exclude($listing_sql, $price_filter_statement);
  8.         //products ids for filters
  9.         $pids_filter_excluded = tep_get_all_pids_price_exclude($listing_sql, str_replace($price_filter_statement, '', $where_filters)) ?: [0];
  11.         //products ids for attributes

Stack Trace

ErrorException 
ErrorException:
mysqli::query(): (HY000/3): Error writing file '/tmp/MYfd=247' (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=247\' (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=247\' (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 distinct p.products_id                                 from products_to_categories p2c,                                      products_description pd,                                      products p                                                                                                            where                                                                                                                                                         p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and                                      p.products_status = 1                                  and p.products_id = p2c.products_id                                  and pd.products_id = p2c.products_id                                  and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name', '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), '4767955ec3c57a25bc3ebc824868f593' => object(mysqli_result), '12a437a0622f6b28b096998bed6293ee' => object(mysqli_result), '9ab07b4754a2c0fbb89244d1989f7363' => object(mysqli_result), 'bd3b7cc2d37ee2a2818b9dfc311434f7' => object(mysqli_result), '1b762b841913cddfc8b6da44559cec06' => object(mysqli_result), '6b8a1c6de3e11d5f486a6778ab33b7e1' => object(mysqli_result), '793531fdde696e64183c7677ba6ddb8d' => object(mysqli_result), 'b0136642ea4cd97c5c6ae17584f7ffe1' => object(mysqli_result), '2119e890f7b5a6ae8569583677d3ce17' => object(mysqli_result), 'c6868db5b642be73ca0cebb3b4f4f780' => object(mysqli_result), '72f32c43a8b60d38ea2fe86b2f106896' => object(mysqli_result), '5eea5d7515d5cae70a341eab52592b25' => object(mysqli_result), '868c77e161ec700236cdfbe97d21ba4b' => object(mysqli_result), '880598bc2c130fa4df7370ac3448eb56' => object(mysqli_result), '6c4a79455867de95e918cf4ef9d74339' => object(mysqli_result), 'dca0eccea4166662b2562cef3b6d1c24' => object(mysqli_result), '202eb2d8cc9c4b6425f23c07baac6fdb' => object(mysqli_result)), 'query_counts' => 23, 'query_total_time' => 0.48000000000000004, 'start' => 1768840217.072391, 'queryHash' => '770e99a91fcca0832af787c1058838bf'))
  at mysqli->query('select distinct p.products_id                                 from products_to_categories p2c,                                      products_description pd,                                      products p                                                                                                            where                                                                                                                                                         p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and                                      p.products_status = 1                                  and p.products_id = p2c.products_id                                  and pd.products_id = p2c.products_id                                  and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/database.php:92)
  at tep_db_query('select distinct p.products_id                                 from products_to_categories p2c,                                      products_description pd,                                      products p                                                                                                            where                                                                                                                                                         p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and                                      p.products_status = 1                                  and p.products_id = p2c.products_id                                  and pd.products_id = p2c.products_id                                  and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/general.php:39)
  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('770e99a91fcca0832af787c1058838bf_tep_get_all_sql_products_ids', object(Closure), 3600)
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/general.php:42)
  at tep_get_all_sql_products_ids('select distinct p.products_id                                 from products_to_categories p2c,                                      products_description pd,                                      products p                                                                                                            where                                                                                                                                                         p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and                                      p.products_status = 1                                  and p.products_id = p2c.products_id                                  and pd.products_id = p2c.products_id                                  and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/general.php:50)
  at tep_get_all_pids_price_exclude('select distinct p.products_id                                 from products_to_categories p2c,                                      products_description pd,                                      products p                                                                                                            where                                                                                                                                                         p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and                                      p.products_status = 1                                  and p.products_id = p2c.products_id                                  and pd.products_id = p2c.products_id                                  and pd.language_id = \'3\' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name', '')
     (/var/www/roverhub_com_usr/data/www/roverhub.com.ua/index.php:338)
{"errno":3,"error":"Error writing file '\/tmp\/MYfd=247' (OS errno 28 - No space left on device)","query":"select distinct p.products_id\n from products_to_categories p2c,\n products_description pd,\n products p\n \n \n where \n \n \n \n p2c.categories_id in(209,228,230,229,221,223,222,218,220,219,215,217,216,224,226,225,212,214,213,210,211,227,231,268,286,287,292,291,289,288,290,280,382,285,284,283,281,282,269,279,273,274,276,278,277,275,271,272,318,296,297,300,299,298,307,308,305,309,304,310,315,316,314,313,312,311,306,317,302,301,303,361,240,248,246,241,244,245,247,242,243,362,319,325,324,323,322,321,320,249,259,255,258,256,257,252,253,254,262,250,251,260,261,267,234,239,238,237,236,235,263,265,264,293,295,294,208,232,233,266,207,206) and\n p.products_status = 1\n and p.products_id = p2c.products_id\n and pd.products_id = p2c.products_id\n and pd.language_id = '3' order by p.products_quantity > 0 desc, p.products_sort_order, pd.products_name","SERVER_NAME":"roverhub.com.ua","REMOTE_ADDR":"216.73.216.49","HTTP_REFERER":null,"REQUEST_URI":"\/ru\/komponenty\/c-206.html?page=4"}