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

Exception

ErrorException

in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/database.php (line 92)

$queryHash = md5($query);
if (isset($queries[$queryHash]) && $queries[$queryHash] instanceof mysqli_result && $cache_queries) {
$result = $queries[$queryHash];
$result->data_seek(0);
} else {
$queries[$queryHash] = $result = DB()->query($query);
}
//forget cache by tables names
if ($cache_queries && !empty($tables) && $action && in_array($action, ['insert', 'update', 'insertodku', 'delete'])) {
$tables = is_array($tables) ? $tables : [$tables];

HandleExceptions->handleError(2, 'mysqli::query(): (HY000/3): Error writing file \'/tmp/MYfd=62\' (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)

//ini_set('error_log' , '/home/solomono/web/solomono.net/sites/dev/php.log');
error_reporting(E_ALL);
set_error_handler(function ($level, $message, $file = '', $line = 0) {
$this->handleError($level, $message, $file, $line);
});
set_exception_handler(function ($e) {
$this->handleException($e);
});

HandleExceptions->Bootstrap\{closure}(2, 'mysqli::query(): (HY000/3): Error writing file \'/tmp/MYfd=62\' (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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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), '05b258902f294d10beba1829e80a8143' => object(mysqli_result), '62bb4e3e3af79c6fe5e4b4cefd78d933' => object(mysqli_result), '9ab07b4754a2c0fbb89244d1989f7363' => object(mysqli_result), 'bd3b7cc2d37ee2a2818b9dfc311434f7' => object(mysqli_result), '1b762b841913cddfc8b6da44559cec06' => object(mysqli_result), 'ffeb0eefe6d3f4dc3557a4fd0daad9c8' => 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), '77c2bdaaacfb431a78961d05fb86e392' => object(mysqli_result), '880598bc2c130fa4df7370ac3448eb56' => object(mysqli_result), '6c4a79455867de95e918cf4ef9d74339' => object(mysqli_result), 'dca0eccea4166662b2562cef3b6d1c24' => object(mysqli_result), '9a55199707bbb4332b4aff56b4858d71' => object(mysqli_result)), 'query_counts' => 23, 'query_total_time' => 0.47000000000000003, 'start' => 1761569021.769514, 'queryHash' => '6161e45b45cefa19724aed2b69f13ae4'))

mysqli->query('select distinct p.products_id from products_to_categories p2c, products_description pd, products p where p2c.categories_id in(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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)

$queryHash = md5($query);
if (isset($queries[$queryHash]) && $queries[$queryHash] instanceof mysqli_result && $cache_queries) {
$result = $queries[$queryHash];
$result->data_seek(0);
} else {
$queries[$queryHash] = $result = DB()->query($query);
}
//forget cache by tables names
if ($cache_queries && !empty($tables) && $action && in_array($action, ['insert', 'update', 'insertodku', 'delete'])) {
$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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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)

function tep_get_all_sql_products_ids($listing_sql)
{
return FileCacheHelper::remember(
md5($listing_sql) . '_' . __METHOD__,
fn() => array_column(
tep_db_query($listing_sql)->fetch_all(MYSQLI_ASSOC),
'products_id'
),
60 * 60
);
}

{closure}() in /var/www/roverhub_com_usr/data/www/roverhub.com.ua/app/Classes/Cache/Helpers/FileCacheHelper.php (line 166)

$key,
$ttl,
$closure
);
} else {
return $closure();
}
} catch (\Exception $exception) {
Log::critical($exception->getMessage(), [
'driver' => 'file'
]);

FileCacheHelper::remember('6161e45b45cefa19724aed2b69f13ae4_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)

md5($listing_sql) . '_' . __METHOD__,
fn() => array_column(
tep_db_query($listing_sql)->fetch_all(MYSQLI_ASSOC),
'products_id'
),
60 * 60
);
}
function tep_get_all_pids_price_exclude($listing_sql, $excluded_statement)
{

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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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)

function tep_get_all_pids_price_exclude($listing_sql, $excluded_statement)
{
$cleared_listing_sql = str_replace($excluded_statement, '', $listing_sql);
return tep_get_all_sql_products_ids($cleared_listing_sql);
}
function tep_get_query_products_info($listing_sql, $limit = 10)
{
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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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 339)

$listing_sql_raw = $listing_sql;
// split query to 2 small queries: 1) find all products ids, 2) get info for each product
//products ids for filters
$pids_price_filter_excluded = tep_get_all_pids_price_exclude($listing_sql, $price_filter_statement);
//products ids for filters
$pids_filter_excluded = tep_get_all_pids_price_exclude($listing_sql, str_replace($price_filter_statement, '', $where_filters)) ?: [0];
//products ids for attributes

Stack Trace

ErrorException
ErrorException: mysqli::query(): (HY000/3): Error writing file '/tmp/MYfd=62' (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=62\' (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=62\' (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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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), '05b258902f294d10beba1829e80a8143' => object(mysqli_result), '62bb4e3e3af79c6fe5e4b4cefd78d933' => object(mysqli_result), '9ab07b4754a2c0fbb89244d1989f7363' => object(mysqli_result), 'bd3b7cc2d37ee2a2818b9dfc311434f7' => object(mysqli_result), '1b762b841913cddfc8b6da44559cec06' => object(mysqli_result), 'ffeb0eefe6d3f4dc3557a4fd0daad9c8' => 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), '77c2bdaaacfb431a78961d05fb86e392' => object(mysqli_result), '880598bc2c130fa4df7370ac3448eb56' => object(mysqli_result), '6c4a79455867de95e918cf4ef9d74339' => object(mysqli_result), 'dca0eccea4166662b2562cef3b6d1c24' => object(mysqli_result), '9a55199707bbb4332b4aff56b4858d71' => object(mysqli_result)), 'query_counts' => 23, 'query_total_time' => 0.47000000000000003, 'start' => 1761569021.769514, 'queryHash' => '6161e45b45cefa19724aed2b69f13ae4')) at mysqli->query('select distinct p.products_id from products_to_categories p2c, products_description pd, products p where p2c.categories_id in(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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('6161e45b45cefa19724aed2b69f13ae4_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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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:339)

ErrorException

ErrorException:
mysqli::query(): (HY000/3): Error writing file '/tmp/MYfd=62' (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=62\' (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=62\' (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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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), '05b258902f294d10beba1829e80a8143' => object(mysqli_result), '62bb4e3e3af79c6fe5e4b4cefd78d933' => object(mysqli_result), '9ab07b4754a2c0fbb89244d1989f7363' => object(mysqli_result), 'bd3b7cc2d37ee2a2818b9dfc311434f7' => object(mysqli_result), '1b762b841913cddfc8b6da44559cec06' => object(mysqli_result), 'ffeb0eefe6d3f4dc3557a4fd0daad9c8' => 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), '77c2bdaaacfb431a78961d05fb86e392' => object(mysqli_result), '880598bc2c130fa4df7370ac3448eb56' => object(mysqli_result), '6c4a79455867de95e918cf4ef9d74339' => object(mysqli_result), 'dca0eccea4166662b2562cef3b6d1c24' => object(mysqli_result), '9a55199707bbb4332b4aff56b4858d71' => object(mysqli_result)), 'query_counts' => 23, 'query_total_time' => 0.47000000000000003, 'start' => 1761569021.769514, 'queryHash' => '6161e45b45cefa19724aed2b69f13ae4'))
  at mysqli->query('select distinct p.products_id                                 from products_to_categories p2c,                                      products_description pd,                                      products p                                                                                                            where                                                                                                                                                         p2c.categories_id in(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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('6161e45b45cefa19724aed2b69f13ae4_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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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(55,65,63,57,62,64,66,56,59,58,60,61,22,24,25,23,26,27,29,33,32,31,34,30,28,35,37,45,53,52,47,50,49,46,54,39,51,44,48,36,43,40,41,38,42,21) 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:339)

ErrorException

HTTP 500 Whoops, looks like something went wrong.

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

Exception

ErrorException

Stack Trace