Hi, ich versuche gerade bei einer Testinstallation den Import aus Magento. Dafür habe ich mir aus dem Shop das Plugin heruntergeladen. Wenn ich den Import nun Starte bekomme ich jedoch die Meldung : /Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #2 /srv/www/shop/htdocs/shop/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #3 /srv/www/shop/htdocs/shop/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('????SELECT ????...', Array) #4 /srv/www/shop/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(199): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('????SELECT ????...') #5 /srv/www/shop/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(513): Shopware\_Components\_Migration\_Profile-\>queryProducts(0) #6 /srv/www/shop/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(940): Shopware\_Controllers\_Backend\_Migration-\>importProducts() #7 /srv/www/shop/htdocs/shop/engine/Enlight/Enlight/Controller/Action.php(55): Shopware\_Controllers\_Backend\_Migration-\>importAction() #8 /srv/www/shop/htdocs/shop/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch('importAction') #9 /srv/www/shop/htdocs/shop/engine/Enlight/Enlight/Controller/Front.php(88): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #10 /srv/www/shop/htdocs/shop/engine/Shopware/Bootstrap.php(21): Enlight\_Controller\_Front-\>dispatch() #11 /srv/www/shop/htdocs/shop/engine/Enlight/Enlight/Application.php(69): Shopware\_Bootstrap-\>run() #12 /srv/www/shop/htdocs/shop/shopware.php(6): Enlight\_Application-\>run() #13 {main} Next exception 'Zend\_Db\_Statement\_Exception' with message 'SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join' in /srv/www/shop/htdocs/shop/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement/Pdo.php:234 Stack trace: #0 /srv/www/shop/htdocs/shop/engine/Enlight/Vendor/Zend/library/Zend/Db/Statement.php(300): Zend\_Db\_Statement\_Pdo-\>\_execute(Array) #1 /srv/www/shop/htdocs/shop/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Abstract.php(479): Zend\_Db\_Statement-\>execute(Array) #2 /srv/www/shop/htdocs/shop/engine/Enlight/Vendor/Zend/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend\_Db\_Adapter\_Abstract-\>query('????SELECT ????...', Array) #3 /srv/www/shop/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(199): Zend\_Db\_Adapter\_Pdo\_Abstract-\>query('????SELECT ????...') #4 /srv/www/shop/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(513): Shopware\_Components\_Migration\_Profile-\>queryProducts(0) #5 /srv/www/shop/htdocs/shop/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Migration.php(940): Shopware\_Controllers\_Backend\_Migration-\>importProducts() #6 /srv/www/shop/htdocs/shop/engine/Enlight/Enlight/Controller/Action.php(55): Shopware\_Controllers\_Backend\_Migration-\>importAction() #7 /srv/www/shop/htdocs/shop/engine/Enlight/Enlight/Controller/Dispatcher/DispatcherDefault.php(329): Enlight\_Controller\_Action-\>dispatch('importAction') #8 /srv/www/shop/htdocs/shop/engine/Enlight/Enlight/Controller/Front.php(88): Enlight\_Controller\_Dispatcher\_DispatcherDefault-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp)) #9 /srv/www/shop/htdocs/shop/engine/Shopware/Bootstrap.php(21): Enlight\_Controller\_Front-\>dispatch() #10 /srv/www/shop/htdocs/shop/engine/Enlight/Enlight/Application.php(69): Shopware\_Bootstrap-\>run() #11 /srv/www/shop/htdocs/shop/shopware.php(6): Enlight\_Application-\>run() #12 {main} Was kann ich machen? Gruss Peter
Hallo, ich habe das gleiche Problem. Ich möchte einen Magento Shop in Shopware importieren. Wenn ich Produkte importieren will kommt bei mir: [quote]Beim Importieren der Produkte ist ein Fehler aufgetreten Code : 0 Line : 234 File : /www/htdocs/ xxx/theis/shopware414/engine/Library/Zend/Db/Statement/Pdo.php Error : SQLSTATE[HY000]: General error: 1116 Too many tables; MySQL can only use 61 tables in a join Trace : #0 /www/htdocs/ xxx/theis/shopware414/engine/Library/Zend/Db/Statement.php(300): Zend_Db_Statement_Pdo->_execute(Array) #1 /www/htdocs/ xxx/theis/shopware414/engine/Library/Zend/Db/Adapter/Abstract.php(479): Zend_Db_Statement->execute(Array) #2 /www/htdocs/ xxx/theis/shopware414/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query(’???SELECT ???..’, Array) #3 /www/htdocs/ xxx/theis/shopware414/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(75): Zend_Db_Adapter_Pdo_Abstract->query(’???SELECT ???..’, Array) #4 /www/htdocs/ xxx/theis/shopware414/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(503): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’???SELECT ???..’) #5 /www/htdocs/ xxx/theis/shopware414/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Product.php(99): Shopware_Components_Migration_Profile->queryProducts(0) #6 /www/htdocs/ xxx/theis/shopware414/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(436): Shopware_Components_Migration_Import_Resource_Product->run() #7 /www/htdocs/ xxx/theis/shopware414/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(471): Shopware_Controllers_Backend_SwagMigration->runImport(‘import_products’) #8 /www/htdocs/ xxx/theis/shopware414/engine/Library/Enlight/Controller/Action.php(148): Shopware_Controllers_Backend_SwagMigration->importAction() #9 /www/htdocs/ xxx/theis/shopware414/engine/Library/Enlight/Controller/Dispatcher/Default.php(521): Enlight_Controller_Action->dispatch(‘importAction’) #10 /www/htdocs/ xxx/theis/shopware414/engine/Library/Enlight/Controller/Front.php(214): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #11 /www/htdocs/ xxx/theis/shopware414/engine/Shopware/Components/HttpCache/HttpKernel.php(79): Enlight_Controller_Front->dispatch() #12 /www/htdocs/ xxx/theis/shopware414/engine/Library/Symfony/Component/HttpKernel/HttpCache/HttpCache.php(434): Shopware\Components\HttpCache\HttpKernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /www/htdocs/ xxx/theis/shopware414/engine/Shopware/Components/HttpCache/AppCache.php(242): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #14 [/quote][/quote] Ich bräucht dringend eine Lösung. LG
Hi, siehe hier: viewtopic.php?t=18562 Migration Magento - Shopware Error : too many tables vG Daniel Gesendet von meinem HTC One mit Tapatalk