Hallo liebe Community,
wir haben aktuell ein Problem mit dem MigrationTool von Shopware.
Und zwar möchten wir unsere Artikel (8434 Einträge) von Magento v1.9.3.6 auf Shopware v5.4.6 importieren (migrieren).
Leider bekommen wir folgende Fehlermeldung:
Beim Importieren der Produkte ist ein Fehler aufgetreten
Code : 42000
Line : 224
File : /var/www/vhosts/httpdocs/engine/Library/Zend/Db/Statement/Pdo.phpError : SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‚backup.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/vhosts/httpdocs/engine/Library/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array) #1 /var/www/vhosts/httpdocs/engine/Library/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array) #2 /var/www/vhosts/httpdocs/engine/Library/Zend/Db/Adapter/Pdo/Abstract.php(232): Zend_Db_Adapter_Abstract->query(‚\n SE…‘, Array) #3 /var/www/vhosts/httpdocs/engine/Library/Enlight/Components/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->query(‚\n SE…‘, Array) #4 /var/www/vhosts/httpdocs/engine/Library/Zend/Db/Adapter/Abstract.php(744): Enlight_Components_Db_Adapter_Pdo_Mysql->query(‚\n SE…‘, Array) #5 /var/www/vhosts/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Profile.php(435): Zend_Db_Adapter_Abstract->fetchRow(‚\n SE…‘) #6 /var/www/vhosts/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Product.php(194): Shopware\SwagMigration\Components\Migration\Profile->getAdditionalProductInfo(‚1‘) #7 /var/www/vhosts/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Components/Migration/Import/Resource/Product.php(116): Shopware\SwagMigration\Components\Migration\Import\Resource\Product->migrateProduct(Array, ‚make_valid‘, Object(Enlight_Components_Db_Adapter_Pdo_Mysql), Object(Shopware\SwagMigration\Components\DbServices\Import\Import), ‚Die Produkt-Num…‘, Array) #8 /var/www/vhosts/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(444): Shopware\SwagMigration\Components\Migration\Import\Resource\Product->run() #9 /var/www/vhosts/httpdocs/engine/Shopware/Plugins/Community/Backend/SwagMigration/Controllers/Backend/SwagMigration.php(479): Shopware_Controllers_Backend_SwagMigration->runImport(‚import_products‘) #10 /var/www/vhosts/httpdocs/engine/Library/Enlight/Controller/Action.php(193): Shopware_Controllers_Backend_SwagMigration->importAction() #11 /var/www/vhosts/httpdocs/engine/Library/Enlight/Controller/Dispatcher/Default.php(549): Enlight_Controller_Action->dispatch(‚importAction‘) #12 /var/www/vhosts/httpdocs/engine/Library/Enlight/Controller/Front.php(222): Enlight_Controller_Dispatcher_Default->dispatch(Object(Enlight_Controller_Request_RequestHttp), Object(Enlight_Controller_Response_ResponseHttp)) #13 /var/www/vhosts/httpdocs/engine/Shopware/Kernel.php(215): Enlight_Controller_Front->dispatch() #14 /var/www/vhosts/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(486): Shopware\Kernel->handle(Object(Symfony\Component\HttpFoundation\Request), 1, true) #15 /var/www/vhosts/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache->forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL) #16 /var/www/vhosts/httpdocs/vendor/symfony/http-kernel/HttpCache/HttpCache.php(253): Shopware\Components\HttpCache\AppCache->forward(Object(Symfony\Component\HttpFoundation\Request), true) #17 /var/www/vhosts/httpdocs/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache->pass(Object(Symfony\Component\HttpFoundation\Request), true) #18 /var/www/vhosts/httpdocs/shopware.php(122): Shopware\Components\HttpCache\AppCache->handle(Object(Symfony\Component\HttpFoundation\Request)) #19 {main}
Hat jemand einen Vorschlag oder eine Idee an was das liegen könnte?
Vielen Dank im voraus
Mit freundlichen Grüßen
HerfagGmbH
