# Plugin Advanced Cart - Fehler nach Update auf 1.2.2

**URL:** <https://forum.shopware.com/t/plugin-advanced-cart-fehler-nach-update-auf-1-2-2/41189>\
**Category:** Allgemein\
**Created:** [8. November 2016 um 10:52 UTC](https://forum.shopware.com/t/plugin-advanced-cart-fehler-nach-update-auf-1-2-2/41189 "2016-11-08T10:52:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Liverson](https://avatars.discourse-cdn.com/v4/letter/l/b19c9b/32.png) [@Liverson](https://forum.shopware.com/u/Liverson)\
**Post date:** [8. November 2016 um 10:52 UTC](https://forum.shopware.com/t/plugin-advanced-cart-fehler-nach-update-auf-1-2-2/41189/1 "2016-11-08T10:52:58Z")

</div>

Habe eben in Shopware-Version 5.2.9 ein Update des Plugins Advanced Cart auf 1.2.2 gemacht. Leider erzeugt der Aufruf der Wishlist jetzt folgende Fehlermeldung:  
Hat jemand eine Idee, wie ich das auf die schnelle lösen kann?

An exception occurred while executing ‚SELECT s0\_.id AS id\_0, s0\_.cookie\_value AS cookie\_value\_1, s0\_.expire AS expire\_2, s0\_.modified AS modified\_3, s0\_.name AS name\_4, s0\_.shop\_id AS shop\_id\_5, s0\_.published AS published\_6, s1\_.id AS id\_7, s1\_.basket\_id AS basket\_id\_8, s1\_.article\_ordernumber AS article\_ordernumber\_9, s1\_.quantity AS quantity\_10, s2\_.id AS id\_11, s2\_.articleID AS articleID\_12, s2\_.unitID AS unitID\_13, s2\_.ordernumber AS ordernumber\_14, s2\_.suppliernumber AS suppliernumber\_15, s2\_.kind AS kind\_16, s2\_.additionaltext AS additionaltext\_17, s2\_.active AS active\_18, s2\_.instock AS instock\_19, s2\_.stockmin AS stockmin\_20, s2\_.weight AS weight\_21, s2\_.width AS width\_22, s2\_.length AS length\_23, s2\_.height AS height\_24, s2\_.ean AS ean\_25, s2\_.purchaseprice AS purchaseprice\_26, s2\_.position AS position\_27, s2\_.minpurchase AS minpurchase\_28, s2\_.purchasesteps AS purchasesteps\_29, s2\_.maxpurchase AS maxpurchase\_30, s2\_.purchaseunit AS purchaseunit\_31, s2\_.referenceunit AS referenceunit\_32, s2\_.packunit AS packunit\_33, s2\_.shippingfree AS shippingfree\_34, s2\_.releasedate AS releasedate\_35, s2\_.shippingtime AS shippingtime\_36, s0\_.user\_id AS user\_id\_37, s0\_.shop\_id AS shop\_id\_38, s1\_.basket\_id AS basket\_id\_39, s1\_.article\_ordernumber AS article\_ordernumber\_40, s2\_.articleID AS articleID\_41, s2\_.unitID AS unitID\_42 FROM s\_order\_basket\_saved s0\_ LEFT JOIN s\_user s3\_ ON s0\_.user\_id = s3\_.id LEFT JOIN s\_order\_basket\_saved\_items s1\_ ON s0\_.id = s1\_.basket\_id LEFT JOIN s\_articles\_details s2\_ ON s1\_.article\_ordernumber = s2\_.ordernumber WHERE s3\_.id = ? AND s0\_.shop\_id = ? AND LENGTH(s0\_.name) \> 0 ORDER BY s1\_.id DESC‘ with params [„4“, 1]: 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 s0\_.id A...', Array) #1 vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(50): Doctrine\DBAL\Connection-\>executeQuery('SELECT s0\_.id A...', Array, Array, NULL) #2 vendor/doctrine/orm/lib/Doctrine/ORM/Query.php(321): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>execute(Object(Doctrine\DBAL\Connection), Array, Array) #3 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(969): Doctrine\ORM\Query-\>\_doExecute() #4 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(924): Doctrine\ORM\AbstractQuery-\>executeIgnoreQueryCache(NULL, 1) #5 vendor/doctrine/orm/lib/Doctrine/ORM/AbstractQuery.php(727): Doctrine\ORM\AbstractQuery-\>execute(NULL, 1) #6 engine/Shopware/Plugins/Community/Frontend/SwagAdvancedCart/Controllers/Frontend/Wishlist.php(1113): Doctrine\ORM\AbstractQuery-\>getResult() #7 engine/Shopware/Plugins/Community/Frontend/SwagAdvancedCart/Controllers/Frontend/Wishlist.php(1126): Shopware\_Controllers\_Frontend\_Wishlist-\>getCarts('4') #8 engine/Shopware/Plugins/Community/Frontend/SwagAdvancedCart/Controllers/Frontend/Wishlist.php(115): Shopware\_Controllers\_Frontend\_Wishlist-\>prepareCarts('4') #9 engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Frontend\_Wishlist-\>indexAction() #10 engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight\_Controller\_Action-\>dispatch('indexAction') #11 engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #12 engine/Shopware/Kernel.php(177): Enlight\_Controller\_Front-\>dispatch() #13 vendor/symfony/http-kernel/HttpCache/HttpCache.php(487): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 engine/Shopware/Components/HttpCache/AppCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 vendor/symfony/http-kernel/HttpCache/HttpCache.php(444): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>fetch(Object(Symfony\Component\HttpFoundation\Request), true) #17 engine/Shopware/Components/HttpCache/AppCache.php(178): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #18 vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache-\>lookup(Object(Symfony\Component\HttpFoundation\Request), true) #19 engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #20 shopware.php(113): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request)) #21 {main}
```

---

<div class="post-metadata">

**Author:** ![Liverson](https://avatars.discourse-cdn.com/v4/letter/l/b19c9b/32.png) [@Liverson](https://forum.shopware.com/u/Liverson)\
**Post date:** [8. November 2016 um 11:53 UTC](https://forum.shopware.com/t/plugin-advanced-cart-fehler-nach-update-auf-1-2-2/41189/2 "2016-11-08T11:53:18Z")

</div>

Die Fehlermeldung sagts eigentlich eh schon. Die Default-Einstellung der Mysql-DB war utf8\_general\_ci.&nbsp;

Bei Plugins wo beim Erstellen neuer Tabllen&nbsp;nicht explizit die Kollation angegeben ist wurde dann in dem Fall utf8\_general erzeugt. Bei JOINS über verschiedene Kollationen kommt´s dann zu dem obigen Problem. Habe nun die Tabellen und die Felder entsprechend auf utf8\_unicode\_ci umgestellt, dann gehts wieder