Aktuell habe ich ein massives Problem, bisher ausschließlich beim Bestellabschluss.
Wohl gemerkt: Nur beim Bestellabschluss. Ich bin maximal verwirrt.
alte IP 85.13.157.xx, neue IP 85.13.137.xx
Unser MySQL-Server hat eine neue IP und Shopware versucht renitent die alte anzusprechen. config.php ist aktuallisiert, cache ist via FTP gelöscht. Hier das Log-File:
PDOException: SQLSTATE(HY000): General error: 1449 The user specified as a definer (’%KOREKTER_USER%’@‚85.13.157.xx‘) does not exist in /engine/Library/Zend/Db/Statement/Pdo.php:219 Stack trace:
#0 /engine/Library/Zend/Db/Statement/Pdo.php(219): PDOStatement->execute(Array)
#1 /engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)
#2 /engine/Library/Zend/Db/Adapter/Abstract.php(472): Zend_Db_Statement->execute(Array)
#3 /engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(‚DELETE FROM s_o…‘, Array)
#4 /engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(83): Zend_Db_Adapter_Pdo_Abstract->query(‚DELETE FROM s_o…‘, Array)
#5 /engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(98): Enlight_Components_Db_Adapter_Pdo_Mysql->query(‚DELETE FROM s_o…‘, Array)
#6 /engine/Shopware/Core/sOrder.php(847): Enlight_Components_Db_Adapter_Pdo_Mysql->executeUpdate(‚DELETE FROM s_o…‘, Array)
#7 /www/htdocs/w01a6530/shop.wsc-stuttgart.de/var/cache/production_202011060821/proxies/sOrderProxy.php(79): sOrder->sSaveOrder()
#8 /engine/Library/Enlight/Hook/HookExecutionContext.php(137): Shopware_Proxies_sOrderProxy->__executeOriginalMethod(‚sSaveOrder‘, Array)
#9 /engine/Library/Enlight/Hook/HookExecutionContext.php(103): Enlight_Hook_HookExecutionContext->executeReplaceChain(Array)
#10 /engine/Library/Enlight/Hook/HookManager.php(180): Enlight_Hook_HookExecutionContext->execute()
#11 /www/htdocs/w01a6530/shop.wsc-stuttgart.de/var/cache/production_202011060821/proxies/sOrderProxy.php(90): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_sOrderProxy), ‚sSaveOrder‘, Array)
#12 /engine/Shopware/Controllers/Frontend/Checkout.php(968): Shopware_Proxies_sOrderProxy->sSaveOrder()
#13 /engine/Shopware/Controllers/Frontend/Checkout.php(450): Shopware_Controllers_Frontend_Checkout->saveOrder()
#14 /www/htdocs/w01a6530/shop.wsc-stuttgart.de/var/cache/production_202011060821/proxies/ShopwareControllersFrontendCheckoutProxy.php(79): Shopware_Controllers_Frontend_Checkout->finishAction()
#15 /engine/Library/Enlight/Hook/HookExecutionContext.php(137): Shopware_Proxies_ShopwareControllersFrontendCheckoutProxy->__executeOriginalMethod(‚finishAction‘, Array)
#16 /engine/Library/Enlight/Hook/HookExecutionContext.php(103): Enlight_Hook_HookExecutionContext->executeReplaceChain(Array)
#17 /engine/Library/Enlight/Hook/HookManager.php(180): Enlight_Hook_HookExecutionContext->execute()
#18 /www/htdocs/w01a6530/shop.wsc-stuttgart.de/var/cache/production_202011060821/proxies/ShopwareControllersFrontendCheckoutProxy.php(102): Enlight_Hook_HookManager->executeHooks(Object(Shopware_Proxies_ShopwareControllersFrontendCheckoutProxy), ‚finishAction‘, Array)
#19 /engine/Library/Enlight/Controller/Action.php(192): Shopware_Proxies_ShopwareControllersFrontendCheckoutProxy->finishAction()
#20 /engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch(‚finishAction‘)
#21 /engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#22 /engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch()
#23 /vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#24 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true)
#25 /engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#26 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#27 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(255): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true)
#28 /engine/Shopware/Components/HttpCache/AppCache.php(143): Symfony\Component\HttpKernel\HttpCache\HttpCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true)
#29 /vendor/symfony/http-kernel/HttpCache/HttpCache.php(181): Shopware\Components\HttpCache\AppCache->invalidate(Object(Symfony\Component\HttpFoundation\Request), true)
#30 /engine/Shopware/Components/HttpCache/AppCache.php(113): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#31 /www/htdocs/w01a6530/shop.wsc-stuttgart.de/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#32