Hallo,
nach dem Update auf SW5.3 gemacht habe, musste ich alles wieder zurückrollen, da ich nicht alle PlugIns gelöscht hatte. Ich habe die DB neu aufsetzen lassen und ein Backup eingespielt und bin dann nach der Anleitung für das Update vorgegangen und habe alle Plug-Ins entweder upgedated oder gelöscht und dann das Update nocheinmal gemacht. Das gute ist, die Seite ist wieder da, das schlechte, sobald ich auf die Ware klicke - kommt "Ups es ist ein Fehler aufgetretten. Dazu erhalte ich folgende Fehlermeldungen:
exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.update_additional_description' in 'field list'' in /mykfqvqe/www.mykaffee.shop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:828
Stack trace:
#0 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(828): PDOStatement->execute()
#1 /mykfqvqe/www.mykaffee.shop/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(742): Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS...', Array, Array)
#2 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(196): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
#3 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Plugins/Community/Backend/SwagConnect/Components/Helper.php(310): Doctrine\ORM\EntityRepository->findOneBy(Array)
#4 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Plugins/Community/Backend/SwagConnect/Components/Helper.php(652): ShopwarePlugins\Connect\Components\Helper->getConnectAttributeByModel(Object(Shopware\Models\Article\Detail))
#5 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Plugins/Community/Backend/SwagConnect/Subscribers/TemplateExtension.php(163): ShopwarePlugins\Connect\Components\Helper->isRemoteArticleDetail(838)
#6 [internal function]: ShopwarePlugins\Connect\Subscribers\TemplateExtension->addConnectTemplateVariablesToDetail(Object(Enlight_Controller_ActionEventArgs))
#7 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Event/Handler/Default.php(91): call_user_func(Array, Object(Enlight_Controller_ActionEventArgs))
#8 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs))
#9 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Controller/Action.php(192): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs))
#10 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(525): Enlight_Controller_Action->dispatch('indexAction')
#11 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#12 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Kernel.php(184): Enlight_Controller_Front->dispatch()
#13 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#14 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#15 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#17 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#18 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#19 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Components/HttpCache/AppCache.php(116): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#20 /mykfqvqe/www.mykaffee.shop/shopware.php(118): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#21 {main}
Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'SELECT t0.id AS id_1, t0.article_id AS article_id_2, t0.article_detail_id AS article_detail_id_3, t0.shop_id AS shop_id_4, t0.source_id AS source_id_5, t0.export_status AS export_status_6, t0.export_message AS export_message_7, t0.exported AS exported_8, t0.category AS category_9, t0.purchase_price AS purchase_price_10, t0.fixed_price AS fixed_price_11, t0.update_price AS update_price_12, t0.update_image AS update_image_13, t0.update_long_description AS update_long_description_14, t0.update_short_description AS update_short_description_15, t0.update_additional_description AS update_additional_description_16, t0.update_name AS update_name_17, t0.last_update AS last_update_18, t0.last_update_flag AS last_update_flag_19, t0.group_id AS group_id_20, t0.is_main_variant AS is_main_variant_21, t0.purchase_price_hash AS purchase_price_hash_22, t0.offer_valid_until AS offer_valid_until_23, t0.stream AS stream_24, t0.cron_update AS cron_update_25, t0.revision AS revision_26, t0.article_id AS article_id_27, t0.article_detail_id AS article_detail_id_28 FROM s_plugin_connect_items t0 WHERE t0.article_detail_id = ? LIMIT 1' with params [838]:
SQLSTATE[42S22]: Column not found: 1054 Unknown column 't0.update_additional_description' in 'field list'' in /mykfqvqe/www.mykaffee.shop/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119
Stack trace:
#0 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SELECT t0.id AS...', Array)
#1 /mykfqvqe/www.mykaffee.shop/engine/Library/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(742): Doctrine\DBAL\Connection->executeQuery('SELECT t0.id AS...', Array, Array)
#2 /mykfqvqe/www.mykaffee.shop/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(196): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load(Array, NULL, NULL, Array, NULL, 1, NULL)
#3 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Plugins/Community/Backend/SwagConnect/Components/Helper.php(310): Doctrine\ORM\EntityRepository->findOneBy(Array)
#4 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Plugins/Community/Backend/SwagConnect/Components/Helper.php(652): ShopwarePlugins\Connect\Components\Helper->getConnectAttributeByModel(Object(Shopware\Models\Article\Detail))
#5 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Plugins/Community/Backend/SwagConnect/Subscribers/TemplateExtension.php(163): ShopwarePlugins\Connect\Components\Helper->isRemoteArticleDetail(838)
#6 [internal function]: ShopwarePlugins\Connect\Subscribers\TemplateExtension->addConnectTemplateVariablesToDetail(Object(Enlight_Controller_ActionEventArgs))
#7 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Event/Handler/Default.php(91): call_user_func(Array, Object(Enlight_Controller_ActionEventArgs))
#8 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Default->execute(Object(Enlight_Controller_ActionEventArgs))
#9 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Controller/Action.php(192): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs))
#10 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Controller/Dispatcher/Default.php(525): Enlight_Controller_Action->dispatch('indexAction')
#11 /mykfqvqe/www.mykaffee.shop/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#12 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Kernel.php(184): Enlight_Controller_Front->dispatch()
#13 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#14 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#15 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#16 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#17 /mykfqvqe/www.mykaffee.shop/engine/Shopware/Components/HttpCache/AppCache.php(189): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#18 /mykfqvqe/www.mykaffee.shop/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
Bitte dringend um Hilfe. Danke!
Gruß,
Thomas