# Fehlermeldung: Migration von Magento Version 1.9.3.6 auf Shopware v5.4.6
**URL:** https://forum.shopware.com/t/fehlermeldung-migration-von-magento-version-1-9-3-6-auf-shopware-v5-4-6/54410
**Category:** Plugins
**Tags:** offizielle-shopware-
**Created:** [3. August 2018 um 12:01 UTC](https://forum.shopware.com/t/fehlermeldung-migration-von-magento-version-1-9-3-6-auf-shopware-v5-4-6/54410 "2018-08-03T12:01:25Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@HerfagGmbH](https://forum.shopware.com/u/HerfagGmbH)
#### Post date: [3. August 2018 um 12:01 UTC](https://forum.shopware.com/t/fehlermeldung-migration-von-magento-version-1-9-3-6-auf-shopware-v5-4-6/54410/1 "2018-08-03T12:01:25Z")
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
---
### Author:  [@DennisG](https://forum.shopware.com/u/DennisG)
#### Post date: [3. August 2018 um 12:40 UTC](https://forum.shopware.com/t/fehlermeldung-migration-von-magento-version-1-9-3-6-auf-shopware-v5-4-6/54410/2 "2018-08-03T12:40:49Z")
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:
>
---
### Author:  [@HerfagGmbH](https://forum.shopware.com/u/HerfagGmbH)
#### Post date: [10. August 2018 um 06:35 UTC](https://forum.shopware.com/t/fehlermeldung-migration-von-magento-version-1-9-3-6-auf-shopware-v5-4-6/54410/3 "2018-08-10T06:35:37Z")
Vielen Dank 🙂