Ruft fehler bei dem Datenbank

[liebewinter]

hallo, ich habe meine Webseite mit Oxid gebaut...

Die Probleme ist, dass der Datenbank fehler macht...

Ich habe nach dem Fehler gesucht in der Logdatei, sie sagt,

[2020-08-17 12:19:16] OXID Logger.ERROR: Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' ["[object] (OxidEsales\Eshop\Core\Exception\DatabaseErrorException(code: 1267): Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' at /home/kalamulu/public_html/mela/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php:925, Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing 'select\n oxvarname, oxvartype, DECODE( oxvarvalue, 'fq45QS09_fqyx09239QQ') as oxvarvalue\n from oxconfig\n where oxshopid = ? and oxmodule LIKE ?' with params [1, "\x74\x68\x65\x6d\x65\x3a\x14\x28\x0d\x4c\x97\xa5\xee\xaa\x20\xb8\x1a\x7b\x1e\x57\x25"]:\n\nSQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' at /home/kalamulu/public_html/mela/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:106, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' at /home/kalamulu/public_html/mela/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:129, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_general_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' at /home/kalamulu/public_html/mela/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:127)\n[stacktrace]\n#0 /home/kalamulu/public_html/mela/vendor/oxid-esales/oxideshop-ce/source/Core/Database/Adapter/Doctrine/Database.php(998): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->convertException(Object(Doctrine\DBAL\Exception\DriverException))\n#1 /home/kalamulu/public_html/mela/vendor/oxid-esales/oxideshop-ce/source/Core/Config.php(582): OxidEsales\EshopCommunity\Core\Database\Adapter\Doctrine\Database->getAll('select\n ...', Array)\n#2 /home/kalamulu/public_html/mela/vendor/oxid-esales/oxideshop-ce/source/Core/Config.php(400): OxidEsales\EshopCommunity\Core\Config->_loadVarsFromDb(1, NULL, 'theme:\x14(\rL\x97\xA5\xEE\xAA ...')\n#3 /home/kalamulu/public_html/mela/vendor/oxid-esales/oxideshop-ce/source/Core/Config.php(437): OxidEsales\EshopCommunity\Core\Config->initVars(1)\n#4 /home/kalamulu/public_html/mela/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(590): OxidEsales\EshopCommunity\Core\Config->init()\n#5 /home/kalamulu/public_html/mela/vendor/oxid-esales/oxideshop-ce/source/Core/ShopControl.php(136): OxidEsales\EshopCommunity\Core\ShopControl->_runOnce()\n#6 /home/kalamulu/public_html/mela/vendor/oxid-esales/oxideshop-ce/source/Core/Oxid.php(27): OxidEsales\EshopCommunity\Core\ShopControl->start()\n#7 /home/kalamulu/public_html/mela/source/index.php(16): OxidEsales\EshopCommunity\Core\Oxid::run()\n#8 {main}\n"] []

Ich habe nach diese Probleme gesucht, und habe dieses gefunde...

Ich versuche die Lösung zu folgen, aber als meine fehlende Kenntnisse von Datenbank, bekomme Fehler...

Auf der MySQL Kommando schreibe,

SHOW CREATE TABLE oxconfigdisplay;

bekomme keine Fehler

dann schreibe,

ALTER TABLE OXCONFIG CHANGE OXID latin1_general_ci CHARACTER SET utf8 COLLATE utf8_general_ci;

und Mysql sagt,

#1064 - Fehler in der SQL-Syntax. Bitte die korrekte Syntax im Handbuch nachschlagen bei 'SET utf8 COLLATE utf8_general_ci' in Zeile 1

so, wie verstand habe.., ist diese teile die Fehler macht CHARACTER SET utf8 COLLATE utf8_general_ci

Ich habe versuche verändert von CHARACTER SET utf8 nach CHARACTER SET UTF8 aber immer bekomme gleiche Fehler...