Hallo,
ich habe einen neuen Shopware Shop angelegt und Kategorien und Artikel aus einem Zulieferer Shop (auch Shopware) importiert. Standardversand ist angelegt, SSL Haken gesetzt. Attr4 und Attr5 konfiguriert und befüllt aber bisher nicht in Gebrauch. Keine Plugins installiert, sicherheitshalber habe ich sogar das Paypal Plugin deinstalliert.
Es können keine Artikel in den Warenkorb gelegt werden, der Warenkorb lädt endlos.
Ich kann ein gekauftes Plugin nicht installieren, läuft auch endlos.
Auch bekomme ich beim einloggen und abmelden eines Users eine Fehlermeldung, siehe unten.
Ich nutze die aktuellste Shopware Version mit PHP 8.0.14.
Kenne mich mit Queries leider nicht wirklich aus, kann mir jemand sagen wo ich nach dem Fehler suchen muss?
Shop: www.fms-exhaust.de
Ups! Ein Fehler ist aufgetreten!
Die nachfolgenden Hinweise sollten Ihnen weiterhelfen.
An exception occurred while executing ‚SELECT MIN(d.instock>=b.quantity) as instock, MIN(d.instock>=(b.quantity+d.stockmin)) as stockmin, MIN(a.laststock) as laststock, SUM(d.weightb.quantity) as weight, SUM(IF(a.id,b.quantity,0)) as count_article, MAX(b.shippingfree) as shippingfree, SUM(IF(b.modus=0,b.quantityCAST(b.price as DECIMAL(10,2))/b.currencyFactor,0)) as amount, SUM(IF(b.modus=0,b.quantity*ROUND(CAST(b.price as DECIMAL(10,2))/(100+t.tax)*100,2)/b.currencyFactor,0)) as amount_net, SUM(CAST(b.price as DECIMAL(10,2))*b.quantity) as amount_display, MAX(d.length) as length, MAX(d.height) as height, MAX(d.width) as width, u.id as userID, MAX(a.topseller) as has_topseller, MAX(at.attr3) as has_comment, MAX(b.esdarticle) as has_esd, FROM s_order_basket b LEFT JOIN s_articles a ON b.articleID = a.id AND b.modus = 0 AND b.esdarticle = 0 LEFT JOIN s_user u ON u.id = ? AND u.active = 1 LEFT JOIN s_articles_details d ON (d.ordernumber = b.ordernumber) AND d.articleID = a.id LEFT JOIN s_core_tax t ON t.id = a.taxID LEFT JOIN s_articles_attributes at ON at.articledetailsID = d.id LEFT JOIN s_user_addresses ub ON ub.user_id = u.id AND ub.id = ? LEFT JOIN s_user_addresses us ON us.user_id = u.id AND us.id = ? WHERE b.sessionID = ? GROUP BY b.sessionID‘ with params [2, 2, 2, „euv0ljgrv5mg6622o5r29q2g5h“]: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‚FROM s_order_basket b LEFT JOIN s_articles a ON b.articleID = a.id AND b.modus =‘ at line 1 in /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 98
Stack trace:
#0 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException() #1 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException() #2 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException::driverExceptionDuringQuery() #3 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection->handleExceptionDuringQuery() #4 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(212): Doctrine\DBAL\Connection->executeQuery() #5 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Core/sAdmin.php(2607): Doctrine\DBAL\Query\QueryBuilder->execute() #6 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Core/sAdmin.php(3030): sAdmin->sGetDispatchBasket() #7 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Core/sBasket.php(2088): sAdmin->sGetPremiumShippingcosts() #8 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Components/Cart/CartMigration.php(85): sBasket->sRefreshBasket() #9 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Core/sAdmin.php(3264): Shopware\Components\Cart\CartMigration->migrate() #10 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Core/sAdmin.php(844): sAdmin->loginUser() #11 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Controllers/Frontend/Account.php(276): sAdmin->sLogin() #12 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Library/Enlight/Controller/Action.php(182): Shopware_Controllers_Frontend_Account->loginAction() #13 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(461): Enlight_Controller_Action->dispatch() #14 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Library/Enlight/Controller/Front.php(225): Enlight_Controller_Dispatcher_Default->dispatch() #15 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Kernel.php(197): Enlight_Controller_Front->dispatch() #16 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(85): Shopware\Kernel->handle() #17 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(479): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle() #18 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward() #19 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(269): Shopware\Components\HttpCache\AppCache->forward() #20 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(285): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass() #21 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(147): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate() #22 /var/www/vhosts/fms-exhaust.de/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(213): Shopware\Components\HttpCache\AppCache->invalidate() #23 /var/www/vhosts/fms-exhaust.de/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(117): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle() #24 /var/www/vhosts/fms-exhaust.de/httpdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle() #25 {main}
Besten Dank vorab für Tipps.
Grüsse
Ana