SQL Fehler

Hallo!

Habe seit drei Tagen diese drei Fehler, die immer wieder zusammen auftauchen, hat jemand eine Tipp wie man den behebt? So wie ich das sehe sind das Kunden die sich anmelden wollen. Kunden berichteten, dass beim Einloggen eine nichtssagende Fehlermeldung kam alla: UPS! Es ist ein Fehler aufgetreten…usw.

SQLSTATE(HY000): General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

 

SQLSTATE(HY000): General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

PDOException: SQLSTATE(HY000): General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=' in /engine/Library/Zend/Db/Statement/Pdo.php:219 Stack trace:
#0 /engine/Library/Zend/Db/Statement/Pdo.php(219): PDOStatement->execute(Array)
#1 /engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)
#2 /engine/Library/Zend/Db/Adapter/Abstract.php(472): Zend_Db_Statement->execute(Array)
#3 /engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('\n UP...', Array)
#4 /engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(83): Zend_Db_Adapter_Pdo_Abstract->query('\n UP...', Array)
#5 /engine/Shopware/Plugins/Community/Frontend/CoeAdvancedNotes/Subscriber/FrontendSubscriber.php(442): Enlight_Components_Db_Adapter_Pdo_Mysql->query('\n UP...', Array)
#6 /engine/Shopware/Plugins/Community/Frontend/CoeAdvancedNotes/Subscriber/FrontendSubscriber.php(388): CoeAdvancedNotes\Subscriber\FrontendSubscriber->assignSessionListToUser('15250', 'MrEpiz8sAIKCost...')
#7 /engine/Library/Enlight/Event/Handler/Default.php(87): CoeAdvancedNotes\Subscriber\FrontendSubscriber->onSuccessfulLogin(Object(Enlight_Event_EventArgs))
#8 /engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Default->execute(Object(Enlight_Event_EventArgs))
#9 /engine/Shopware/Core/sAdmin.php(3210): Enlight_Event_EventManager->notify('Shopware_Module...', Object(Enlight_Event_EventArgs))
#10 /engine/Shopware/Core/sAdmin.php(843): sAdmin->loginUser(Array, 'funny-anke@onli...', '$2y$10$xZAHSBGq...', false, 'bcrypt', '++++++++', '$2y$10$xZAHSBGq...')
#11 /engine/Shopware/Controllers/Frontend/Account.php(266): sAdmin->sLogin()
#12 /engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Frontend_Account->loginAction()
#13 /engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch('loginAction')
#14 /engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#15 /engine/Shopware/Kernel.php(185): Enlight_Controller_Front->dispatch()
#16 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#17 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#18 /engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#19 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#20 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#21 /engine/Shopware/Components/HttpCache/AppCache.php(138): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true)
#22 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(181): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true)
#23 /engine/Shopware/Components/HttpCache/AppCache.php(110): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#24 /var/www/clients/client1/web1/web/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#25

 

 

Zunächst liegt der Verdacht nahe, dass dieser Fehler mit dem Plugin „CoeAdvancedNotes“ im Zusammenhang steht. Vielleicht dieses Teil mal deaktivieren bzw. deinstallieren und neu versuchen.

Stell die Tabellen vom Plugin auf utf8_unicode_ci um. utf8_unicode_ci ist in Shopware 5 das richtige collate

Der erweiterte Merkzettel war schuld. Deaktiviert und für Scheiße befunden. :wink: