# 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:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![DennisG](https://avatars.discourse-cdn.com/v4/letter/d/9fc348/32.png) [@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")

</div>

Hi,&nbsp;  
also der Fehler sebst steht ja oben.  
&nbsp;

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>

&nbsp;

---

_[View the full topic](https://forum.shopware.com/t/fehlermeldung-migration-von-magento-version-1-9-3-6-auf-shopware-v5-4-6/54410)._