Fehlermeldung: Migration von Magento Version 1.9.3.6 auf Shopware v5.4.6

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.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 ‚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

Hi, 
also der Fehler sebst steht ja oben.
 

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

Scheint auf dem ersten Blick ein Server config problem zu sein.

Probiere mal folgende Lösung:

 

Vielen Dank :slight_smile: