Nette\Database\DriverException #42000

SQLSTATE[42000]: Syntax error or access violation: 1139 Got error 'nothing to repeat at offset 0' from regexp search►

SQL

SELECT 
 t.id_transliteration as id, 
 b.book_abrev, 
 t.chapter, 
 l.transliteration, 
 l.line_number
FROM transliteration t
LEFT JOIN surface s ON s.id_transliteration = t.id_transliteration
LEFT JOIN line l ON l.id_surface = s.id_surface
LEFT JOIN book b on t.id_book = b.id_book
WHERE l.transliteration REGEXP ?

Source file

File: .../src/Database/DriverException.php:25

15: { 16: /** @var string */ 17: public $queryString; 18: 19: 20: /** 21: * @return static 22: */ 23: public static function from(\PDOException $src) 24: { 25: $e = new static($src->message, null, $src); 26: if (!$src->errorInfo && preg_match('#SQLSTATE\[(.*?)\] \[(.*?)\] (.*)#A', $src->message, $m)) { 27: $m[2] = (int) $m[2]; 28: $e->errorInfo = array_slice($m, 1); 29: $e->code = $m[1];

Call stack

  1. .../src/Database/Drivers/MySqlDriver.php:66 source  Nette\Database\DriverException::from(arguments)

    56: } elseif (in_array($code, [1062, 1557, 1569, 1586], true)) { 57: return Nette\Database\UniqueConstraintViolationException::from($e); 58: 59: } elseif ($code >= 2001 && $code <= 2028) { 60: return Nette\Database\ConnectionException::from($e); 61: 62: } elseif (in_array($code, [1048, 1121, 1138, 1171, 1252, 1263, 1566], true)) { 63: return Nette\Database\NotNullConstraintViolationException::from($e); 64: 65: } else { 66: return Nette\Database\DriverException::from($e); 67: } 68: } 69: 70:
    $src
    
    
  2. .../database/src/Database/ResultSet.php:75 source  Nette\Database\Drivers\MySqlDriver->convertException(arguments)

    65: 'resource' => PDO::PARAM_LOB, 'NULL' => PDO::PARAM_NULL, ]; 66: $this->pdoStatement = $connection->getPdo()->prepare($queryString); 67: foreach ($params as $key => $value) { 68: $type = gettype($value); 69: $this->pdoStatement->bindValue(is_int($key) ? $key + 1 : $key, $value, isset($types[$type]) ? $types[$type] : PDO::PARAM_STR); 70: } 71: $this->pdoStatement->setFetchMode(PDO::FETCH_ASSOC); 72: $this->pdoStatement->execute(); 73: } 74: } catch (\PDOException $e) { 75: $e = $this->supplementalDriver->convertException($e); 76: $e->queryString = $queryString; 77: throw $e; 78: } 79: $this->time = microtime(true) - $time;
    $e
    
    
  3. .../database/src/Database/Connection.php:187 source  Nette\Database\ResultSet->__construct(arguments)

    177: 178: /** 179: * Generates and executes SQL query. 180: * @param string 181: * @return ResultSet 182: */ 183: public function query($sql, ...$params) 184: { 185: list($this->sql, $params) = $this->preprocess($sql, ...$params); 186: try { 187: $result = new ResultSet($this, $this->sql, $params); 188: } catch (PDOException $e) { 189: $this->onQuery($this, $e); 190: throw $e; 191: }
    $connection
    
    
    $queryString
    "SELECT 
                        t.id_transliteration as id, 
                        b.book_abrev, 
                        t.chapter, 
                        l.tran ... " (502)
    
    $params
    
    
  4. .../nette/database/src/Database/Context.php:91 source  Nette\Database\Connection->query(arguments)

    81: return $this->connection->query($sql, ...$params); 82: } 83: 84: 85: /** 86: * @param string 87: * @return ResultSet 88: */ 89: public function queryArgs($sql, array $params) 90: { 91: return $this->connection->query($sql, ...$params); 92: } 93: 94: 95: /**
    $sql
    "SELECT 
                        t.id_transliteration as id, 
                        b.book_abrev, 
                        t.chapter, 
                        l.tran ... " (502)
    
    $params
    "+"
    
  5. .../repository/TransliterationRepository.php:93 source  Nette\Database\Context->queryArgs(arguments)

    83: b.book_abrev, 84: t.chapter, 85: l.transliteration, 86: l.line_number 87: FROM transliteration t 88: LEFT JOIN surface s ON s.id_transliteration = t.id_transliteration 89: LEFT JOIN line l ON l.id_surface = s.id_surface 90: LEFT JOIN book b on t.id_book = b.id_book 91: WHERE " . $where; 92: 93: return $this->context->queryArgs($query, $whereArgs); 94: } 95: 96: private function prepareSearchRegExp(string $word) 97: {
    $sql
    "SELECT 
                        t.id_transliteration as id, 
                        b.book_abrev, 
                        t.chapter, 
                        l.tran ... " (502)
    
    $params
    
    
  6. .../presenters/TransliterationPresenter.php:68 source  App\Model\Repository\TransliterationRepository->transliterationsFulltextSearch(arguments)

    58: if (!$searchTerms) 59: { 60: $this->redirect('Transliteration:search'); 61: } 62: 63: if(!$searchTerms['word1']) 64: { 65: $this->redirect('Transliteration:search'); 66: } 67: 68: $resultRows = $this->transliterationRepository->transliterationsFulltextSearch($searchTerms); 69: 70: $this->template->resultRows = $resultRows; 71: } 72:
    $queryParams
    
    
  7. inner-code App\FrontModule\Presenters\TransliterationPresenter->actionSearchResult()

  8. .../src/Application/UI/Component.php:92 source  ReflectionMethod->invokeArgs(arguments)

    82: * @param array 83: * @return bool does method exist? 84: */ 85: protected function tryCall($method, array $params) 86: { 87: $rc = $this->getReflection(); 88: if ($rc->hasMethod($method)) { 89: $rm = $rc->getMethod($method); 90: if ($rm->isPublic() && !$rm->isAbstract() && !$rm->isStatic()) { 91: $this->checkRequirements($rm); 92: $rm->invokeArgs($this, $rc->combineArgs($rm, $params)); 93: return true; 94: } 95: } 96: return false;
    $object
    
    
    $args
    array ()
    
  9. .../src/Application/UI/Presenter.php:193 source  Nette\Application\UI\Component->tryCall(arguments)

    183: 184: $this->initGlobalParameters(); 185: $this->checkRequirements($this->getReflection()); 186: $this->onStartup($this); 187: $this->startup(); 188: if (!$this->startupCheck) { 189: $class = $this->getReflection()->getMethod('startup')->getDeclaringClass()->getName(); 190: throw new Nette\InvalidStateException("Method $class::startup() or its descendant doesn't call parent::startup()."); 191: } 192: // calls $this->action<Action>() 193: $this->tryCall($this->formatActionMethod($this->action), $this->params); 194: 195: // autoload components 196: foreach ($this->globalParams as $id => $foo) { 197: $this->getComponent($id, false);
    $method
    "actionsearchResult" (18)
    
    $params
    
    
  10. .../src/Application/Application.php:145 source  Nette\Application\UI\Presenter->run(arguments)

    135: if (!$request->isMethod($request::FORWARD) && !strcasecmp($request->getPresenterName(), $this->errorPresenter)) { 136: throw new BadRequestException('Invalid request. Presenter is not achievable.'); 137: } 138: 139: try { 140: $this->presenter = $this->presenterFactory->createPresenter($request->getPresenterName()); 141: } catch (InvalidPresenterException $e) { 142: throw count($this->requests) > 1 ? $e : new BadRequestException($e->getMessage(), 0, $e); 143: } 144: $this->onPresenter($this, $this->presenter); 145: $response = $this->presenter->run(clone $request); 146: 147: if ($response instanceof Responses\ForwardResponse) { 148: $request = $response->getRequest(); 149: goto process;
    $request
    
    
  11. .../src/Application/Application.php:83 source  Nette\Application\Application->processRequest(arguments)

    73: 74: 75: /** 76: * Dispatch a HTTP request to a front controller. 77: * @return void 78: */ 79: public function run() 80: { 81: try { 82: $this->onStartup($this); 83: $this->processRequest($this->createInitialRequest()); 84: $this->onShutdown($this); 85: 86: } catch (\Exception $e) { 87: } catch (\Throwable $e) {
    $request
    
    
  12. /var/www/html/www/index.php:6 source  Nette\Application\Application->run()

    1: <?php 2: 3: $container = require __DIR__ . '/../app/bootstrap.php'; 4: 5: $container->getByType(Nette\Application\Application::class) 6: ->run(); 7:

Caused by

PDOException #42000

SQLSTATE[42000]: Syntax error or access violation: 1139 Got error 'nothing to repeat at offset 0' from regexp

Source file

File: .../database/src/Database/ResultSet.php:72

62: $connection->getPdo()->{substr($queryString, 2)}(); 63: } elseif ($queryString !== null) { 64: static $types = ['boolean' => PDO::PARAM_BOOL, 'integer' => PDO::PARAM_INT, 65: 'resource' => PDO::PARAM_LOB, 'NULL' => PDO::PARAM_NULL, ]; 66: $this->pdoStatement = $connection->getPdo()->prepare($queryString); 67: foreach ($params as $key => $value) { 68: $type = gettype($value); 69: $this->pdoStatement->bindValue(is_int($key) ? $key + 1 : $key, $value, isset($types[$type]) ? $types[$type] : PDO::PARAM_STR); 70: } 71: $this->pdoStatement->setFetchMode(PDO::FETCH_ASSOC); 72: $this->pdoStatement->execute(); 73: } 74: } catch (\PDOException $e) { 75: $e = $this->supplementalDriver->convertException($e); 76: $e->queryString = $queryString;

Call stack

  1. .../database/src/Database/ResultSet.php:72 source  PDOStatement->execute()

    62: $connection->getPdo()->{substr($queryString, 2)}(); 63: } elseif ($queryString !== null) { 64: static $types = ['boolean' => PDO::PARAM_BOOL, 'integer' => PDO::PARAM_INT, 65: 'resource' => PDO::PARAM_LOB, 'NULL' => PDO::PARAM_NULL, ]; 66: $this->pdoStatement = $connection->getPdo()->prepare($queryString); 67: foreach ($params as $key => $value) { 68: $type = gettype($value); 69: $this->pdoStatement->bindValue(is_int($key) ? $key + 1 : $key, $value, isset($types[$type]) ? $types[$type] : PDO::PARAM_STR); 70: } 71: $this->pdoStatement->setFetchMode(PDO::FETCH_ASSOC); 72: $this->pdoStatement->execute(); 73: } 74: } catch (\PDOException $e) { 75: $e = $this->supplementalDriver->convertException($e); 76: $e->queryString = $queryString;
  2. .../database/src/Database/Connection.php:187 source  Nette\Database\ResultSet->__construct(arguments)

    177: 178: /** 179: * Generates and executes SQL query. 180: * @param string 181: * @return ResultSet 182: */ 183: public function query($sql, ...$params) 184: { 185: list($this->sql, $params) = $this->preprocess($sql, ...$params); 186: try { 187: $result = new ResultSet($this, $this->sql, $params); 188: } catch (PDOException $e) { 189: $this->onQuery($this, $e); 190: throw $e; 191: }
    $connection
    
    
    $queryString
    "SELECT 
                        t.id_transliteration as id, 
                        b.book_abrev, 
                        t.chapter, 
                        l.tran ... " (502)
    
    $params
    
    
  3. .../nette/database/src/Database/Context.php:91 source  Nette\Database\Connection->query(arguments)

    81: return $this->connection->query($sql, ...$params); 82: } 83: 84: 85: /** 86: * @param string 87: * @return ResultSet 88: */ 89: public function queryArgs($sql, array $params) 90: { 91: return $this->connection->query($sql, ...$params); 92: } 93: 94: 95: /**
    $sql
    "SELECT 
                        t.id_transliteration as id, 
                        b.book_abrev, 
                        t.chapter, 
                        l.tran ... " (502)
    
    $params
    "+"
    
  4. .../repository/TransliterationRepository.php:93 source  Nette\Database\Context->queryArgs(arguments)

    83: b.book_abrev, 84: t.chapter, 85: l.transliteration, 86: l.line_number 87: FROM transliteration t 88: LEFT JOIN surface s ON s.id_transliteration = t.id_transliteration 89: LEFT JOIN line l ON l.id_surface = s.id_surface 90: LEFT JOIN book b on t.id_book = b.id_book 91: WHERE " . $where; 92: 93: return $this->context->queryArgs($query, $whereArgs); 94: } 95: 96: private function prepareSearchRegExp(string $word) 97: {
    $sql
    "SELECT 
                        t.id_transliteration as id, 
                        b.book_abrev, 
                        t.chapter, 
                        l.tran ... " (502)
    
    $params
    
    
  5. .../presenters/TransliterationPresenter.php:68 source  App\Model\Repository\TransliterationRepository->transliterationsFulltextSearch(arguments)

    58: if (!$searchTerms) 59: { 60: $this->redirect('Transliteration:search'); 61: } 62: 63: if(!$searchTerms['word1']) 64: { 65: $this->redirect('Transliteration:search'); 66: } 67: 68: $resultRows = $this->transliterationRepository->transliterationsFulltextSearch($searchTerms); 69: 70: $this->template->resultRows = $resultRows; 71: } 72:
    $queryParams
    
    
  6. inner-code App\FrontModule\Presenters\TransliterationPresenter->actionSearchResult()

  7. .../src/Application/UI/Component.php:92 source  ReflectionMethod->invokeArgs(arguments)

    82: * @param array 83: * @return bool does method exist? 84: */ 85: protected function tryCall($method, array $params) 86: { 87: $rc = $this->getReflection(); 88: if ($rc->hasMethod($method)) { 89: $rm = $rc->getMethod($method); 90: if ($rm->isPublic() && !$rm->isAbstract() && !$rm->isStatic()) { 91: $this->checkRequirements($rm); 92: $rm->invokeArgs($this, $rc->combineArgs($rm, $params)); 93: return true; 94: } 95: } 96: return false;
    $object
    
    
    $args
    array ()
    
  8. .../src/Application/UI/Presenter.php:193 source  Nette\Application\UI\Component->tryCall(arguments)

    183: 184: $this->initGlobalParameters(); 185: $this->checkRequirements($this->getReflection()); 186: $this->onStartup($this); 187: $this->startup(); 188: if (!$this->startupCheck) { 189: $class = $this->getReflection()->getMethod('startup')->getDeclaringClass()->getName(); 190: throw new Nette\InvalidStateException("Method $class::startup() or its descendant doesn't call parent::startup()."); 191: } 192: // calls $this->action<Action>() 193: $this->tryCall($this->formatActionMethod($this->action), $this->params); 194: 195: // autoload components 196: foreach ($this->globalParams as $id => $foo) { 197: $this->getComponent($id, false);
    $method
    "actionsearchResult" (18)
    
    $params
    
    
  9. .../src/Application/Application.php:145 source  Nette\Application\UI\Presenter->run(arguments)

    135: if (!$request->isMethod($request::FORWARD) && !strcasecmp($request->getPresenterName(), $this->errorPresenter)) { 136: throw new BadRequestException('Invalid request. Presenter is not achievable.'); 137: } 138: 139: try { 140: $this->presenter = $this->presenterFactory->createPresenter($request->getPresenterName()); 141: } catch (InvalidPresenterException $e) { 142: throw count($this->requests) > 1 ? $e : new BadRequestException($e->getMessage(), 0, $e); 143: } 144: $this->onPresenter($this, $this->presenter); 145: $response = $this->presenter->run(clone $request); 146: 147: if ($response instanceof Responses\ForwardResponse) { 148: $request = $response->getRequest(); 149: goto process;
    $request
    
    
  10. .../src/Application/Application.php:83 source  Nette\Application\Application->processRequest(arguments)

    73: 74: 75: /** 76: * Dispatch a HTTP request to a front controller. 77: * @return void 78: */ 79: public function run() 80: { 81: try { 82: $this->onStartup($this); 83: $this->processRequest($this->createInitialRequest()); 84: $this->onShutdown($this); 85: 86: } catch (\Exception $e) { 87: } catch (\Throwable $e) {
    $request
    
    
  11. /var/www/html/www/index.php:6 source  Nette\Application\Application->run()

    1: <?php 2: 3: $container = require __DIR__ . '/../app/bootstrap.php'; 4: 5: $container->getByType(Nette\Application\Application::class) 6: ->run(); 7:

Last muted error

Warning: filemtime(): stat failed for /var/www/html/app/../temp/cache/Nette%5CBridges%5CApplicationDI%5CApplicationExtension

.../nette/di/src/DI/DependencyChecker.php:85

75: return [self::VERSION, $files, $phpFiles, $classes, $functions, $hash]; 76: } 77: 78: 79: /** 80: * Are dependencies expired? 81: * @return bool 82: */ 83: public static function isExpired($version, $files, &$phpFiles, $classes, $functions, $hash) 84: { 85: $current = @array_map('filemtime', array_combine($tmp = array_keys($files), $tmp)); // @ - files may not exist 86: $origPhpFiles = $phpFiles; 87: $phpFiles = @array_map('filemtime', array_combine($tmp = array_keys($phpFiles), $tmp)); // @ - files may not exist 88: return $version !== self::VERSION 89: || $files !== $current

Nette Application

Requests


Presenter


		

Environment

$_SERVER

REDIRECT_STATUS
"200" (3)
HTTP_HOST
"klinopis.local" (14)
HTTP_USER_AGENT
"Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0" (68)
HTTP_ACCEPT
"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8" (63)
HTTP_ACCEPT_LANGUAGE
"en-US,en;q=0.5" (14)
HTTP_ACCEPT_ENCODING
"gzip, deflate" (13)
HTTP_REFERER
"http://klinopis.local/transliteration/search" (44)
HTTP_DNT
"1"
HTTP_CONNECTION
"keep-alive" (10)
HTTP_COOKIE
"PHPSESSID=7iqr7e0q628f2thd2k4j3rk8a0" (36)
HTTP_UPGRADE_INSECURE_REQUESTS
"1"
PATH
"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin" (60)
SERVER_SIGNATURE
"<address>Apache/2.4.25 (Debian) Server at klinopis.local Port 80</address>
" (75)
SERVER_SOFTWARE
"Apache/2.4.25 (Debian)" (22)
SERVER_NAME
"klinopis.local" (14)
SERVER_ADDR
"172.18.0.2" (10)
SERVER_PORT
"80" (2)
REMOTE_ADDR
"172.18.0.1" (10)
DOCUMENT_ROOT
"/var/www/html/www" (17)
REQUEST_SCHEME
"http" (4)
CONTEXT_PREFIX
""
CONTEXT_DOCUMENT_ROOT
"/var/www/html/www" (17)
SERVER_ADMIN
"fjani@students.zcu.cz" (21)
SCRIPT_FILENAME
"/var/www/html/www/index.php" (27)
REMOTE_PORT
"52558" (5)
REDIRECT_URL
"/transliteration/search-result" (30)
GATEWAY_INTERFACE
"CGI/1.1" (7)
SERVER_PROTOCOL
"HTTP/1.1" (8)
REQUEST_METHOD
"GET" (3)
QUERY_STRING
""
REQUEST_URI
"/transliteration/search-result" (30)
SCRIPT_NAME
"/index.php" (10)
PHP_SELF
"/index.php" (10)
REQUEST_TIME_FLOAT
1555760313.906
REQUEST_TIME
1555760313

$_SESSION

__NFNette Session
_tracy

Nette Session

Nette.Http.UserStorage/

TransliterationSearch

Configuration options


Configuration

apache2handler

Apache Version Apache/2.4.25 (Debian)
Apache API Version 20120211
Server Administrator fjani@students.zcu.cz
Hostname:Port klinopis.local:0
User/Group www-data(33)/33
Max Requests Per Child: 0 - Keep Alive: on - Max Per Connection: 100
Timeouts Connection: 300 - Keep-Alive: 5
Virtual Server Yes
Server Root /etc/apache2
Loaded Modules core mod_so mod_watchdog http_core mod_log_config mod_logio mod_version mod_unixd mod_access_compat mod_alias mod_auth_basic mod_authn_core mod_authn_file mod_authz_core mod_authz_host mod_authz_user mod_autoindex mod_deflate mod_dir mod_env mod_filter mod_mime prefork mod_negotiation mod_php7 mod_reqtimeout mod_rewrite mod_setenvif mod_status
DirectiveLocal ValueMaster Value
engine11
last_modified00
xbithack00

Apache Environment

VariableValue
REDIRECT_STATUS 200
HTTP_HOST klinopis.local
HTTP_USER_AGENT Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0
HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE en-US,en;q=0.5
HTTP_ACCEPT_ENCODING gzip, deflate
HTTP_REFERER http://klinopis.local/transliteration/search
HTTP_DNT 1
HTTP_CONNECTION keep-alive
HTTP_COOKIE PHPSESSID=7iqr7e0q628f2thd2k4j3rk8a0
HTTP_UPGRADE_INSECURE_REQUESTS 1
PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
SERVER_SIGNATURE <address>Apache/2.4.25 (Debian) Server at klinopis.local Port 80</address>
SERVER_SOFTWARE Apache/2.4.25 (Debian)
SERVER_NAME klinopis.local
SERVER_ADDR 172.18.0.2
SERVER_PORT 80
REMOTE_ADDR 172.18.0.1
DOCUMENT_ROOT /var/www/html/www
REQUEST_SCHEME http
CONTEXT_PREFIX no value
CONTEXT_DOCUMENT_ROOT /var/www/html/www
SERVER_ADMIN fjani@students.zcu.cz
SCRIPT_FILENAME /var/www/html/www/index.php
REMOTE_PORT 52558
REDIRECT_URL /transliteration/search-result
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING no value
REQUEST_URI /transliteration/search-result
SCRIPT_NAME /index.php

HTTP Headers Information

HTTP Request Headers
HTTP Request GET /transliteration/search-result HTTP/1.1
Host klinopis.local
User-Agent Mozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0
Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Language en-US,en;q=0.5
Accept-Encoding gzip, deflate
Referer http://klinopis.local/transliteration/search
DNT 1
Connection keep-alive
Cookie PHPSESSID=7iqr7e0q628f2thd2k4j3rk8a0
Upgrade-Insecure-Requests 1
HTTP Response Headers
X-Powered-By Nette Framework
X-Frame-Options SAMEORIGIN
Set-Cookie PHPSESSID=7iqr7e0q628f2thd2k4j3rk8a0; expires=Sat, 04-May-2019 11:38:33 GMT; Max-Age=1209600; path=/; HttpOnly
Expires Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control no-store, no-cache, must-revalidate
Pragma no-cache
Vary X-Requested-With
Connection close
Transfer-Encoding chunked
Content-Type text/html; charset=UTF-8

calendar

Calendar support enabled

Core

PHP Version 7.0.33-0+deb9u3
DirectiveLocal ValueMaster Value
allow_url_fopenOnOn
allow_url_includeOffOff
arg_separator.input&&
arg_separator.output&&
auto_append_fileno valueno value
auto_globals_jitOnOn
auto_prepend_fileno valueno value
browscapno valueno value
default_charsetUTF-8UTF-8
default_mimetypetext/htmltext/html
disable_classesno valueno value
disable_functionspcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,
display_errorsOnOff
display_startup_errorsOffOff
doc_rootno valueno value
docref_extno valueno value
docref_rootno valueno value
enable_dlOffOff
enable_post_data_readingOnOn
error_append_stringno valueno value
error_logno valueno value
error_prepend_stringno valueno value
error_reporting3276722527
exit_on_timeoutOffOff
expose_phpOffOff
extension_dir/usr/lib/php/20151012/usr/lib/php/20151012
file_uploadsOnOn
highlight.comment#998; font-style: italic#FF8000
highlight.default#000#0000BB
highlight.html#06B#000000
highlight.keyword#D24; font-weight: bold#007700
highlight.string#080#DD0000
html_errorsOffOn
ignore_repeated_errorsOffOff
ignore_repeated_sourceOffOff
ignore_user_abortOffOff
implicit_flushOffOff
include_path.:/usr/share/php.:/usr/share/php
input_encodingno valueno value
internal_encodingno valueno value
log_errorsOffOn
log_errors_max_len10241024
mail.add_x_headerOnOn
mail.force_extra_parametersno valueno value
mail.logno valueno value
max_execution_time3030
max_file_uploads2020
max_input_nesting_level6464
max_input_time6060
max_input_vars10001000
memory_limit128M128M
open_basedirno valueno value
output_buffering40964096
output_encodingno valueno value
output_handlerno valueno value
post_max_size8M8M
precision1414
realpath_cache_size4096K4096K
realpath_cache_ttl120120
register_argc_argvOffOff
report_memleaksOnOn
report_zend_debugOnOn
request_orderGPGP
sendmail_fromno valueno value
sendmail_path/usr/sbin/sendmail -t -i /usr/sbin/sendmail -t -i 
serialize_precision1717
short_open_tagOffOff
SMTPlocalhostlocalhost
smtp_port2525
sql.safe_modeOffOff
sys_temp_dirno valueno value
track_errorsOffOff
unserialize_callback_funcno valueno value
upload_max_filesize2M2M
upload_tmp_dirno valueno value
user_dirno valueno value
user_ini.cache_ttl300300
user_ini.filename.user.ini.user.ini
variables_orderGPCSGPCS
xmlrpc_error_number00
xmlrpc_errorsOffOff
zend.assertions-1-1
zend.detect_unicodeOnOn
zend.enable_gcOnOn
zend.multibyteOffOff
zend.script_encodingno valueno value

ctype

ctype functions enabled

date

date/time support enabled
timelib version 2016.02
"Olson" Timezone Database Version 0.system
Timezone Database internal
Default timezone Europe/Prague
DirectiveLocal ValueMaster Value
date.default_latitude31.766731.7667
date.default_longitude35.233335.2333
date.sunrise_zenith90.58333390.583333
date.sunset_zenith90.58333390.583333
date.timezoneEurope/Pragueno value

dom

DOM/XML enabled
DOM/XML API Version 20031129
libxml Version 2.9.4
HTML Support enabled
XPath Support enabled
XPointer Support enabled
Schema Support enabled
RelaxNG Support enabled

exif

EXIF Support enabled
EXIF Version 7.0.33-0+deb9u3
Supported EXIF Version 0220
Supported filetypes JPEG,TIFF
DirectiveLocal ValueMaster Value
exif.decode_jis_intelJISJIS
exif.decode_jis_motorolaJISJIS
exif.decode_unicode_intelUCS-2LEUCS-2LE
exif.decode_unicode_motorolaUCS-2BEUCS-2BE
exif.encode_jisno valueno value
exif.encode_unicodeISO-8859-15ISO-8859-15

fileinfo

fileinfo support enabled
version 1.0.5
libmagic 522

filter

Input Validation and Filtering enabled
Revision $Id: 28fcca4bfda9c9907588a64d245b49cb398249d8 $
DirectiveLocal ValueMaster Value
filter.defaultunsafe_rawunsafe_raw
filter.default_flagsno valueno value

ftp

FTP support enabled
FTPS support enabled

gd

GD Support enabled
GD headers Version 2.2.4
GD library Version 2.2.4
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.6.3
GIF Read Support enabled
GIF Create Support enabled
JPEG Support enabled
libJPEG Version 6b
PNG Support enabled
libPNG Version 1.6.28
WBMP Support enabled
XPM Support enabled
libXpm Version 30411
XBM Support enabled
WebP Support enabled
DirectiveLocal ValueMaster Value
gd.jpeg_ignore_warning00

gettext

GetText Support enabled

hash

hash support enabled
Hashing Engines md2 md4 md5 sha1 sha224 sha256 sha384 sha512 ripemd128 ripemd160 ripemd256 ripemd320 whirlpool tiger128,3 tiger160,3 tiger192,3 tiger128,4 tiger160,4 tiger192,4 snefru snefru256 gost gost-crypto adler32 crc32 crc32b fnv132 fnv1a32 fnv164 fnv1a64 joaat haval128,3 haval160,3 haval192,3 haval224,3 haval256,3 haval128,4 haval160,4 haval192,4 haval224,4 haval256,4 haval128,5 haval160,5 haval192,5 haval224,5 haval256,5
MHASH support Enabled
MHASH API Version Emulated Support

iconv

iconv support enabled
iconv implementation glibc
iconv library version 2.24
DirectiveLocal ValueMaster Value
iconv.input_encodingno valueno value
iconv.internal_encodingno valueno value
iconv.output_encodingno valueno value

intl

Internationalization supportenabled
version 1.1.0
ICU version 57.1
ICU Data version 57.1
DirectiveLocal ValueMaster Value
intl.default_localeno valueno value
intl.error_level00
intl.use_exceptions00

json

json support enabled
json version 1.4.0

libxml

libXML support active
libXML Compiled Version 2.9.4
libXML Loaded Version 20904
libXML streams enabled

mbstring

Multibyte Support enabled
Multibyte string engine libmbfl
HTTP input encoding translation disabled
libmbfl version 1.3.2
oniguruma version 5.9.6
mbstring extension makes use of "streamable kanji code filter and converter", which is distributed under the GNU Lesser General Public License version 2.1.
Multibyte (japanese) regex support enabled
Multibyte regex (oniguruma) backtrack check On
Multibyte regex (oniguruma) version 5.9.6
DirectiveLocal ValueMaster Value
mbstring.detect_orderno valueno value
mbstring.encoding_translationOffOff
mbstring.func_overload00
mbstring.http_inputno valueno value
mbstring.http_outputno valueno value
mbstring.http_output_conv_mimetypes^(text/|application/xhtml\+xml)^(text/|application/xhtml\+xml)
mbstring.internal_encodingno valueno value
mbstring.languageneutralneutral
mbstring.strict_detectionOffOff
mbstring.substitute_characterno valueno value

mysqli

MysqlI Supportenabled
Client API library version mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
Active Persistent Links 0
Inactive Persistent Links 0
Active Links 0
DirectiveLocal ValueMaster Value
mysqli.allow_local_infileOnOn
mysqli.allow_persistentOnOn
mysqli.default_hostno valueno value
mysqli.default_port33063306
mysqli.default_pwno valueno value
mysqli.default_socketno valueno value
mysqli.default_userno valueno value
mysqli.max_linksUnlimitedUnlimited
mysqli.max_persistentUnlimitedUnlimited
mysqli.reconnectOffOff
mysqli.rollback_on_cached_plinkOffOff

mysqlnd

mysqlndenabled
Version mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
Compression supported
core SSL supported
extended SSL supported
Command buffer size 4096
Read buffer size 32768
Read timeout 31536000
Collecting statistics Yes
Collecting memory statistics No
Tracing n/a
Loaded plugins mysqlnd,debug_trace,auth_plugin_mysql_native_password,auth_plugin_mysql_clear_password,auth_plugin_sha256_password
API Extensions mysqli,pdo_mysql
mysqlnd statistics
bytes_sent 6587
bytes_received 7840
packets_sent 58
packets_received 175
protocol_overhead_in 700
protocol_overhead_out 232
bytes_received_ok_packet 0
bytes_received_eof_packet 0
bytes_received_rset_header_packet 90
bytes_received_rset_field_meta_packet 0
bytes_received_rset_row_packet 250
bytes_received_prepare_response_packet 4261
bytes_received_change_user_packet 2511
packets_sent_command 23
packets_received_ok 0
packets_received_eof 0
packets_received_rset_header 10
packets_received_rset_field_meta 0
packets_received_rset_row 18
packets_received_prepare_response 88
packets_received_change_user 47
result_set_queries 10
non_result_set_queries 6
no_index_used 0
bad_index_used 0
slow_queries 0
buffered_sets 10
unbuffered_sets 0
ps_buffered_sets 0
ps_unbuffered_sets 0
flushed_normal_sets 0
flushed_ps_sets 0
ps_prepared_never_executed 0
ps_prepared_once_executed 0
rows_fetched_from_server_normal 37
rows_fetched_from_server_ps 0
rows_buffered_from_client_normal 37
rows_buffered_from_client_ps 0
rows_fetched_from_client_normal_buffered 37
rows_fetched_from_client_normal_unbuffered 0
rows_fetched_from_client_ps_buffered 0
rows_fetched_from_client_ps_unbuffered 0
rows_fetched_from_client_ps_cursor 0
rows_affected_normal 0
rows_affected_ps 0
rows_skipped_normal 37
rows_skipped_ps 0
copy_on_write_saved 0
copy_on_write_performed 0
command_buffer_too_small 0
connect_success 6
connect_failure 0
connection_reused 0
reconnect 0
pconnect_success 0
active_connections 18446744073709551612
active_persistent_connections 0
explicit_close 5
implicit_close 0
disconnect_close 0
in_middle_of_command_close 0
explicit_free_result 10
implicit_free_result 0
explicit_stmt_close 0
implicit_stmt_close 0
mem_emalloc_count 0
mem_emalloc_amount 0
mem_ecalloc_count 0
mem_ecalloc_amount 0
mem_erealloc_count 0
mem_erealloc_amount 0
mem_efree_count 0
mem_efree_amount 0
mem_malloc_count 0
mem_malloc_amount 0
mem_calloc_count 0
mem_calloc_amount 0
mem_realloc_count 0
mem_realloc_amount 0
mem_free_count 0
mem_free_amount 0
mem_estrndup_count 0
mem_strndup_count 0
mem_estndup_count 0
mem_strdup_count 0
proto_text_fetched_null 0
proto_text_fetched_bit 0
proto_text_fetched_tinyint 0
proto_text_fetched_short 0
proto_text_fetched_int24 0
proto_text_fetched_int 7
proto_text_fetched_bigint 28
proto_text_fetched_decimal 0
proto_text_fetched_float 0
proto_text_fetched_double 0
proto_text_fetched_date 1
proto_text_fetched_year 0
proto_text_fetched_time 0
proto_text_fetched_datetime 0
proto_text_fetched_timestamp 0
proto_text_fetched_string 190
proto_text_fetched_blob 0
proto_text_fetched_enum 20
proto_text_fetched_set 0
proto_text_fetched_geometry 0
proto_text_fetched_other 0
proto_binary_fetched_null 0
proto_binary_fetched_bit 0
proto_binary_fetched_tinyint 0
proto_binary_fetched_short 0
proto_binary_fetched_int24 0
proto_binary_fetched_int 0
proto_binary_fetched_bigint 0
proto_binary_fetched_decimal 0
proto_binary_fetched_float 0
proto_binary_fetched_double 0
proto_binary_fetched_date 0
proto_binary_fetched_year 0
proto_binary_fetched_time 0
proto_binary_fetched_datetime 0
proto_binary_fetched_timestamp 0
proto_binary_fetched_string 0
proto_binary_fetched_json 0
proto_binary_fetched_blob 0
proto_binary_fetched_enum 0
proto_binary_fetched_set 0
proto_binary_fetched_geometry 0
proto_binary_fetched_other 0
init_command_executed_count 0
init_command_failed_count 0
com_quit 5
com_init_db 0
com_query 18
com_field_list 0
com_create_db 0
com_drop_db 0
com_refresh 0
com_shutdown 0
com_statistics 0
com_process_info 0
com_connect 0
com_process_kill 0
com_debug 0
com_ping 0
com_time 0
com_delayed_insert 0
com_change_user 0
com_binlog_dump 0
com_table_dump 0
com_connect_out 0
com_register_slave 0
com_stmt_prepare 0
com_stmt_execute 0
com_stmt_send_long_data 0
com_stmt_close 0
com_stmt_reset 0
com_stmt_set_option 0
com_stmt_fetch 0
com_deamon 0
bytes_received_real_data_normal 2073
bytes_received_real_data_ps 0

openssl

OpenSSL support enabled
OpenSSL Library Version OpenSSL 1.1.0j 20 Nov 2018
OpenSSL Header Version OpenSSL 1.1.0j 20 Nov 2018
Openssl default config /usr/lib/ssl/openssl.cnf
DirectiveLocal ValueMaster Value
openssl.cafileno valueno value
openssl.capathno valueno value

pcre

PCRE (Perl Compatible Regular Expressions) Support enabled
PCRE Library Version 8.39 2016-06-14
PCRE JIT Support enabled
DirectiveLocal ValueMaster Value
pcre.backtrack_limit10000001000000
pcre.jit11
pcre.recursion_limit100000100000

PDO

PDO supportenabled
PDO drivers mysql

pdo_mysql

PDO Driver for MySQLenabled
Client API version mysqlnd 5.0.12-dev - 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $
DirectiveLocal ValueMaster Value
pdo_mysql.default_socket/var/run/mysqld/mysqld.sock/var/run/mysqld/mysqld.sock

Phar

Phar: PHP Archive supportenabled
Phar EXT version 2.0.2
Phar API version 1.1.1
SVN revision $Id: 308c1e92e8ad12e51f5db846d3366fdf3487eb21 $
Phar-based phar archives enabled
Tar-based phar archives enabled
ZIP-based phar archives enabled
gzip compression enabled
bzip2 compression disabled (install pecl/bz2)
Native OpenSSL support enabled
Phar based on pear/PHP_Archive, original concept by Davey Shafik.
Phar fully realized by Gregory Beaver and Marcus Boerger.
Portions of tar implementation Copyright (c) 2003-2009 Tim Kientzle.
DirectiveLocal ValueMaster Value
phar.cache_listno valueno value
phar.readonlyOnOn
phar.require_hashOnOn

posix

Revision $Id: b691ca925e7a085e6929579c4eba8fed0732e0ef $

readline

Readline Supportenabled
Readline library EditLine wrapper
DirectiveLocal ValueMaster Value
cli.pagerno valueno value
cli.prompt\b \> \b \> 

Reflection

Reflectionenabled
Version $Id: e5303663dcb329e17818853ff223e5ee01481f2c $

session

Session Support enabled
Registered save handlers files user
Registered serializer handlers php_serialize php php_binary wddx
DirectiveLocal ValueMaster Value
session.auto_startOffOff
session.cache_expire180180
session.cache_limiternocachenocache
session.cookie_domainno valueno value
session.cookie_httponlyOnOff
session.cookie_lifetime12096000
session.cookie_path//
session.cookie_secureOffOff
session.entropy_file/dev/urandom/dev/urandom
session.entropy_length3232
session.gc_divisor10001000
session.gc_maxlifetime12096001440
session.gc_probability00
session.hash_bits_per_character55
session.hash_function00
session.lazy_writeOnOn
session.namePHPSESSIDPHPSESSID
session.referer_checkno valueno value
session.save_handlerfilesfiles
session.save_path/var/lib/php/sessions/var/lib/php/sessions
session.serialize_handlerphpphp
session.upload_progress.cleanupOnOn
session.upload_progress.enabledOnOn
session.upload_progress.freq1%1%
session.upload_progress.min_freq11
session.upload_progress.namePHP_SESSION_UPLOAD_PROGRESSPHP_SESSION_UPLOAD_PROGRESS
session.upload_progress.prefixupload_progress_upload_progress_
session.use_cookiesOnOn
session.use_only_cookiesOnOn
session.use_strict_modeOffOff
session.use_trans_sid00

shmop

shmop support enabled

SimpleXML

Simplexml supportenabled
Revision $Id: 0637e06af859ca1d0dea9c2f1530e51b98f1970e $
Schema support enabled

sockets

Sockets Support enabled

SPL

SPL supportenabled
Interfaces Countable, OuterIterator, RecursiveIterator, SeekableIterator, SplObserver, SplSubject
Classes AppendIterator, ArrayIterator, ArrayObject, BadFunctionCallException, BadMethodCallException, CachingIterator, CallbackFilterIterator, DirectoryIterator, DomainException, EmptyIterator, FilesystemIterator, FilterIterator, GlobIterator, InfiniteIterator, InvalidArgumentException, IteratorIterator, LengthException, LimitIterator, LogicException, MultipleIterator, NoRewindIterator, OutOfBoundsException, OutOfRangeException, OverflowException, ParentIterator, RangeException, RecursiveArrayIterator, RecursiveCachingIterator, RecursiveCallbackFilterIterator, RecursiveDirectoryIterator, RecursiveFilterIterator, RecursiveIteratorIterator, RecursiveRegexIterator, RecursiveTreeIterator, RegexIterator, RuntimeException, SplDoublyLinkedList, SplFileInfo, SplFileObject, SplFixedArray, SplHeap, SplMinHeap, SplMaxHeap, SplObjectStorage, SplPriorityQueue, SplQueue, SplStack, SplTempFileObject, UnderflowException, UnexpectedValueException

standard

Dynamic Library Support enabled
Path to sendmail /usr/sbin/sendmail -t -i
DirectiveLocal ValueMaster Value
assert.active11
assert.bail00
assert.callbackno valueno value
assert.exception00
assert.quiet_eval00
assert.warning11
auto_detect_line_endings00
default_socket_timeout6060
fromno valueno value
url_rewriter.tagsa=href,area=href,frame=src,input=src,form=fakeentrya=href,area=href,frame=src,input=src,form=fakeentry
user_agentno valueno value

sysvmsg

sysvmsg support enabled
Revision $Id: dfb999763f95bfe9609fae60b4e07a492888ec7c $

sysvsem

Version 7.0.33-0+deb9u3

sysvshm

Version 7.0.33-0+deb9u3

tokenizer

Tokenizer Support enabled

wddx

WDDX Supportenabled
WDDX Session Serializer enabled

xml

XML Support active
XML Namespace Support active
libxml2 Version 2.9.4

xmlreader

XMLReader enabled

xmlwriter

XMLWriter enabled

xsl

XSL enabled
libxslt Version 1.1.29
libxslt compiled against libxml Version 2.9.4
EXSLT enabled
libexslt Version 1.1.29

Zend OPcache

Opcode Caching Up and Running
Optimization Enabled
SHM Cache Enabled
File Cache Disabled
Startup OK
Shared memory model mmap
Cache hits 7418
Cache misses 316
Used memory 13968568
Free memory 52911136
Wasted memory 229160
Interned Strings Used memory 1040216
Interned Strings Free memory 3154088
Cached scripts 294
Cached keys 529
Max keys 3907
OOM restarts 0
Hash keys restarts 0
Manual restarts 0
DirectiveLocal ValueMaster Value
opcache.blacklist_filenameno valueno value
opcache.consistency_checks00
opcache.dups_fixOffOff
opcache.enableOnOn
opcache.enable_cliOffOff
opcache.enable_file_overrideOffOff
opcache.error_logno valueno value
opcache.fast_shutdown00
opcache.file_cacheno valueno value
opcache.file_cache_consistency_checks11
opcache.file_cache_only00
opcache.file_update_protection22
opcache.force_restart_timeout180180
opcache.huge_code_pagesOffOff
opcache.inherited_hackOnOn
opcache.interned_strings_buffer44
opcache.lockfile_path/tmp/tmp
opcache.log_verbosity_level11
opcache.max_accelerated_files20002000
opcache.max_file_size00
opcache.max_wasted_percentage55
opcache.memory_consumption6464
opcache.optimization_level0x7FFFBFFF0x7FFFBFFF
opcache.preferred_memory_modelno valueno value
opcache.protect_memory00
opcache.restrict_apino valueno value
opcache.revalidate_freq22
opcache.revalidate_pathOffOff
opcache.save_comments11
opcache.use_cwdOnOn
opcache.validate_permissionOffOff
opcache.validate_rootOffOff
opcache.validate_timestampsOnOn

zip

Zip enabled
Zip version 1.13.5
Libzip version 1.1.2

zlib

ZLib Supportenabled
Stream Wrapper compress.zlib://
Stream Filter zlib.inflate, zlib.deflate
Compiled Version 1.2.8
Linked Version 1.2.8
DirectiveLocal ValueMaster Value
zlib.output_compressionOffOff
zlib.output_compression_level-1-1
zlib.output_handlerno valueno value

Additional Modules

Module Name

HTTP request

Headers

Hostklinopis.local
User-AgentMozilla/5.0 (X11; Linux x86_64; rv:67.0) Gecko/20100101 Firefox/67.0
Accepttext/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Languageen-US,en;q=0.5
Accept-Encodinggzip, deflate
Refererhttp://klinopis.local/transliteration/search
DNT1
Connectionkeep-alive
CookiePHPSESSID=7iqr7e0q628f2thd2k4j3rk8a0
Upgrade-Insecure-Requests1

$_GET

empty

$_POST

empty

$_COOKIE

PHPSESSID
"7iqr7e0q628f2thd2k4j3rk8a0" (26)

HTTP response

Headers

X-Powered-By: Nette Framework
X-Frame-Options: SAMEORIGIN
Set-Cookie: PHPSESSID=7iqr7e0q628f2thd2k4j3rk8a0; expires=Sat, 04-May-2019 11:38:33 GMT; Max-Age=1209600; path=/; HttpOnly
Expires: Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control: no-store, no-cache, must-revalidate
Pragma: no-cache
Vary: X-Requested-With
Content-Type: text/html; charset=UTF-8