$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]; //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); }); $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]; $attributesOptionsBuffer = FileCacheHelper::remember( FileCacheHelper::PRODUCTS_OPTIONS_KEY . '_language(' . $languagesId . ')', function() use ($languagesId) { $query = tep_db_query("select products_options_id, products_options_name, products_options_length, products_options_comment, products_options_sort_order, products_options_type from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '{$languagesId}' 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"); $i = 0; $attributesOptions = []; while ($row = tep_db_fetch_array($query)) { $key, $ttl, $closure ); } else { return $closure(); } } catch (\Exception $exception) { Log::critical($exception->getMessage(), [ 'driver' => 'file' ]); $row['show_in_product_listing'] = (bool)$row['products_options_comment'] == '1'; $attributesOptions[$row['products_options_id']] = $row; } return $attributesOptions; }, null ); } return $attributesOptionsBuffer ?: [];} $languagesId = $languagesId ?: \language::get()->language['id']; $useCache = !isset($_GET["filter_id"]) && !$force; if ($useCache) { foreach (getAttributesOptions($languagesId, $force) as $attributeOption) { if (isset($_GET[$attributeOption['products_options_id']])) { $useCache = false; } } }$counts_array = array();$counts_may_be = array(); // array with all selected attributes$show_options_arr = [];if ($content != CONTENT_INDEX_DEFAULT) { getArrayWithAllAttributes(); $attributesOptionsNames = getAttributesOptionsField('products_options_name'); $attributesValuesNames = getAttributesValuesField('name');}$options_string = generateOptionsString($attributesOptionsNames, $attributesValuesNames);if (!empty($options_string)) {|
ErrorException
|
|---|
ErrorException:
mysqli::query(): (HY000/3): Error writing file '/tmp/MYfd=186' (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=186\' (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=186\' (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 = \'3\' 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), '69ea5fc56e34c2eb7f2029f4a7301aa9' => object(mysqli_result), 'cee6108b43ae2a60def00cb6a3d30af8' => 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), 'c598d5f4526aa28ba94ef0f3af3746e5' => object(mysqli_result), '880598bc2c130fa4df7370ac3448eb56' => object(mysqli_result), '6c4a79455867de95e918cf4ef9d74339' => object(mysqli_result), 'dca0eccea4166662b2562cef3b6d1c24' => object(mysqli_result), '2a79c16119adbeea2160550114862577' => object(mysqli_result), '68beaba7b00c957ac8fd1e7062882855' => object(mysqli_result), 'add374c0554634689c7501e5cb9d0251' => object(mysqli_result), '350d420137c8cdecdb2e255fe66406e4' => object(mysqli_result), 'd5e7c8755833d5fd5070b4865253a65b' => object(mysqli_result)), 'query_counts' => 31, 'query_total_time' => 0.31999999999999995, 'start' => 1768835193.685614, 'queryHash' => 'ad17515dcc78823cd124cdf1efa904d1'))
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 = \'3\' 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 = \'3\' 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(3)', object(Closure), null)
(/var/www/roverhub_com_usr/data/www/roverhub.com.ua/includes/functions/attributes.php:219)
at getAttributesOptions('3', 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/index.php:488)
|