Hi all,
i am trying to migrate from magento 1.8.0.0 to shopware 5.5.3 , but iam facing below issue
please respond as soon as possible
An error occurred while importing products
Code : 0
Line : 224
File : /home/onefacto/www/zahnboerscht.li/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 /home/onefacto/www/zahnboerscht.li/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #1 /home/onefacto/www/zahnboerscht.li/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #2 /home/onefacto/www/zahnboerscht.li/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(’\n\t\t\tSELECT\n\n\t\t\t…’, Array) #3 /home/onefacto/www/zahnboerscht.li/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(’\n\t\t\tSELECT\n\n\t\t\t…’, Array) #4 /home/onefacto/www/zahnboerscht.li/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(583): Enlight_Components_Db_Adapter_Pdo_Mysql->query(’\n\t\t\tSELECT\n\n\t\t\t…’) #5 /home/onefacto/www/zahnboerscht.li/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Product.php(102): Shopware\SwagMigration\Components\Migration\Profile->queryProducts(0) #6 /home/onefacto/www/zahnboerscht.li/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(444): Shopware\SwagMigration\Components\Migration\Import\Resource\Product->run() #7 /home/onefacto/www/zahnboerscht.li/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(479): Shopware_Controllers_Backend_SwagMigration->runImport(‘import_products’) #8 /home/onefacto/www/zahnboerscht.li/engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_SwagMigration->importAction() #9 /home/onefacto/www/zahnboerscht.li/engine/Library/Enlight/Controller/Dispatcher/Default.php(548): Enlight_Controller_Action->dispatch(‘importAction’) #10 /home/onefacto/www/zahnboerscht.li/engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #11 /home/onefacto/www/zahnboerscht.li/engine/Shopware/Kernel.php(202): Enlight_Controller_Front->dispatch() #12 /home/onefacto/www/zahnboerscht.li/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #13 /home/onefacto/www/zahnboerscht.li/vendor/symfony/http-kernel/HttpCache/HttpCache.php(448): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #14 /home/onefacto/www/zahnboerscht.li/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #15 /home/onefacto/www/zahnboerscht.li/vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #16 /home/onefacto/www/zahnboerscht.li/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #17 /home/onefacto/www/zahnboerscht.li/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #18 {main}