# Fehler beim öffnen des Business Essensials Plugins **URL:** \ **Category:** Plugins\ **Tags:** offizielle-shopware-\ **Created:** [16. Dezember 2016 um 11:39 UTC](https://forum.shopware.com/t/fehler-beim-offnen-des-business-essensials-plugins/42242 "2016-12-16T11:39:22Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Shopwareianer](https://avatars.discourse-cdn.com/v4/letter/s/b4bc9f/32.png) [@Shopwareianer](https://forum.shopware.com/u/Shopwareianer)\ **Post date:** [16. Dezember 2016 um 11:39 UTC](https://forum.shopware.com/t/fehler-beim-offnen-des-business-essensials-plugins/42242/1 "2016-12-16T11:39:22Z")
Ich bekomme beim öffnen des Business Essensials Plugins folgenden Fehler: ``` Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing 'SELECT COUNT(groups.id) FROM s_core_customergroups groups LEFT JOIN s_core_plugins_b2b_cgsettings cgSettings ON cgSettings.customergroup = groups.groupkey WHERE cgSettings.allowregister = 1 OR groups.groupkey = "H" LIMIT 25 OFFSET 0': SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=' in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119 ``` Verwendet wird die aktuellste Shopware Version, als auch das aktuelleste BE Plugin. Hierzu fand ich folgenden Stack Artikel: [http://stackoverflow.com/questions/3029321/troubleshooting-illegal-mix-of-collations-error-in-mysql](http://stackoverflow.com/questions/3029321/troubleshooting-illegal-mix-of-collations-error-in-mysql) Nun frage ich mich allerdings, ob das ganze ein Bug im BE Plugin ist? Gehört die Tabelle s\_core\_plugins\_b2b\_cgsettings zum BE Plugin, oder ist es irgendein Custom Plugin? Habe noch nie mit dem Plugin gearbeitet 🙂 ---
**Author:** ![shcshopware](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@shcshopware](https://forum.shopware.com/u/shcshopware)\ **Post date:** [23. Dezember 2016 um 15:54 UTC](https://forum.shopware.com/t/fehler-beim-offnen-des-business-essensials-plugins/42242/2 "2016-12-23T15:54:55Z")
Hallo, ich habe das gleiche Problem. Meine Fehlermeldung lautet: Register “Anfrageverwaltung” Shopware 5.2.12 BE 3.0.1 503 Service unavailable **Wie kann ich das Problem beheben?** Ups! Ein Fehler ist aufgetreten! Die nachfolgenden Hinweise sollten Ihnen weiterhelfen. An exception occurred while executing ‘SELECT COUNT(groups.id) FROM s\_core\_customergroups groups LEFT JOIN s\_core\_plugins\_b2b\_cgsettings cgSettings ON cgSettings.customergroup = groups.groupkey WHERE cgSettings.allowregister = 1 OR groups.groupkey = “H” LIMIT 25 OFFSET 0’: SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8\_general\_ci,IMPLICIT) and (utf8\_unicode\_ci,IMPLICIT) for operation ‘=’ in vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119 Stack trace: #0 vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), ‘SELECT COUNT(gr…’, Array) #1 vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection-\>executeQuery(‘SELECT COUNT(gr…’, Array, Array) #2 custom/plugins/SwagBusinessEssentials/Controllers/Backend/SwagBusinessEssentials.php(229): Doctrine\DBAL\Query\QueryBuilder-\>execute() #3 custom/plugins/SwagBusinessEssentials/Controllers/Backend/SwagBusinessEssentials.php(127): Shopware\_Controllers\_Backend\_SwagBusinessEssentials-\>getResult(Object(Doctrine\DBAL\Query\QueryBuilder)) #4 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_SwagBusinessEssentials-\>getRegisterTemplatesAction() #5 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch(‘getRegisterTemp…’) #6 engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #7 engine/Shopware/Kernel.php(178): Enlight\_Controller\_Front-\>dispatch() #8 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #9 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #10 vendor/symfony/http-kernel/HttpCache/HttpCache.php(258): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #11 engine/Shopware/Components/HttpCache/AppCache.php(103): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true) #12 shopware.php(113): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #13 {main}   _OK_ ---
**Author:** ![Moritz\_Naczenski](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.shopware.com/moritz_naczenski/32/7792_2.png) [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)\ **Post date:** [23. Dezember 2016 um 16:08 UTC](https://forum.shopware.com/t/fehler-beim-offnen-des-business-essensials-plugins/42242/3 "2016-12-23T16:08:01Z")
Passiert wohl, wenn die Datenbank eine andere Standard-Coallation hat. Kann man mit diesem Querry fixen: ``` ALTER TABLE s_core_plugins_b2b_cgsettings CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE s_core_plugins_b2b_private CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE s_core_plugins_b2b_tpl_config CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ALTER TABLE s_core_plugins_b2b_tpl_variables CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci; ```