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}