Hallo Leute,
ich soll Magento (v1.9.1) Shops nach Shopware migirieren. Dafür hab ich das offizielle Shop-Migrations Plugin von Shopware installiert. Leider klappt der Import der Arikel und Bestellungen nicht.
Bei den Bestellungen kommt der folgende Fehler:
An error occurred while importing order details
Code : 23000
Line : 224
File : /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Statement/Pdo.php
Error : SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`db-4`.`s_order_details`, CONSTRAINT `s_order_details_ibfk_1` FOREIGN KEY (`orderID`) REFERENCES `s_order` (`id`) ON DELETE CASCADE)
Trace : #0 /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Adapter/Abstract.php(472): Zend_Db_Statement->execute(Array) #2 /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('INSERT INTO `s_...', Array) #3 /var/www/www.tld.com/htdocs/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(83): Zend_Db_Adapter_Pdo_Abstract->query('INSERT INTO `s_...', Array) #4 /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Adapter/Abstract.php(573): Enlight_Components_Db_Adapter_Pdo_Mysql->query('INSERT INTO `s_...', Array) #5 /var/www/www.tld.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Order.php(459): Zend_Db_Adapter_Abstract->insert('s_order_details', Array) #6 /var/www/www.tld.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Order.php(164): Shopware\SwagMigration\Components\Migration\Import\Resource\Order->migrateOrderDetail(Array, 'make_valid', 'The product num...') #7 /var/www/www.tld.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Order.php(77): Shopware\SwagMigration\Components\Migration\Import\Resource\Order->importOrderDetails() #8 /var/www/www.tld.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(444): Shopware\SwagMigration\Components\Migration\Import\Resource\Order->run() #9 /var/www/www.tirol-geniessen.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(479): Shopware_Controllers_Backend_SwagMigration->runImport('import_order_de...') #10 /var/www/www.tirol-geniessen.com/htdocs/engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_SwagMigration->importAction() #11 /var/www/www.tld.com/htdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enlight_Controller_Action->dispatch('importAction') #12 /var/www/www.tld.com/htdocs/engine/Library/Enlight/Controller/Front.php(228): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #13 /var/www/www.tld.com/htdocs/engine/Shopware/Kernel.php(188): Enlight_Controller_Front->dispatch() #14 /var/www/www.tld.com/htdocs/vendor/symfony/http-kernel/HttpCache/SubRequestHandler.php(102): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /var/www/www.tld.com/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(453): Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle(Object(Shopware\Kernel), Object(Symfony\Component\HttpFoundation\Request), 1, true) #16 /var/www/www.tld.com/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(261): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #17 /var/www/www.tld.com/htdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(238): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/www.tld.com/htdocs/engine/Shopware/Components/HttpCache/AppCache.php(102): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #19 /var/www/www.tld.com/htdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #20 {main}
Bei den Artikeln kommt dieser Fehler:
An error occurred while importing products
Code : 42000
Line : 224
File : /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Statement/Pdo.php
Error : SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'magento.r.parent_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Trace : #0 /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Adapter/Abstract.php(472): Zend_Db_Statement->execute(Array) #2 /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query('\n SE...', Array) #3 /var/www/www.tld.com/htdocs/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(83): Zend_Db_Adapter_Pdo_Abstract->query('\n SE...', Array) #4 /var/www/www.tld.com/htdocs/engine/Library/Zend/Db/Adapter/Abstract.php(727): Enlight_Components_Db_Adapter_Pdo_Mysql->query('\n SE...', Array) #5 /var/www/www.tld.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(435): Zend_Db_Adapter_Abstract->fetchRow('\n SE...') #6 /var/www/www.tld.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Product.php(194): Shopware\SwagMigration\Components\Migration\Profile->getAdditionalProductInfo('1') #7 /var/www/www.tld.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Product.php(116): Shopware\SwagMigration\Components\Migration\Import\Resource\Product->migrateProduct(Array, 'complain', Object(Enlight_Components_Db_Adapter_Pdo_Mysql), Object(Shopware\SwagMigration\Components\DbServices\Import\Import), 'The product num...', Array) #8 /var/www/www.tld.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(444): Shopware\SwagMigration\Components\Migration\Import\Resource\Product->run() #9 /var/www/wwwtld.com/htdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(479): Shopware_Controllers_Backend_SwagMigration->runImport('import_products') #10 /var/www/www.tld.com/htdocs/engine/Library/Enlight/Controller/Action.php(192): Shopware_Controllers_Backend_SwagMigration->importAction() #11 /var/www/www.tld.com/htdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(478): Enl
Hat da jemand von euch eine Lösung dafür?
sg Roman