# SQL Fehler **URL:** \ **Category:** Programmierung\ **Created:** [18. Oktober 2019 um 21:34 UTC](https://forum.shopware.com/t/sql-fehler/62491 "2019-10-18T21:34:41Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![shabby](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@shabby](https://forum.shopware.com/u/shabby)\ **Post date:** [18. Oktober 2019 um 21:34 UTC](https://forum.shopware.com/t/sql-fehler/62491/1 "2019-10-18T21:34:41Z")
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 ```     ---
**Author:** ![R4M](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/r4m/32/9983_2.png) [@R4M](https://forum.shopware.com/u/R4M)\ **Post date:** [21. Oktober 2019 um 07:26 UTC](https://forum.shopware.com/t/sql-fehler/62491/2 "2019-10-21T07:26:49Z")
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. ---
**Author:** ![shyim](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/shyim/32/7681_2.png) [@shyim](https://forum.shopware.com/u/shyim)\ **Post date:** [21. Oktober 2019 um 16:25 UTC](https://forum.shopware.com/t/sql-fehler/62491/3 "2019-10-21T16:25:12Z")
Stell die Tabellen vom Plugin auf utf8\_unicode\_ci um. utf8\_unicode\_ci ist in Shopware 5 das richtige collate ---
**Author:** ![shabby](https://avatars.discourse-cdn.com/v4/letter/s/a6a055/32.png) [@shabby](https://forum.shopware.com/u/shabby)\ **Post date:** [28. Oktober 2019 um 10:40 UTC](https://forum.shopware.com/t/sql-fehler/62491/4 "2019-10-28T10:40:20Z")
Der erweiterte Merkzettel war schuld. Deaktiviert und für Scheiße befunden. 😉