Hallo!
Ich habe bei mir einen zubuchbaren Artikel “Zust0000” der für eine Zustellung vor ort ist.
Wenn diese im Warenkorn ist, sollten alle anderen Versandarten ausgeblendet werden und nur Zustellung aufscheinen.
Hasbe folgendes eingetragen: IF(b.ordernumber like ‘%Zust%’,1,0) alternativ IF(d.ordernumber like ‘%Zust%’,1,0)
Folgendes passiert im LOG
PDOException: SQLSTATE(42S22): Column not found: 1054 Unknown column 'b.ordernumber' in 'where clause' in /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:907 Stack trace:
#0 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(907): PDOStatement->execute()
#1 /vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery('SELECT d.id as ...', Array, Array)
#2 /engine/Shopware/Core/sAdmin.php(2789): Doctrine\DBAL\Query\QueryBuilder->execute()
#3 /engine/Shopware/Controllers/Frontend/Checkout.php(1590): sAdmin->sGetPremiumDispatches('2', NULL, NULL)
#4 /engine/Shopware/Controllers/Frontend/Checkout.php(749): Shopware_Controllers_Frontend_Checkout->getSelectedDispatch()
#5 /engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Frontend_Checkout->shippingPaymentAction()
#6 /engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch('shippingPayment...')
#7 /engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#8 /engine/Shopware/Kernel.php(185): Enlight_Controller_Front->dispatch()
#9 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#10 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#11 /engine/Shopware/Components/HttpCache/AppCache.php(256): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#12 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(420): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#13 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(317): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#14 /engine/Shopware/Components/HttpCache/AppCache.php(183): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#15 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(192): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /engine/Shopware/Components/HttpCache/AppCache.php(110): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#17 /var/www/clients/client1/web2/web/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#18
Was mache ich hier falsch, die Dokumentation hilft mir auch nicht weiter. Hab ich hier etwas nicht gemacht, oder ist das ein BUG?
PS: Vers 5.6.1 & Danke im Voraus