# Restore Problem: PDOException
**URL:** https://forum.shopware.com/t/restore-problem-pdoexception/48453
**Category:** Allgemein
**Created:** [24. September 2017 um 13:30 UTC](https://forum.shopware.com/t/restore-problem-pdoexception/48453 "2017-09-24T13:30:39Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@itworks](https://forum.shopware.com/u/itworks)
#### Post date: [24. September 2017 um 13:30 UTC](https://forum.shopware.com/t/restore-problem-pdoexception/48453/1 "2017-09-24T13:30:39Z")
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/](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.08328664872[execute](http://www.php.net/PDOStatement.execute) ( )…/Connection.php **:** 828
---
### Author:  [@itworks](https://forum.shopware.com/u/itworks)
#### Post date: [24. September 2017 um 13:30 UTC](https://forum.shopware.com/t/restore-problem-pdoexception/48453/2 "2017-09-24T13:30:55Z")
( ! ) 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
---
### Author:  [@itworks](https://forum.shopware.com/u/itworks)
#### Post date: [24. September 2017 um 13:33 UTC](https://forum.shopware.com/t/restore-problem-pdoexception/48453/3 "2017-09-24T13:33:47Z")
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
---
### Author:  [@hth](https://forum.shopware.com/u/hth)
#### Post date: [24. September 2017 um 16:04 UTC](https://forum.shopware.com/t/restore-problem-pdoexception/48453/4 "2017-09-24T16:04:26Z")
> 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?
---
### Author:  [@Moritz\_Naczenski](https://forum.shopware.com/u/Moritz_Naczenski)
#### Post date: [24. September 2017 um 16:15 UTC](https://forum.shopware.com/t/restore-problem-pdoexception/48453/5 "2017-09-24T16:15:30Z")
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.