Fehler nach Serverumzug

dealsforme · 8. Juni 2017 um 06:43

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:

Woran kann dass liegen? Ich hoffe auf Hilfe

Schon mal vielen Dank im Vorraus

Frank

sschreier · 8. Juni 2017 um 07:01

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

NurIch · 8. Juni 2017 um 07:22

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

dealsforme · 8. Juni 2017 um 07:51

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

TimmeHosting · 11. Juni 2017 um 16:41

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

Thema		Antworten	Aufrufe
Fehler nach Update Versuch / Backend, Frontend, sql Sonstiges	9	872	11. August 2019
SQL-Fehler bei "Artikel bearbeiten" 503 Service unavailable Shopware 3.5 administration	11	1470	5. November 2014
Tabelle in Datenbank nicht mehr da seit dem Update? Installation/Einstieg	7	1218	25. September 2018
Nach Datenbank Import unter phpmyadmin, Fehler im Storefront Shopware 3.5 programming	0	697	29. Juni 2013
Grosses Problem, nach Backup einspielen funktioniert der Shop nicht Shopware 5	8	329	16. Juli 2022

Fehler nach Serverumzug

Verwandte Themen