You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ASCz' at line 24 (1064) :: SELECT DISTINCT(projects.id), projects.*, projects_contents.*, photos.file AS mainphoto_file, projects_categories.id AS category, projects_categories.show AS category_show, projects_categories_contents.name as category_name, projects_categories_contents.url as category_url FROM projects LEFT JOIN projects_contents ON projects_contents.project = projects.id LEFT JOIN projects_categories_relations ON projects_categories_relations.project = projects.id LEFT JOIN projects_categories ON projects_categories.id = projects_categories_relations.category LEFT JOIN projects_categories_contents ON projects_categories.id = projects_categories_contents.category LEFT JOIN photos ON projects.mainphoto = photos.id WHERE projects.show = true AND projects_categories.show = true AND projects_contents.language = 1 AND projects_categories_contents.language = 1 AND projects_categories.id = 12 ORDER BY ISNULL(projects_categories_relations.order), projects_categories_relations.order ASCz
/mnt/devel/Atrium/atriumstudio/vendor/Onion/Database/MySQL.php
http://www.atriumarchitekti.loc/sk/architektura/realizacie (GET)
Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0
321 } else {322 $this->command = strtoupper($command);323 }324 } else {325 $this->command = trim(strtoupper($commandCount[0]), ';');326 }327 }328329 $result = $this->mysqli->query($sql);330331 if (defined('DEBUG') === true332 and DEBUG === true) {333334 \Onion\Debug\Logger::log('sql', $sql);335 }336337 self::$queriesCounter++;338339 if ($result === false) {340 throw new \Onion\Database\DatabaseException($this->mysqli->error.' ('.$this->mysqli->errno.') :: '.$sql, $this->mysqli->errno);341 }342343 $command = $this->command;344345 if ($reset === true) {346 $this->reset();347 }348349 if ($raw === true) {350 return $result;
151152 if ($this->actionName === null) {153 $this->actionName = $this->currentRoute->action;154 }155 preg_match('/([A-Za-z0-9]+)Controller/', $this->controllerName, $match);156 if (isset($match[1]) === true) {157 $view->setTemplate(APP_DIR.'/Templates/'.$match[1].'.html');158 }159160 $this->controller = new $this->controllerName($this->container);161162 $parameters = $this->currentRoute->getResource();163164 $this->runHooks('system.hooks.afterCreateController');165166 call_user_func_array(array($this->controller, 'before'), $parameters);167168 $this->runHooks('system.hooks.beforeControllerRun');169170 call_user_func_array(array($this->controller, $this->actionName), $parameters);171172 $this->runHooks('system.hooks.afterControllerRun');173174 call_user_func_array(array($this->controller, 'after'), $parameters);175176 if (is_object($this->controller->view) === true) {177 $view['flash'] = $this->flash['current'];178179 $this->runHooks('system.hooks.beforeRenderView');180
array (
0 =>
array (
0 => 'object (onionCMS\\Modules\\Projects\\Controllers\\ProjectsCategoryController)',
1 => 'show',
),
1 =>
array (
'languageCode' => 'sk',
'pageUrl' => 'architektura',
'categoryUrl' => 'realizacie',
),
)
132 WWW_DIR.'/js/vendor/cookie.js',133 WWW_DIR.'/js/vendor/scroll-top.js',134 ),135 'less' => array(136 )137 ),138 'after' => array(139 'js' => array(140 WWW_DIR.'/js/main.js',141 ),142 'less' => array(143 WWW_DIR.'/less/main.less'144 )145 )146 )147 );148149 $app = new \Onion\Application($configuration);150151 $app->run();152 exit;
array ( )
13 // absolute filesystem path to the libraries14 define('LIBS_DIR', realpath(WWW_DIR.'/../vendor'));1516 // absolute filesystem path to the web root17 define('ONION_DIR', LIBS_DIR.'/Onion');1819 // absolute filesystem path to the application root20 define('APP_DIR', WWW_DIR.'/../app');2122 // absolute filesystem path to the temporary files23 define('TEMP_DIR', realpath(WWW_DIR.'/../temp'));2425 // absolute filesystem path to the cache26 define('CACHE_DIR', realpath(WWW_DIR.'/../cache'));2728 define('ONIONCMS_DIR', realpath(ONION_DIR.'/../onionCMS'));2930 // load bootstrap file31 if ($_SERVER["SERVER_ADDR"] === "127.0.0.1") {32 require ONIONCMS_DIR.'/bootstrap.dev.php';33 } else {34 require ONIONCMS_DIR.'/bootstrap.php';35 }
array ( 0 => '/mnt/devel/Atrium/atriumstudio/vendor/onionCMS/bootstrap.dev.php', )
array ( 'REDIRECT_STATUS' => '200', 'HTTP_HOST' => 'www.atriumarchitekti.loc', 'HTTP_USER_AGENT' => 'Mozilla/5.0 (X11; Linux x86_64; rv:127.0) Gecko/20100101 Firefox/127.0', 'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8', 'HTTP_ACCEPT_LANGUAGE' => 'sk,cs;q=0.8,en-US;q=0.5,en;q=0.3', 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate', 'HTTP_CONNECTION' => 'keep-alive', 'HTTP_REFERER' => 'http://www.atriumarchitekti.loc/sk/architektura/byvanie', 'HTTP_COOKIE' => 'language=sk; cookieconsent_dismissed=yes; ws56trt87dfgxzaq=QXFCTmZqV1Y3RUVoUmhlalNZcDUrUlJRVEQxb3hJSUpoYzZDcWtWanZWWWJBWml4akROMHVMZUJJSFZjWWxoS0NXZjRZdjFPQnVpaHFzbXJpeGxKRFJqajJzNlkxL000dHdtZjI0MEFpU0N0VnFoV21rOWZBVGZaamczVVNwaHg0N0VTaUo2WGZmVFZEWXBJd1hFU0orRExoUGdTNVlvaDJkQ25mZTRtMVQ0OEh0Vmk0MGlqS0NURURVMjFjMEdVRmdGV1p4L01qWDZJdHVmaUtsT2FpcU1DUWJQSGZTMC91V0ZPV2RSV2pUYkZXNjhFVDUwSTlvdUdGQVE1U1cyQkJKVDdOcHI0SWJvPTNiYjFjZmU5; qazfdrtygdfxsw=a1s3bv3rr2mkgko88kojjhdm58', 'HTTP_UPGRADE_INSECURE_REQUESTS' => '1', 'HTTP_PRIORITY' => 'u=1', 'PATH' => '/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin', 'SERVER_SIGNATURE' => '<address>Apache/2.4.38 (Debian) Server at www.atriumarchitekti.loc Port 80</address> ', 'SERVER_SOFTWARE' => 'Apache/2.4.38 (Debian)', 'SERVER_NAME' => 'www.atriumarchitekti.loc', 'SERVER_ADDR' => '127.0.0.1', 'SERVER_PORT' => '80', 'REMOTE_ADDR' => '127.0.0.1', 'DOCUMENT_ROOT' => '/mnt/devel/Atrium/atriumstudio/www_root', 'REQUEST_SCHEME' => 'http', 'CONTEXT_PREFIX' => '', 'CONTEXT_DOCUMENT_ROOT' => '/mnt/devel/Atrium/atriumstudio/www_root', 'SERVER_ADMIN' => 'webmaster@localhost', 'SCRIPT_FILENAME' => '/mnt/devel/Atrium/atriumstudio/www_root/index.php', 'REMOTE_PORT' => '57908', 'REDIRECT_URL' => '/sk/architektura/realizacie', 'GATEWAY_INTERFACE' => 'CGI/1.1', 'SERVER_PROTOCOL' => 'HTTP/1.1', 'REQUEST_METHOD' => 'GET', 'QUERY_STRING' => '', 'REQUEST_URI' => '/sk/architektura/realizacie', 'SCRIPT_NAME' => '/index.php', 'PHP_SELF' => '/index.php', 'REQUEST_TIME_FLOAT' => 1718822674.414, 'REQUEST_TIME' => 1718822674, )
array ( )