HerfagGmbHHerfagGmbH MitgliedKommentare: 1 Danke erhalten: 0 Mitglied seit: 3. August bearbeitet 3. August

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

1 Antwort

  • DennisGDennisG MitgliedKommentare: 12 Danke erhalten: 4 Mitglied seit: September 2016

    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:

    https://stackoverflow.com/questions/23921117/disable-only-full-group-by

     

    Zitieren
    Akzeptierte Antwort
  • Akzeptierte Antwort

Antworten

  • DennisGDennisG MitgliedKommentare: 12 Danke erhalten: 4 Mitglied seit: September 2016

    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:

    https://stackoverflow.com/questions/23921117/disable-only-full-group-by

     

    Zitieren
    Akzeptierte Antwort
  • HerfagGmbHHerfagGmbH MitgliedKommentare: 1 Danke erhalten: 0 Mitglied seit: 3. August

    Vielen Dank :)

Anmelden oder Registrieren, um zu kommentieren.