Fehler nach Serverumzug

Shopware 5 Installation/Einstieg
1

Hallo zusammen,

ich habe gerade einen Serverumzug durchgeführt. Alle nötigen Schritte wurden durchgeführt. Ich komme soweit auch ins Backend. Bei der Startseite bekomme ich jedoch folgende Meldung:

1274×139 7.67 KB

 

Woran kann dass liegen? Ich hoffe auf Hilfe

Schon mal vielen Dank im Vorraus

Frank

2

Hallo,

ohne die „richtige“ Fehlermeldung dahinter wird dir aber keiner helfen können. Am besten ergänzt du deiner config.php - Datei einmal die Shopware - Debug - Parameter, siehe: Debugging Shopware .

Beste Grüße

Sebastian

3

lösche mal händisch alles unter Cache auf dem Server.

 

4 
Message:	exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wgkfanvp1.s_product_streams_attributes' doesn't exist' in /home/wgkfanvp/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:833
Stack trace:
#0 /home/wgkfanvp/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(833): PDO->query('SHOW COLUMNS FR...')
#1 /home/wgkfanvp/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(766): Doctrine\DBAL\Connection->executeQuery('SHOW COLUMNS FR...', Array, Array)
#2 /home/wgkfanvp/htdocs/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/FieldHelper.php(88): Doctrine\DBAL\Connection->fetchAll('SHOW COLUMNS FR...')
#3 /home/wgkfanvp/htdocs/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/FieldHelper.php(776): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\FieldHelper->getTableFields('s_product_strea...', 'productStreamAt...')
#4 /home/wgkfanvp/htdocs/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/CategoryGateway.php(130): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\FieldHelper->getRelatedProductStreamFields()
#5 /home/wgkfanvp/htdocs/engine/Shopware/Bundle/StoreFrontBundle/Service/Core/CategoryService.php(66): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\CategoryGateway->getList(Array, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#6 /home/wgkfanvp/htdocs/engine/Shopware/Core/sCategories.php(147): Shopware\Bundle\StoreFrontBundle\Service\Core\CategoryService->getList(Array, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#7 /home/wgkfanvp/htdocs/engine/Shopware/Plugins/Default/Core/ControllerBase/Bootstrap.php(131): sCategories->sGetCategories(3)
#8 /home/wgkfanvp/htdocs/engine/Shopware/Plugins/Default/Core/ControllerBase/Bootstrap.php(82): Shopware_Plugins_Core_ControllerBase_Bootstrap->getCategories(3)
#9 /home/wgkfanvp/htdocs/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Core_ControllerBase_Bootstrap->onPostDispatch(Object(Enlight_Controller_ActionEventArgs))
#10 /home/wgkfanvp/htdocs/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#11 /home/wgkfanvp/htdocs/engine/Library/Enlight/Controller/Action.php(202): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs))
#12 /home/wgkfanvp/htdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('indexAction')
#13 /home/wgkfanvp/htdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#14 /home/wgkfanvp/htdocs/engine/Shopware/Kernel.php(182): Enlight_Controller_Front->dispatch()
#15 /home/wgkfanvp/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#16 /home/wgkfanvp/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#17 /home/wgkfanvp/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#18 /home/wgkfanvp/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#19 /home/wgkfanvp/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(187): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#20 /home/wgkfanvp/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#21 /home/wgkfanvp/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#22 /home/wgkfanvp/htdocs/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#23 {main}

Next exception 'Doctrine\DBAL\DBALException' with message 'An exception occurred while executing 'SHOW COLUMNS FROM s_product_streams_attributes':

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'wgkfanvp1.s_product_streams_attributes' doesn't exist' in /home/wgkfanvp/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:119
Stack trace:
#0 /home/wgkfanvp/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(836): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver), Object(PDOException), 'SHOW COLUMNS FR...', Array)
#1 /home/wgkfanvp/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(766): Doctrine\DBAL\Connection->executeQuery('SHOW COLUMNS FR...', Array, Array)
#2 /home/wgkfanvp/htdocs/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/FieldHelper.php(88): Doctrine\DBAL\Connection->fetchAll('SHOW COLUMNS FR...')
#3 /home/wgkfanvp/htdocs/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/FieldHelper.php(776): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\FieldHelper->getTableFields('s_product_strea...', 'productStreamAt...')
#4 /home/wgkfanvp/htdocs/engine/Shopware/Bundle/StoreFrontBundle/Gateway/DBAL/CategoryGateway.php(130): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\FieldHelper->getRelatedProductStreamFields()
#5 /home/wgkfanvp/htdocs/engine/Shopware/Bundle/StoreFrontBundle/Service/Core/CategoryService.php(66): Shopware\Bundle\StoreFrontBundle\Gateway\DBAL\CategoryGateway->getList(Array, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#6 /home/wgkfanvp/htdocs/engine/Shopware/Core/sCategories.php(147): Shopware\Bundle\StoreFrontBundle\Service\Core\CategoryService->getList(Array, Object(Shopware\Bundle\StoreFrontBundle\Struct\ShopContext))
#7 /home/wgkfanvp/htdocs/engine/Shopware/Plugins/Default/Core/ControllerBase/Bootstrap.php(131): sCategories->sGetCategories(3)
#8 /home/wgkfanvp/htdocs/engine/Shopware/Plugins/Default/Core/ControllerBase/Bootstrap.php(82): Shopware_Plugins_Core_ControllerBase_Bootstrap->getCategories(3)
#9 /home/wgkfanvp/htdocs/engine/Library/Enlight/Event/Handler/Plugin.php(149): Shopware_Plugins_Core_ControllerBase_Bootstrap->onPostDispatch(Object(Enlight_Controller_ActionEventArgs))
#10 /home/wgkfanvp/htdocs/engine/Library/Enlight/Event/EventManager.php(214): Enlight_Event_Handler_Plugin->execute(Object(Enlight_Controller_ActionEventArgs))
#11 /home/wgkfanvp/htdocs/engine/Library/Enlight/Controller/Action.php(202): Enlight_Event_EventManager->notify('Enlight_Control...', Object(Enlight_Controller_ActionEventArgs))
#12 /home/wgkfanvp/htdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(523): Enlight_Controller_Action->dispatch('indexAction')
#13 /home/wgkfanvp/htdocs/engine/Library/Enlight/Controller/Front.php(223): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp))
#14 /home/wgkfanvp/htdocs/engine/Shopware/Kernel.php(182): Enlight_Controller_Front->dispatch()
#15 /home/wgkfanvp/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(491): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#16 /home/wgkfanvp/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(266): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)
#17 /home/wgkfanvp/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true)
#18 /home/wgkfanvp/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(344): Symfony\Component\HttpKernel\HttpCache\HttpCache->fetch(Object(Symfony\Component\HttpFoundation\Request), true)
#19 /home/wgkfanvp/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(187): Symfony\Component\HttpKernel\HttpCache\HttpCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#20 /home/wgkfanvp/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(210): Shopware\Components\HttpCache\AppCache->lookup(Object(Symfony\Component\HttpFoundation\Request), true)
#21 /home/wgkfanvp/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(114): Symfony\Component\HttpKernel\HttpCache\HttpCache->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)
#22 /home/wgkfanvp/htdocs/shopware.php(117): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request))
#23 {main}
Time:	2017-06-08T09:40:28.273130+0200
Channel:	core
request:	{
    "uri": "/csrftoken",
    "method": "GET",
    "query": {
        "module": "frontend",
        "controller": "csrftoken",
        "action": "index"
    },
    "post": []
}
session:	No session data available
shopId:	1
shopName:	cmondo.hk

 

5

Ich vermute, daß Deine Datenbank nicht vollständig oder nicht korrekt kopiert wurde. Falls Du die Datenbank mit phpMyAdmin exportiert hast, mußt Du unbedingt darauf achten, daß Du einen Haken bei der Option „Disable foreign key checks“ bzw. „Fremdschlüsselüberprüfung deaktivieren“ machst.

Timme Hosting - schnelles nginx-Hosting

www.timmehosting.de