$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=242' (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=242\' (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=242\' (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), '8e8eef1ca6fde502bb9b22f1bc187279' => object(mysqli_result), '86eb1b59694421b55378ef4e4e5748e9' => 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), '72f32c43a8b60d38ea2fe86b2f106896' => object(mysqli_result), '5eea5d7515d5cae70a341eab52592b25' => object(mysqli_result), '6728238a5291f2eafcc8a250d9dba102' => object(mysqli_result), '150751247be95c1d170fd0a247376434' => object(mysqli_result), '6c4a79455867de95e918cf4ef9d74339' => object(mysqli_result), 'dca0eccea4166662b2562cef3b6d1c24' => object(mysqli_result), 'e84ce67df8da5c7962b22604778ce576' => object(mysqli_result), 'b12842d2973a3e03563d9d107b5ed34e' => object(mysqli_result), 'add374c0554634689c7501e5cb9d0251' => object(mysqli_result), 'a029ce49abf8849cc901c2cdf9c96238' => object(mysqli_result), '05fe4bf22973d12060bf063fcbce8ed4' => object(mysqli_result)), 'query_counts' => 31, 'query_total_time' => 0.3400000000000001, 'start' => 1768839747.1141, '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/index.php:488)
|