# Import Plugin > Too many tables; MySQL can only use 61 table **URL:** \ **Category:** Shopware 3.5\ **Tags:** programming\ **Created:** [11. April 2011 um 11:19 UTC](https://forum.shopware.com/t/import-plugin-gt-too-many-tables-mysql-can-only-use-61-table/2444 "2011-04-11T11:19:20Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![sbgit\_de](https://avatars.discourse-cdn.com/v4/letter/s/b2d939/32.png) [@sbgit\_de](https://forum.shopware.com/u/sbgit_de)\ **Post date:** [11. April 2011 um 11:19 UTC](https://forum.shopware.com/t/import-plugin-gt-too-many-tables-mysql-can-only-use-61-table/2444/1 "2011-04-11T11:19:20Z")
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 ---
**Author:** ![kweb](https://avatars.discourse-cdn.com/v4/letter/k/e19adc/32.png) [@kweb](https://forum.shopware.com/u/kweb)\ **Post date:** [9. Februar 2014 um 22:35 UTC](https://forum.shopware.com/t/import-plugin-gt-too-many-tables-mysql-can-only-use-61-table/2444/2 "2014-02-09T22:35:30Z")
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 ---
**Author:** ![DanielNogel](https://avatars.discourse-cdn.com/v4/letter/d/96bed5/32.png) [@DanielNogel](https://forum.shopware.com/u/DanielNogel)\ **Post date:** [10. Februar 2014 um 05:51 UTC](https://forum.shopware.com/t/import-plugin-gt-too-many-tables-mysql-can-only-use-61-table/2444/3 "2014-02-10T05:51:23Z")
Hi, siehe hier: [viewtopic.php?t=18562](http://forum.shopware.de/viewtopic.php?t=18562) Migration Magento - Shopware Error : too many tables vG Daniel Gesendet von meinem HTC One mit Tapatalk