Illegal mix of collations (utf8mb4_czech_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for operation '=' search►

138:        public function query(string $query): Result
139:        {
140:            assert($this->connection !== null);
141:    
142:            $time = microtime(true);
143:            $result = @$this->connection->query($query);
144:            $this->timeTaken = microtime(true) - $time;
145:    
146:            if ($result === false) {
147:                throw $this->createException(
148:                    $this->connection->error,
149:                    $this->connection->errno,
150:                    $this->connection->sqlstate,
151:                    $query
152:                );

'Illegal mix of collations (utf8mb4_czech_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for operation '=''

1267

'HY000'

16:    {
17:        use StrictObjectTrait;
18:    
19:    
20:        /**
21:         * @throws DriverException
22:         */
23:        public static function loggedQuery(IDriver $driver, ILogger $logger, string $sqlQuery): Result
24:        {
25:            try {
26:                $result = $driver->query($sqlQuery);
27:                $logger->onQuery(
28:                    $sqlQuery,
29:                    $driver->getQueryElapsedTime(),
30:                    $result

326:    
327:        protected function getSavepointName(): string
328:        {
329:            return "NEXTRAS_SAVEPOINT_{$this->nestedTransactionIndex}";
330:        }
331:    
332:    
333:        private function nativeQuery(string $sql): Result
334:        {
335:            return LoggerHelper::loggedQuery(
336:                $this->driver,
337:                $this->logger,
338:                $sql
339:            );
340:        }

126:        }
127:    
128:    
129:        /** @inheritdoc */
130:        public function query(...$args): Result
131:        {
132:            if (!$this->connected) {
133:                $this->connect();
134:            }
135:            $sql = $this->sqlPreprocessor->process($args);
136:            return $this->nativeQuery($sql);
137:        }
138:    
139:    
140:        /** @inheritdoc */

138:    
139:    
140:        /** @inheritdoc */
141:        public function queryArgs($query, array $args = []): Result
142:        {
143:            if (!is_array($query)) {
144:                array_unshift($args, $query);
145:            } else {
146:                $args = $query;
147:            }
148:            return call_user_func_array([$this, 'query'], $args);
149:        }
150:    
151:    
152:        public function queryByQueryBuilder(QueryBuilder $queryBuilder): Result

'cs'

'kapitola/obsah'

38:        public function getBySeoUrl(string $pagename, string $locale) : Result
39:        {
40:            $query = $this->builder()->select('cms_static_pages.id')
41:                ->joinInner('sys_languages as [l]', 'language_id = l.id')->where('l.visible = 1')
42:                ->andWhere('cms_static_pages.visible = 1')
43:                ->andWhere('l.iso_code = %s', $locale)
44:                ->andWhere('cms_get_page_url(cms_static_pages.id) = %s', $pagename);
45:    
46:            return $this->getConnection()->queryArgs(
47:                $query->getQuerySql(),
48:                $query->getQueryParameters()
49:            );
50:        }
51:    
52:        /**

30:         * @throws InvalidArgumentException
31:         */
32:        public function getBySeoUrl(string $pageName, string $locale) : ?StaticPages
33:        {
34:            if ($pageName === null) {
35:                return null;
36:            } elseif (!is_scalar($pageName)) {
37:                throw new InvalidArgumentException('Page name has to be a scalar.');
38:            }
39:    
40:            $page = $this->getMapper()->getBySeoUrl($pageName, $locale)->fetch();
41:            if (empty($page)) {
42:                return null;
43:            }
44:    

'kapitola/obsah'

'cs'

29:         * Prepare requested page by url
30:         * @param string|null $seoUrl
31:         */
32:        public function actionPage(?string $seoUrl) : void
33:        {
34:            $seoUrl = $this->getParameter("seoUrl");
35:    
36:            if (empty($seoUrl)) {
37:                $page = $this->orm->cmsStaticPages->getHomepage($this->locale);
38:            } else {
39:                $page = $this->orm->cmsStaticPages->getBySeoUrl($seoUrl, $this->locale);
40:            }
41:    
42:            if (is_null($page) || $page->seoUrl == 'error') {
43:                throw new Nette\Application\BadRequestException();

'kapitola/obsah'

'cs'

 92:            $rc = $this->getReflection();
 93:            if ($rc->hasMethod($method)) {
 94:                $rm = $rc->getMethod($method);
 95:                if ($rm->isPublic() && !$rm->isAbstract() && !$rm->isStatic()) {
 96:                    $this->checkRequirements($rm);
 97:                    try {
 98:                        $args = $rc->combineArgs($rm, $params);
 99:                    } catch (Nette\InvalidArgumentException $e) {
100:                        throw new Nette\Application\BadRequestException($e->getMessage());
101:                    }
102:                    $rm->invokeArgs($this, $args);
103:                    return true;
104:                }
105:            }
106:            return false;

203:    
204:                $this->initGlobalParameters();
205:                $this->checkRequirements(static::getReflection());
206:                $this->onStartup($this);
207:                $this->startup();
208:                if (!$this->startupCheck) {
209:                    $class = static::getReflection()->getMethod('startup')->getDeclaringClass()->getName();
210:                    throw new Nette\InvalidStateException("Method $class::startup() or its descendant doesn't call parent::startup().");
211:                }
212:                // calls $this->action<Action>()
213:                $this->tryCall(static::formatActionMethod($this->action), $this->params);
214:    
215:                // autoload components
216:                foreach ($this->globalParams as $id => $foo) {
217:                    $this->getComponent((string) $id, false);

'actionpage'

150:            }
151:    
152:            try {
153:                $this->presenter = $this->presenterFactory->createPresenter($request->getPresenterName());
154:            } catch (InvalidPresenterException $e) {
155:                throw count($this->requests) > 1
156:                    ? $e
157:                    : new BadRequestException($e->getMessage(), 0, $e);
158:            }
159:            $this->onPresenter($this, $this->presenter);
160:            $response = $this->presenter->run(clone $request);
161:    
162:            if ($response instanceof Responses\ForwardResponse) {
163:                $request = $response->getRequest();
164:                goto process;

79:        }
80:    
81:    
82:        /**
83:         * Dispatch a HTTP request to a front controller.
84:         */
85:        public function run(): void
86:        {
87:            try {
88:                $this->onStartup($this);
89:                $this->processRequest($this->createInitialRequest());
90:                $this->onShutdown($this);
91:    
92:            } catch (\Throwable $e) {
93:                $this->onError($this, $e);

47:            }
48:        }
49:    }
50:    
51:    if (PHP_SAPI == "cli") {
52:        require 'console.php';
53:        die;
54:    }
55:    
56:    $container = require __DIR__ . '/../app/bootstrap.php';
57:    $container->getByType(Application::class)->run(); // phpcs:ignore
58: