Phalcon Framework 5.9.3

PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb3_unicode_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'

/var/www/html/almaliora.nl/cache/volt/Tmpl_System_Search_Result.volt.php (2)
#0PDOStatement->execute
#1Phalcon\Db\Adapter\Pdo\AbstractPdo->executePrepared
#2Phalcon\Db\Adapter\Pdo\AbstractPdo->query
#3Phalcon\Mvc\Model\Query->executeSelect
#4Phalcon\Mvc\Model\Query->execute
#5Phalcon\Paginator\Adapter\QueryBuilder->paginate
/var/www/html/almaliora.nl/cache/volt/Tmpl_System_Search_Result.volt.php (2)
<?php if (isset($paginator)) { ?>
    <?php $paginate = $paginator->paginate(); ?>
    <?php $count = $paginate->getTotalItems(); ?>
<?php } else { ?>
    <?php $count = 0; ?>
<?php } ?>
 
<?php if (($count > 0)) { ?>
    <!--<?= CLSystems\PhalCMS\Lib\Helper\Text::Plural('about-results-count',$count,['count' => $count]) ?>-->
    <?= $this->partial('Pagination/Pagination') ?>
 
    <div class="uk-container">
        <div class="uk-grid-small uk-grid-match uk-child-width-1-1@xs uk-child-width-1-2@m" uk-grid>
            <?php foreach ($paginate->getItems() as $item) { ?>
            <div>
                <div class="uk-card uk-card-small uk-card-default uk-card-body uk-flex uk-flex-column uk-flex-top uk-flex-left">
                    <article class="uk-article">
                        <div class="result-title">
                            <a class="uk-text-lead" href="<?= CLSystems\PhalCMS\Lib\Helper\Uri::route($item->t('route')) ?>">
                                <?= $item->t('title') ?>
                            </a>
                        </div>
                        <div class="result-summary">
                            <div class="uk-grid-small" uk-grid>
                                <?php $image = CLSystems\PhalCMS\Lib\Helper\Image::loadImage($item->t('image')); ?>
                                <?php if ($image) { ?>
                                    <div class="uk-width-auto">
                                        <a class="uk-text-lead" href="<?= CLSystems\PhalCMS\Lib\Helper\Uri::route($item->t('route')) ?>">
                                            <img src="<?= $image->getResize(85, 85) ?>" alt="<?= $this->escaper->attributes($item->title) ?>"/>
                                        </a>
                                    </div>
                                <?php } ?>
                                <div class="<?= ($image ? 'uk-width-expand' : 'uk-width-1-1') ?>">
                                    <p class="uk-text-meta">
                                        <?= CLSystems\PhalCMS\Lib\Helper\StringHelper::truncate(strip_tags(html_entity_decode($item->summary())),160) ?><br/>
                                        <a href="<?= $item->link ?>"
                                           class="uk-button uk-button-default uk-button-small uk-margin">
                                            <?= CLSystems\PhalCMS\Lib\Helper\Text::_('read-more') ?>
                                        </a>
                                    </p>
                                </div>
                            </div>
                        </div>
                    </article>
                </div>
            </div>
            <?php } ?>
        </div>
    </div>
 
    <?= $this->partial('Pagination/Pagination') ?>
<?php } else { ?>
    <div class="uk-alert uk-alert-warning">
        <?= CLSystems\PhalCMS\Lib\Helper\Text::_('no-results') ?>
    </div>
<?php } ?>
#6Phalcon\Mvc\View\Engine\Volt->render
#7Phalcon\Mvc\View->engineRender
#8Phalcon\Mvc\View->processRender
#9Phalcon\Mvc\View->render
#10Phalcon\Mvc\Application->handle
/var/www/html/almaliora.nl/src/app/Lib/CmsApplication.php (117)
<?php
 
namespace CLSystems\PhalCMS\Lib;
 
use Phalcon\Autoload\Loader;
use Phalcon\Http\Response;
use Phalcon\Events\Event;
use Phalcon\Mvc\Application;
use Phalcon\Mvc\Dispatcher;
use Phalcon\Mvc\View;
use CLSystems\PhalCMS\Lib\Helper\Asset;
use CLSystems\PhalCMS\Lib\Helper\Config;
use CLSystems\PhalCMS\Lib\Helper\Uri;
use CLSystems\PhalCMS\Lib\Helper\State;
use CLSystems\PhalCMS\Lib\Helper\User;
use CLSystems\PhalCMS\Lib\Helper\Event as EventHelper;
use CLSystems\PhalCMS\Lib\Mvc\View\ViewBase;
use CLSystems\Php\Registry;
use MatthiasMullie\Minify;
use Exception;
 
class CmsApplication extends Application
{
    public function execute()
    {
        try {
            $eventsManager = $this->di->getShared('eventsManager');
            $eventsManager->attach('application:beforeSendResponse', $this);
            $plugins = EventHelper::getPlugins();
            $systemEvents = [
                'application:beforeSendResponse',
                'dispatch:beforeExecuteRoute',
                'dispatch:beforeException',
                'dispatch:beforeDispatch',
                'dispatch:afterDispatch',
                'dispatch:afterInitialize',
            ];
 
            foreach ($plugins['System'] as $className => $config) {
                $handler = EventHelper::getHandler($className, $config);
 
                foreach ($systemEvents as $systemEvent) {
                    $eventsManager->attach($systemEvent, $handler);
                }
            }
 
            // Update view dirs
            define('TPL_SITE_PATH', APP_PATH . '/Tmpl/Site/' . Config::get('siteTemplate', 'PhalCMS'));
            define('TPL_ADMINISTRATOR_PATH', APP_PATH . '/Tmpl/Administrator');
            define('TPL_SYSTEM_PATH', APP_PATH . '/Tmpl/System');
 
            if (Uri::isClient('site')) {
                $viewDirs = [
                    TPL_SITE_PATH . '/Tmpl/',
                    TPL_SITE_PATH . '/',
                ];
            } else {
                $viewDirs = [
                    TPL_ADMINISTRATOR_PATH . '/',
                ];
            }
 
            foreach (['System', 'Cms'] as $plgGroup) {
                if (isset($plugins[$plgGroup])) {
                    /**
                     * @var string $pluginClass
                     * @var Registry $pluginConfig
                     */
 
 
                    foreach ($plugins[$plgGroup] as $pluginClass => $pluginConfig) {
                        $pluginName = $pluginConfig->get('manifest.name');
                        $pluginPath = PLUGIN_PATH . '/' . $plgGroup . '/' . $pluginName;
                        $psrPaths = [];
 
                        if (is_dir($pluginPath . '/Tmpl')) {
                            $viewDirs[] = $pluginPath . '/Tmpl/';
                        }
 
                        if (is_dir($pluginPath . '/Lib')) {
                            $psrPaths['CLSystems\\PhalCMS\\Lib'] = $pluginPath . '/Lib';
                        }
 
                        if (is_dir($pluginPath . '/Widget')) {
                            $psrPaths['CLSystems\\PhalCMS\\Widget'] = $pluginPath . '/Widget';
                        }
 
                        if ($psrPaths) {
                            (new Loader)
                                ->setNamespaces($psrPaths, true)
                                ->register();
                        }
                    }
                }
            }
 
            $viewDirs[] = TPL_SYSTEM_PATH . '/';
 
            /** @var ViewBase $view */
            $view = $this->di->getShared('view');
            $requestUri = $_SERVER['REQUEST_URI'];
 
            if (Config::get('siteOffline') === 'Y'
                && !User::getInstance()->access('super')
            ) {
                $this->view->setMainView('Offline/Index');
 
                if (strpos($requestUri, '/user/') !== 0) {
                    $requestUri = '';
                }
            } else {
                $view->setMainView('Index');
            }
 
            $view->setViewsDir($viewDirs);
            $this->setEventsManager($eventsManager);
            $this->handle($requestUri)->send();
        } catch (Exception $e) {
            if (true === DEVELOPMENT_MODE) {
                // Let Phalcon Debug catch this
                throw $e;
            }
 
            try {
                if (User::getInstance()->access('super')) {
                    State::setMark('exception', $e);
                }
 
                /**
                 * @var Dispatcher $dispatcher
                 * @var View $view
                 */
                $dispatcher = $this->getDI()->getShared('dispatcher');
                $dispatcher->setControllerName(Uri::isClient('administrator') ? 'admin_error' : 'error');
                $dispatcher->setActionName('show');
                $dispatcher->setParams(
                    [
                        'code'    => $e->getCode(),
                        'message' => $e->getMessage(),
                    ]
                );
 
                $view = $this->getDI()->getShared('view');
                $view->start();
                $dispatcher->dispatch();
                $view->render(
                    $dispatcher->getControllerName(),
                    $dispatcher->getActionName(),
                    $dispatcher->getParams()
                );
                $view->finish();
                echo $view->getContent();
            } catch (Exception $e2) {
                debugVar($e2->getMessage());
            }
        }
    }
 
    protected function getCompressor($type)
    {
        if ('css' === $type) {
            $compressor = new Minify\CSS;
            $compressor->setImportExtensions(
                [
                    'gif' => 'data:image/gif',
                    'png' => 'data:image/png',
                    'svg' => 'data:image/svg+xml',
                ]
            );
        } else {
            $compressor = new Minify\JS;
        }
 
        return $compressor;
    }
 
    protected function compressAssets()
    {
        $basePath = PUBLIC_PATH . '/assets';
        $assets = Factory::getService('assets');
 
        foreach (Asset::getFiles() as $type => $files) {
            $fileName = md5(implode(':', $files)) . '.' . $type;
            $filePath = $basePath . '/compressed/' . $fileName;
            $fileUri = DOMAIN . '/assets/compressed/' . $fileName . (DEVELOPMENT_MODE ? '?' . time() : '');
            $hasAsset = is_file($filePath);
            $ucType = ucfirst($type);
            $addFunc = 'add' . $ucType;
 
            if ($hasAsset && !DEVELOPMENT_MODE) {
                call_user_func_array([$assets, $addFunc], [$fileUri, false]);
                continue;
            }
 
            $compressor = self::getCompressor($type);
 
            foreach ($files as $file) {
                $compressor->add($file);
            }
 
            if (!is_dir($basePath . '/compressed/')) {
                mkdir($basePath . '/compressed/', 0777, true);
            }
 
            if ($compressor->minify($filePath)) {
                @chmod($filePath, 0777);
                call_user_func_array([$assets, $addFunc], [$fileUri, false]);
            }
 
            unset($compressor);
        }
    }
 
    public function beforeSendResponse(Event $event, CmsApplication $app, Response $response)
    {
        $request = $this->di->getShared('request');
 
        if ($request->isAjax()) {
            return;
        }
 
        /** @var Asset $assets */
        $this->compressAssets();
        $assets = $this->di->getShared('assets');
 
        // Compress CSS
        ob_start();
        $assets->outputCss();
        $assets->outputInlineCss();
        $content = str_replace('</head>', ob_get_clean() . '</head>', $response->getContent());
 
        // Compress JS
        ob_start();
        $assets->outputJs();
        $assets->outputInlineJs();
        $code = Asset::getCode() . ob_get_clean();
 
        // Extra code (in the footer)
        $content = str_replace('</body>', $code . '</body>', $content);
        $response->setContent($content);
    }
}
#11CLSystems\PhalCMS\Lib\CmsApplication->execute
/var/www/html/almaliora.nl/public/index.php (14)
<?php
declare(strict_types=1);
 
error_reporting(E_ALL);
ini_set('display_errors', 'true');
 
use CLSystems\PhalCMS\Lib\Factory;
 
define('BASE_PATH', dirname(__DIR__));
 
require_once BASE_PATH . '/src/app/Lib/Factory.php';
 
// Execute application
Factory::getApplication()->execute();
KeyValue
_url/search/
qαπόκτηση ChatGPT λογαριασμού 👉🏻 acc6.top 👈🏻
KeyValue
PATH/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
TEMP/var/www/clients/client4/web15/tmp
TMPDIR/var/www/clients/client4/web15/tmp
TMP/var/www/clients/client4/web15/tmp
HOSTNAME
USERweb15
HOME/var/www/clients/client4/web15
SCRIPT_NAME/index.php
REQUEST_URI/search/?q=%CE%B1%CF%80%CF%8C%CE%BA%CF%84%CE%B7%CF%83%CE%B7+ChatGPT+%CE%BB%CE%BF%CE%B3%CE%B1%CF%81%CE%B9%CE%B1%CF%83%CE%BC%CE%BF%CF%8D+%F0%9F%91%89%F0%9F%8F%BB+acc6.top+%F0%9F%91%88%F0%9F%8F%BB
QUERY_STRING_url=/search/&q=%CE%B1%CF%80%CF%8C%CE%BA%CF%84%CE%B7%CF%83%CE%B7+ChatGPT+%CE%BB%CE%BF%CE%B3%CE%B1%CF%81%CE%B9%CE%B1%CF%83%CE%BC%CE%BF%CF%8D+%F0%9F%91%89%F0%9F%8F%BB+acc6.top+%F0%9F%91%88%F0%9F%8F%BB
REQUEST_METHODGET
SERVER_PROTOCOLHTTP/1.1
GATEWAY_INTERFACECGI/1.1
REDIRECT_QUERY_STRING_url=/search/&q=%CE%B1%CF%80%CF%8C%CE%BA%CF%84%CE%B7%CF%83%CE%B7+ChatGPT+%CE%BB%CE%BF%CE%B3%CE%B1%CF%81%CE%B9%CE%B1%CF%83%CE%BC%CE%BF%CF%8D+%F0%9F%91%89%F0%9F%8F%BB+acc6.top+%F0%9F%91%88%F0%9F%8F%BB
REDIRECT_URL/search/
REMOTE_PORT24670
SCRIPT_FILENAME/var/www/clients/client4/web15/web/index.php
SERVER_ADMINwebmaster@almaliora.nl
CONTEXT_DOCUMENT_ROOT/var/www/clients/client4/web15/web
CONTEXT_PREFIX
REQUEST_SCHEMEhttps
DOCUMENT_ROOT/var/www/clients/client4/web15/web
REMOTE_ADDR216.73.216.221
SERVER_PORT443
SERVER_ADDR178.18.244.9
SERVER_NAMEalmaliora.nl
SERVER_SOFTWAREApache
SERVER_SIGNATURE
HTTP_HOSTalmaliora.nl
HTTP_COOKIEcms.site.language=m94oStAlSWC9nRdCwld5slzbOVhvUU5AhMfA8GAPP%2F53kCg6QebTdRPQ9H0bNzBkf%2F8AXZc%3D; PHPSESSID=83c0eiqqihka0mcaabkcsueqaa
HTTP_REFERERhttps://almaliora.nl/search?q=%CE%B1%CF%80%CF%8C%CE%BA%CF%84%CE%B7%CF%83%CE%B7+ChatGPT+%CE%BB%CE%BF%CE%B3%CE%B1%CF%81%CE%B9%CE%B1%CF%83%CE%BC%CE%BF%CF%8D+%F0%9F%91%89%F0%9F%8F%BB+acc6.top+%F0%9F%91%88%F0%9F%8F%BB
HTTP_ACCEPT_ENCODINGgzip, br, zstd, deflate
HTTP_USER_AGENTMozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_ACCEPT*/*
proxy-nokeepalive1
SSL_TLS_SNIalmaliora.nl
HTTPSon
REDIRECT_STATUS200
REDIRECT_SSL_TLS_SNIalmaliora.nl
REDIRECT_HTTPSon
FCGI_ROLERESPONDER
PHP_SELF/index.php
REQUEST_TIME_FLOAT1765177806.0778
REQUEST_TIME1765177806
#Path
0/var/www/html/almaliora.nl/public/index.php
1/var/www/html/almaliora.nl/src/app/Lib/Factory.php
2/var/www/html/almaliora.nl/src/app/Config/Define.php
3/var/www/html/almaliora.nl/src/app/Config/Loader.php
4/var/www/html/almaliora.nl/vendor/autoload.php
5/var/www/html/almaliora.nl/vendor/composer/autoload_real.php
6/var/www/html/almaliora.nl/vendor/composer/platform_check.php
7/var/www/html/almaliora.nl/vendor/composer/ClassLoader.php
8/var/www/html/almaliora.nl/vendor/composer/autoload_static.php
9/var/www/html/almaliora.nl/vendor/phpunit/phpunit/src/Framework/Assert/Functions.php
10/var/www/html/almaliora.nl/vendor/symfony/deprecation-contracts/function.php
11/var/www/html/almaliora.nl/vendor/symfony/polyfill-php80/bootstrap.php
12/var/www/html/almaliora.nl/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
13/var/www/html/almaliora.nl/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
14/var/www/html/almaliora.nl/vendor/ralouphie/getallheaders/src/getallheaders.php
15/var/www/html/almaliora.nl/vendor/guzzlehttp/psr7/src/functions_include.php
16/var/www/html/almaliora.nl/vendor/guzzlehttp/psr7/src/functions.php
17/var/www/html/almaliora.nl/vendor/symfony/polyfill-mbstring/bootstrap.php
18/var/www/html/almaliora.nl/vendor/symfony/polyfill-mbstring/bootstrap80.php
19/var/www/html/almaliora.nl/vendor/guzzlehttp/promises/src/functions_include.php
20/var/www/html/almaliora.nl/vendor/guzzlehttp/promises/src/functions.php
21/var/www/html/almaliora.nl/vendor/symfony/polyfill-php72/bootstrap.php
22/var/www/html/almaliora.nl/vendor/symfony/polyfill-ctype/bootstrap.php
23/var/www/html/almaliora.nl/vendor/symfony/polyfill-ctype/bootstrap80.php
24/var/www/html/almaliora.nl/vendor/symfony/polyfill-intl-idn/bootstrap.php
25/var/www/html/almaliora.nl/vendor/guzzlehttp/guzzle/src/functions_include.php
26/var/www/html/almaliora.nl/vendor/guzzlehttp/guzzle/src/functions.php
27/var/www/html/almaliora.nl/vendor/symfony/polyfill-intl-grapheme/bootstrap.php
28/var/www/html/almaliora.nl/vendor/symfony/string/Resources/functions.php
29/var/www/html/almaliora.nl/vendor/symfony/polyfill-php73/bootstrap.php
30/var/www/html/almaliora.nl/vendor/phpseclib/phpseclib/phpseclib/bootstrap.php
31/var/www/html/almaliora.nl/vendor/myclabs/deep-copy/src/DeepCopy/deep_copy.php
32/var/www/html/almaliora.nl/vendor/google/apiclient-services/autoload.php
33/var/www/html/almaliora.nl/vendor/facebook/graph-sdk/src/Facebook/polyfills.php
34/var/www/html/almaliora.nl/vendor/phalcon/dd/src/helper.php
35/var/www/html/almaliora.nl/vendor/codeception/codeception/functions.php
36/var/www/html/almaliora.nl/vendor/google/apiclient/src/aliases.php
37/var/www/html/almaliora.nl/vendor/google/apiclient/src/Client.php
38/var/www/html/almaliora.nl/vendor/google/apiclient/src/Service.php
39/var/www/html/almaliora.nl/vendor/google/apiclient/src/AccessToken/Revoke.php
40/var/www/html/almaliora.nl/vendor/google/apiclient/src/AccessToken/Verify.php
41/var/www/html/almaliora.nl/vendor/google/apiclient/src/Model.php
42/var/www/html/almaliora.nl/vendor/google/apiclient/src/Utils/UriTemplate.php
43/var/www/html/almaliora.nl/vendor/google/apiclient/src/AuthHandler/Guzzle6AuthHandler.php
44/var/www/html/almaliora.nl/vendor/google/apiclient/src/AuthHandler/Guzzle7AuthHandler.php
45/var/www/html/almaliora.nl/vendor/google/apiclient/src/AuthHandler/Guzzle5AuthHandler.php
46/var/www/html/almaliora.nl/vendor/google/apiclient/src/AuthHandler/AuthHandlerFactory.php
47/var/www/html/almaliora.nl/vendor/google/apiclient/src/Http/Batch.php
48/var/www/html/almaliora.nl/vendor/google/apiclient/src/Http/MediaFileUpload.php
49/var/www/html/almaliora.nl/vendor/google/apiclient/src/Http/REST.php
50/var/www/html/almaliora.nl/vendor/google/apiclient/src/Task/Retryable.php
51/var/www/html/almaliora.nl/vendor/google/apiclient/src/Task/Exception.php
52/var/www/html/almaliora.nl/vendor/google/apiclient/src/Exception.php
53/var/www/html/almaliora.nl/vendor/google/apiclient/src/Task/Runner.php
54/var/www/html/almaliora.nl/vendor/google/apiclient/src/Collection.php
55/var/www/html/almaliora.nl/vendor/google/apiclient/src/Service/Exception.php
56/var/www/html/almaliora.nl/vendor/google/apiclient/src/Service/Resource.php
57/var/www/html/almaliora.nl/vendor/google/apiclient/src/Task/Composer.php
58/var/www/html/almaliora.nl/vendor/clsystems/php-registry/src/Registry.php
59/var/www/html/almaliora.nl/src/app/Lib/Helper/Config.php
60/var/www/html/almaliora.nl/src/app/Lib/Helper/Asset.php
61/var/www/html/almaliora.nl/src/app/Lib/Mvc/View/ViewBase.php
62/var/www/html/almaliora.nl/src/app/Lib/Helper/Volt.php
63/var/www/html/almaliora.nl/src/app/Lib/CmsApplication.php
64/var/www/html/almaliora.nl/src/app/Lib/Helper/Language.php
65/var/www/html/almaliora.nl/src/app/Lib/Helper/FileSystem.php
66/var/www/html/almaliora.nl/src/app/Language/en-GB/Locale.php
67/var/www/html/almaliora.nl/src/app/Language/nl-NL/Locale.php
68/var/www/html/almaliora.nl/src/app/Lib/Helper/Uri.php
69/var/www/html/almaliora.nl/src/app/Language/nl-NL/nl-NL.php
70/var/www/html/almaliora.nl/src/app/Lib/Helper/Event.php
71/var/www/html/almaliora.nl/src/app/Lib/Mvc/Model/Config.php
72/var/www/html/almaliora.nl/src/app/Lib/Mvc/Model/ModelBase.php
73/var/www/html/almaliora.nl/src/app/Plugin/Cms/OutLink/OutLink.php
74/var/www/html/almaliora.nl/src/app/Lib/Plugin.php
75/var/www/html/almaliora.nl/src/app/Plugin/Cms/SiteMap/SiteMap.php
76/var/www/html/almaliora.nl/src/app/Plugin/Cms/SiteMap/Language/nl-NL.php
77/var/www/html/almaliora.nl/src/app/Plugin/Cms/SocialLogin/SocialLogin.php
78/var/www/html/almaliora.nl/src/app/Plugin/System/Backup/Backup.php
79/var/www/html/almaliora.nl/src/app/Plugin/System/Backup/Language/nl-NL.php
80/var/www/html/almaliora.nl/src/app/Plugin/System/Cms/Cms.php
81/var/www/html/almaliora.nl/src/app/Config/Router.php
82/var/www/html/almaliora.nl/src/app/Config/Router/Site.php
83/var/www/html/almaliora.nl/src/app/Lib/Mvc/Controller/SearchController.php
84/var/www/html/almaliora.nl/src/app/Lib/Mvc/Controller/ControllerBase.php
85/var/www/html/almaliora.nl/src/app/Lib/Helper/User.php
86/var/www/html/almaliora.nl/src/app/Lib/Helper/State.php
87/var/www/html/almaliora.nl/src/app/Lib/Mvc/Model/User.php
88/var/www/html/almaliora.nl/src/app/Lib/Helper/Text.php
89/var/www/html/almaliora.nl/cache/volt/Tmpl_System_Search_Result.volt.php
90/var/www/html/almaliora.nl/src/app/Lib/Mvc/Model/UcmItem.php
Memory
Usage2097152