Restore Problem: PDOException

Hi Leute,

ich arbeite gerade unter Hochdruck an einem Restore eines Shops nach Festplattencrash.
Alle Dateien sind aus einem Backup wiederhergestellt, und die Datenbank auch.

PHP ist 5.6 incl. passendem ioncube loader.

Das Backend erlaubt einen Login, zeigt aber kein Menü.
Bei Aufruf der Seite gibts die folgende Meldung (musste in mehrere Posts unterteilen).
Eine bessere Ansicht gibts unter: http://46.4.103.151/
Ich bin für jede Hilfe dankbar!

( ! ) Fatal error: Uncaught exception ‚PDOException‘ with message ‚SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚category.noviewselect‘ in ‚field list‘‘ in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119( ! ) PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚category.noviewselect‘ in ‚field list‘ in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php on line _828_Call Stack#TimeMemoryFunctionLocation10.0001231344{main}( )…/shopware.php : 020.00331238304Shopware\Components\HttpCache\AppCache->handle( )…/shopware.php : 10130.00351245728Symfony\Component\HttpKernel\HttpCache\HttpCache->handle( )…/AppCache.php : 11440.00371252128Shopware\Components\HttpCache\AppCache->lookup( )…/HttpCache.php : 21350.00371252352Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup( )…/AppCache.php : 17860.00381253792Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch( )…/HttpCache.php : 34970.00391261016Shopware\Components\HttpCache\AppCache->forward( )…/HttpCache.php : 44980.01042266008Symfony\Component\HttpKernel\HttpCache\HttpCache->forward( )…/AppCache.php : 25590.01052267720Shopware\Kernel->handle( )…/HttpCache.php : 492100.04065337392Enlight_Controller_Front->dispatch( )…/Kernel.php : 153110.04415604472Enlight_Event_EventManager->notify( )…/Front.php : 161120.04425606048Enlight_Event_Handler_Plugin->execute( )…/EventManager.php : 213130.04465646664Shopware_Plugins_Core_Router_Bootstrap->onRouteStartup( )…/Plugin.php : 149140.06457671088Shopware\Models\Shop\Shop->registerResources( )…/Bootstrap.php : 129150.07408104344Shopware\Bundle\StoreFrontBundle\Service\Core\ContextService->initializeShopContext( )…/Shop.php : 710160.07648430304Shopware\Bundle\StoreFrontBundle\Service\Core\ContextService->createShopContext( )…/ContextService.php : 202170.07648430344Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ShopGateway->get( )…/ContextService.php : 401180.07648430760Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ShopGateway->getList( )…/ShopGateway.php : 71190.07648431320Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ShopGateway->getShops( )…/ShopGateway.php : 77200.08308640032Doctrine\DBAL\Query\QueryBuilder->execute( )…/ShopGateway.php : 139210.08318646216Doctrine\DBAL\Connection->executeQuery( )…/QueryBuilder.php : 206220.08328664872execute ( )…/Connection.php : 828

( ! ) Doctrine\DBAL\DBALException: An exception occurred while executing ‚SELECT shop.id as __shop_id, shop.main_id as __shop_main_id, shop.name as __shop_name, shop.title as __shop_title, shop.position as __shop_position, shop.host as __shop_host, shop.base_path as __shop_base_path, shop.base_url as __shop_base_url, shop.hosts as __shop_hosts, shop.secure as __shop_secure, shop.secure_host as __shop_secure_host, shop.secure_base_path as __shop_secure_base_path, shop.template_id as __shop_template_id, shop.document_template_id as __shop_document_template_id, shop.category_id as __shop_category_id, shop.locale_id as __shop_locale_id, shop.currency_id as __shop_currency_id, shop.customer_group_id as __shop_customer_group_id, shop.fallback_id as __shop_fallback_id, shop.customer_scope as __shop_customer_scope, shop.default as __shop_default, shop.active as __shop_active, shop.always_secure as __shop_always_secure, currency.id as __currency_id, currency.currency as __currency_currency, currency.name as __currency_name, currency.standard as __currency_standard, currency.factor as __currency_factor, currency.templatechar as __currency_templatechar, currency.symbol_position as __currency_symbol_position, currency.position as __currency_position, template.id as __template_id, template.template as __template_template, template.name as __template_name, template.description as __template_description, template.author as __template_author, template.license as __template_license, template.esi as __template_esi, template.style_support as __template_style_support, template.emotion as __template_emotion, template.version as __template_version, template.plugin_id as __template_plugin_id, template.parent_id as __template_parent_id, locale.id as __locale_id, locale.locale as __locale_locale, locale.language as __locale_language, locale.territory as __locale_territory, customerGroup.id as __customerGroup_id, customerGroup.groupkey as __customerGroup_groupkey, customerGroup.description as __customerGroup_description, customerGroup.tax as __customerGroup_tax, customerGroup.taxinput as __customerGroup_taxinput, customerGroup.mode as __customerGroup_mode, customerGroup.discount as __customerGroup_discount, customerGroup.minimumorder as __customerGroup_minimumorder, customerGroup.minimumordersurcharge as __customerGroup_minimumordersurcharge, customerGroupAttribute.id as __customerGroupAttribute_id, customerGroupAttribute.customerGroupID as __customerGroupAttribute_customerGroupID, category.id as __category_id, category.parent as __category_parent_id, category.position as __category_position, category.path as __category_path, category.description as __category_description, category.metakeywords as __category_metakeywords, category.metadescription as __category_metadescription, category.cmsheadline as __category_cmsheadline, category.product_box_layout as __category_product_box_layout, category.cmstext as __category_cmstext, category.template as __category_template, category.noviewselect as __category_noviewselect, category.blog as __category_blog, category.showfiltergroups as __category_showfiltergroups, category.external as __category_external, category.hidefilter as __category_hidefilter, category.hidetop as __category_hidetop, categoryAttribute.id as __categoryAttribute_id, categoryAttribute.categoryID as __categoryAttribute_categoryID, categoryAttribute.attribute1 as __categoryAttribute_attribute1, categoryAttribute.attribute2 as __categoryAttribute_attribute2, categoryAttribute.attribute3 as __categoryAttribute_attribute3, categoryAttribute.attribute4 as __categoryAttribute_attribute4, categoryAttribute.attribute5 as __categoryAttribute_attribute5, categoryAttribute.attribute6 as __categoryAttribute_attribute6, categoryAttribute.filter_storelocator as __categoryAttribute_filter_storelocator, media.id as __media_id, media.albumID as __media_albumID, media.name as __media_name, media.description as __media_description, media.path as __media_path, media.type as __media_type, media.extension as __media_extension, media.file_size as __media_file_size, media.width as __media_width, media.height as __media_height, media.userID as __media_userID, media.created as __media_created, mediaSettings.id as __mediaSettings_id, mediaSettings.create_thumbnails as __mediaSettings_create_thumbnails, mediaSettings.thumbnail_size as __mediaSettings_thumbnail_size, mediaSettings.icon as __mediaSettings_icon, mediaSettings.thumbnail_high_dpi as __mediaSettings_thumbnail_high_dpi, mediaAttribute.id as __mediaAttribute_id, mediaAttribute.mediaID as __mediaAttribute_mediaID FROM s_core_shops shop LEFT JOIN s_core_currencies currency ON currency.id = shop.currency_id LEFT JOIN s_core_templates template ON shop.template_id = template.id LEFT JOIN s_core_locales locale ON locale.id = shop.locale_id LEFT JOIN s_core_customergroups customerGroup ON customerGroup.id = shop.customer_group_id LEFT JOIN s_categories category ON category.id = shop.category_id LEFT JOIN s_core_customergroups_attributes customerGroupAttribute ON customerGroupAttribute.customerGroupID = customerGroup.id LEFT JOIN s_categories_attributes categoryAttribute ON categoryAttribute.categoryID = category.id LEFT JOIN s_categories_avoid_customergroups customerGroups ON customerGroups.categoryID = category.id LEFT JOIN s_media media ON media.id = category.mediaID LEFT JOIN s_media_album_settings mediaSettings ON mediaSettings.albumID = media.albumID LEFT JOIN s_media_attributes mediaAttribute ON mediaAttribute.mediaID = media.id WHERE shop.id IN (?)‘ with params [1]: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‚category.noviewselect‘ in ‚field list‘ in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line _119_Call Stack#TimeMemoryFunctionLocation10.0001231344{main}( )…/shopware.php : 020.00331238304Shopware\Components\HttpCache\AppCache->handle( )…/shopware.php : 10130.00351245728Symfony\Component\HttpKernel\HttpCache\HttpCache->handle( )…/AppCache.php : 11440.00371252128Shopware\Components\HttpCache\AppCache->lookup( )…/HttpCache.php : 21350.00371252352Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup( )…/AppCache.php : 17860.00381253792Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch( )…/HttpCache.php : 34970.00391261016Shopware\Components\HttpCache\AppCache->forward( )…/HttpCache.php : 44980.01042266008Symfony\Component\HttpKernel\HttpCache\HttpCache->forward( )…/AppCache.php : 25590.01052267720Shopware\Kernel->handle( )…/HttpCache.php : 492100.04065337392Enlight_Controller_Front->dispatch( )…/Kernel.php : 153110.04415604472Enlight_Event_EventManager->notify( )…/Front.php : 161120.04425606048Enlight_Event_Handler_Plugin->execute( )…/EventManager.php : 213130.04465646664Shopware_Plugins_Core_Router_Bootstrap->onRouteStartup( )…/Plugin.php : 149140.06457671088Shopware\Models\Shop\Shop->registerResources( )…/Bootstrap.php : 129150.07408104344Shopware\Bundle\StoreFrontBundle\Service\Core\ContextService->initializeShopContext( )…/Shop.php : 710160.07648430304Shopware\Bundle\StoreFrontBundle\Service\Core\ContextService->createShopContext( )…/ContextService.php : 202170.07648430344Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ShopGateway->get( )…/ContextService.php : 401180.07648430760Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ShopGateway->getList( )…/ShopGateway.php : 71190.07648431320Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ShopGateway->getShops( )…/ShopGateway.php : 77200.08308640032Doctrine\DBAL\Query\QueryBuilder->execute( )…/ShopGateway.php : 139210.08318646216Doctrine\DBAL\Connection->executeQuery( )…/QueryBuilder.php : 206

Im Apache Error log steht:

 

[Sun Sep 24 15:33:05.743320 2017] [:error] [pid 31361] [client 62.216.206.101:56319] PHP Fatal error:  Uncaught exception ‘PDOException’ with message ‘SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘category.noviewselect’ in ‘field list’’ in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:828\nStack trace:\n#0 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(828): PDOStatement->execute()\n#1 /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php(206): Doctrine\DBAL\Connection->executeQuery(‘SELECT shop.id …’, Array, Array)\n#2 /var/www/html/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ShopGateway.php(139): Doctrine\DBAL\Query\QueryBuilder->execute()\n#3 /var/www/html/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ShopGateway.php(77): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ShopGateway->getShops(Array)\n#4 /var/www/html/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/ShopGateway.php(71): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\ShopGateway->getList(Array)\n#5 /var/www/html/engine/Shopware/Bundle/StoreFrontBundle/Service in /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php on line 119

 

Column not found: 1054 Unknown column ‚category.noviewselect‘

ist es wirklich das korrekte DB-Backup, welches eingespielt worden ist? War der DB-Dump intakt und vollständig, mit welchen Optionen erfolgte der Import der DB?

Also die Spalte " noviewselect" wurde mir 5.3 entfernt. Wenn die bei dir fehlt, ist das Backup wohl eine 5.3 - wenn die noch etwas sucht, dann die Dateien entweder nicht 5.3 oder ein Plugin was nicht kompatibel ist.