# Fehler bei Kundenübersicht

**URL:** <https://forum.shopware.com/t/fehler-bei-kundenubersicht/50993>\
**Category:** Administration\
**Created:** [8. Februar 2018 um 10:39 UTC](https://forum.shopware.com/t/fehler-bei-kundenubersicht/50993 "2018-02-08T10:39:30Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![esomatic](https://avatars.discourse-cdn.com/v4/letter/e/e99b99/32.png) [@esomatic](https://forum.shopware.com/u/esomatic)\
**Post date:** [8. Februar 2018 um 10:39 UTC](https://forum.shopware.com/t/fehler-bei-kundenubersicht/50993/1 "2018-02-08T10:39:30Z")

</div>

Hallo.

nach dem 5.3.4 -\> 5.3.7 Update bekomme ich bei der Kundenübersicht (im Backend) die folgende&nbsp;Fehlermeldung. Nach Quittierung der Fehlermeldungen lassen sich die Adressen ohne Probleme anzeigen. Hat da einer einen Tipp, wo ich mit der Fehlersuche beginnen sollte.

```
 BadMethodCallException: Type of association must be one of \*\_TO\_ONE or MANY\_TO\_MANY in /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php:1028

 Stack trace:

 #0 /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(1155): Doctrine\ORM\Query\SqlWalker-\>walkJoinAssociationDeclaration(Object(Doctrine\ORM\Query\AST\JoinAssociationDeclaration), 1, NULL)

 #1 /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(837): Doctrine\ORM\Query\SqlWalker-\>walkJoin(Object(Doctrine\ORM\Query\AST\Join))

 #2 /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(815): Doctrine\ORM\Query\SqlWalker-\>walkIdentificationVariableDeclaration(Object(Doctrine\ORM\Query\AST\IdentificationVariableDeclaration))

 #3 /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(522): Doctrine\ORM\Query\SqlWalker-\>walkFromClause(Object(Doctrine\ORM\Query\AST\FromClause))

 #4 /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Exec/SingleSelectExecutor.php(42): Doctrine\ORM\Query\SqlWalker-\>walkSelectStatement(Object(Doctrine\ORM\Query\AST\SelectStatement))

 #5 /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Query/SqlWalker.php(277): Doctrine\ORM\Query\Exec\SingleSelectExecutor-\>\_\_construct(Object(Doctrine\ORM\Query\AST\SelectStatement), Object(Doctrine\ORM\Query\SqlWalker))

 #6 /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Query/Parser.php(390): Doctrine\ORM\Query\SqlWalker-\>getExecutor(Object(Doctrine\ORM\Query\AST\SelectStatement))

 #7 /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(263): Doctrine\ORM\Query\Parser-\>parse()

 #8 /var/customers/webs/esomatic/www534/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/Pagination/Paginator.php(123): Doctrine\ORM\Tools\Pagination\Paginator-\>getCountQuery()

 #9 /var/customers/webs/esomatic/www534/engine/Shopware/Components/Api/Resource/CustomerStream.php(163): Doctrine\ORM\Tools\Pagination\Paginator-\>count()

 #10 /var/customers/webs/esomatic/www534/engine/Shopware/Controllers/Backend/CustomerStream.php(261): Shopware\Components\Api\Resource\CustomerStream-\>getList('0', '50000', Array, Array)

 #11 /var/customers/webs/esomatic/www534/engine/Shopware/Controllers/Backend/Application.php(209): Shopware\_Controllers\_Backend\_CustomerStream-\>getList('0', '50000', Array, Array, Array)

 #12 /var/customers/webs/esomatic/www534/engine/Library/Enlight/Controller/Action.php(159): Shopware\_Controllers\_Backend\_Application-\>listAction()

 #13 /var/customers/webs/esomatic/www534/engine/Library/Enlight/Controller/Dispatcher/Default.php(530): Enlight\_Controller\_Action-\>dispatch('listAction')

 #14 /var/customers/webs/esomatic/www534/engine/Library/Enlight/Controller/Front.php(223): Enlight\_Controller\_Dispatcher\_Default-\>dispatch(Object(Enlight\_Controller\_Request\_RequestHttp), Object(Enlight\_Controller\_Response\_ResponseHttp))

 #15 /var/customers/webs/esomatic/www534/engine/Shopware/Kernel.php(191): Enlight\_Controller\_Front-\>dispatch()

 #16 /var/customers/webs/esomatic/www534/vendor/symfony/http-kernel/HttpCache/HttpCache.php(484): Shopware\Kernel-\>handle(Object(Symfony\Component\HttpFoundation\Request), 1, true)

 #17 /var/customers/webs/esomatic/www534/engine/Shopware/Components/HttpCache/AppCache.php(268): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true, NULL)

 #18 /var/customers/webs/esomatic/www534/vendor/symfony/http-kernel/HttpCache/HttpCache.php(251): Shopware\Components\HttpCache\AppCache-\>forward(Object(Symfony\Component\HttpFoundation\Request), true)

 #19 /var/customers/webs/esomatic/www534/engine/Shopware/Components/HttpCache/AppCache.php(105): Symfony\Component\HttpKernel\HttpCache\HttpCache-\>pass(Object(Symfony\Component\HttpFoundation\Request), true)

 #20 /var/customers/webs/esomatic/www534/shopware.php(118): Shopware\Components\HttpCache\AppCache-\>handle(Object(Symfony\Component\HttpFoundation\Request))

 #21 {main}

 2018-02-08T11:19:48.229840+0100

 core

 {

 &nbsp;&nbsp;&nbsp; "uri": "/backend/CustomerStream/list?\_dc=1518085349021&page=1&start=0&limit=50000&sort=%5B%7B%22property%22%3A%22stream.name%22%2C%22direction%22%3A%22ASC%22%7D%5D",

 &nbsp;&nbsp;&nbsp; "method": "GET",

 &nbsp;&nbsp;&nbsp; "query": {

 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "\_dc": "1518085349021",

 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "page": "1",

 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "start": "0",

 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "limit": "50000",

 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "sort": "[{\"property\":\"stream.name\",\"direction\":\"ASC\"}]",

 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "module": "backend",

 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "controller": "CustomerStream",

 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; "action": "list"

 &nbsp;&nbsp;&nbsp; },

 &nbsp;&nbsp;&nbsp; "post": []

 }

 No shop data available

 {

 &nbsp;&nbsp;&nbsp; "userId": "65",

 &nbsp;&nbsp;&nbsp; "roleId": "1"

 }

```

&nbsp;

&nbsp;

&nbsp;

&nbsp;

Grüße

---

<div class="post-metadata">

**Author:** ![jozi](https://avatars.discourse-cdn.com/v4/letter/j/b4bc9f/32.png) [@jozi](https://forum.shopware.com/u/jozi)\
**Post date:** [19. März 2018 um 02:14 UTC](https://forum.shopware.com/t/fehler-bei-kundenubersicht/50993/2 "2018-03-19T02:14:46Z")

</div>

Hallo,

habe das selbe Problem. Nach dem Schließen der Meldung lassen sich die Kunden ganz normal bearbeiten. Gibt es hier schon eine Lösung? Wäre sehr hilfreich bei der Fehlersuche.

lg Jozi

---

<div class="post-metadata">

**Author:** ![esomatic](https://avatars.discourse-cdn.com/v4/letter/e/e99b99/32.png) [@esomatic](https://forum.shopware.com/u/esomatic)\
**Post date:** [21. März 2018 um 19:34 UTC](https://forum.shopware.com/t/fehler-bei-kundenubersicht/50993/3 "2018-03-21T19:34:11Z")

</div>

den Fehler gefunden habe ich noch nicht, aber wenn ich die Datei CustomerStream.php von einer Neuinstallation nehme ist der Fehler weg.

Vielleicht kann ja jemand was dazu sagen wie die&nbsp;Datei CustomerStream.php entsteht. Dann könnte man auch die Gründe für die Fehlermeldung&nbsp;finden.

&nbsp;

\var\cache\production\_201803081536\doctrine\attributes\CustomerStream.php

--------- nach Update ---------------------------------

\<?php 

/\*\* &nbsp;\* Shopware 5 &nbsp;\* Copyright (c) shopware AG &nbsp;\* &nbsp;\* According to our dual licensing model, this program can be used either &nbsp;\* under the terms of the GNU Affero General Public License, version 3, &nbsp;\* or under a proprietary license. &nbsp;\* &nbsp;\* The texts of the GNU Affero General Public License with an additional &nbsp;\* permission and of our proprietary license can be found at and &nbsp;\* in the LICENSE file you have received along with this program. &nbsp;\* &nbsp;\* This program is distributed in the hope that it will be useful, &nbsp;\* but WITHOUT ANY WARRANTY; without even the implied warranty of &nbsp;\* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the &nbsp;\* GNU Affero General Public License for more details. &nbsp;\* &nbsp;\* "Shopware" is a registered trademark of shopware AG. &nbsp;\* The licensing of the program under the AGPLv3 does not imply a &nbsp;\* trademark license. Therefore any rights, title and interest in &nbsp;\* our trademarks remain entirely with us. &nbsp;\*/ namespace Shopware\Models\Attribute; use Shopware\Components\Model\ModelEntity, &nbsp; &nbsp; Doctrine\ORM\Mapping AS ORM, &nbsp; &nbsp; Symfony\Component\Validator\Constraints as Assert, &nbsp; &nbsp; Doctrine\Common\Collections\ArrayCollection; /\*\* &nbsp;\* @ORM\Entity &nbsp;\* @ORM\Table(name="s\_customer\_streams\_attributes") &nbsp;\*/ class CustomerStream extends ModelEntity { &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; /\*\* &nbsp; &nbsp; &nbsp;\* @var integer $id &nbsp; &nbsp; &nbsp;\* @ORM\Id &nbsp; &nbsp; &nbsp;\* @ORM\GeneratedValue(strategy="IDENTITY") &nbsp; &nbsp; &nbsp;\* @ORM\Column(name="id", type="integer", nullable=false) &nbsp; &nbsp; &nbsp;\*/ &nbsp; &nbsp; &nbsp;protected $id; &nbsp; &nbsp; /\*\* &nbsp; &nbsp; &nbsp;\* @var integer $streamID &nbsp; &nbsp; &nbsp;\* &nbsp; &nbsp; &nbsp;\* @ORM\Column(name="streamID", type="integer", nullable=false) &nbsp; &nbsp; &nbsp;\*/ &nbsp; &nbsp; &nbsp;protected $streamID; &nbsp; &nbsp; public function getId() &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; return $this-\\>id; &nbsp; &nbsp; } &nbsp; &nbsp; public function setId($id) &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; $this-\\>id = $id; &nbsp; &nbsp; &nbsp; &nbsp; return $this; &nbsp; &nbsp; } &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; public function getStreamID() &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; return $this-\\>streamID; &nbsp; &nbsp; } &nbsp; &nbsp; public function setStreamID($streamID) &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; $this-\\>streamID = $streamID; &nbsp; &nbsp; &nbsp; &nbsp; return $this; &nbsp; &nbsp; } &nbsp; &nbsp;&nbsp; } &nbsp; ---------------- von einer Neuinstallation --------------- \<?php 

/\*\* &nbsp;\* Shopware 5 &nbsp;\* Copyright (c) shopware AG &nbsp;\* &nbsp;\* According to our dual licensing model, this program can be used either &nbsp;\* under the terms of the GNU Affero General Public License, version 3, &nbsp;\* or under a proprietary license. &nbsp;\* &nbsp;\* The texts of the GNU Affero General Public License with an additional &nbsp;\* permission and of our proprietary license can be found at and &nbsp;\* in the LICENSE file you have received along with this program. &nbsp;\* &nbsp;\* This program is distributed in the hope that it will be useful, &nbsp;\* but WITHOUT ANY WARRANTY; without even the implied warranty of &nbsp;\* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the &nbsp;\* GNU Affero General Public License for more details. &nbsp;\* &nbsp;\* "Shopware" is a registered trademark of shopware AG. &nbsp;\* The licensing of the program under the AGPLv3 does not imply a &nbsp;\* trademark license. Therefore any rights, title and interest in &nbsp;\* our trademarks remain entirely with us. &nbsp;\*/ namespace Shopware\Models\Attribute; use Shopware\Components\Model\ModelEntity, &nbsp; &nbsp; Doctrine\ORM\Mapping AS ORM, &nbsp; &nbsp; Symfony\Component\Validator\Constraints as Assert, &nbsp; &nbsp; Doctrine\Common\Collections\ArrayCollection; /\*\* &nbsp;\* @ORM\Entity &nbsp;\* @ORM\Table(name="s\_customer\_streams\_attributes") &nbsp;\*/ class CustomerStream extends ModelEntity { &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; /\*\* &nbsp; &nbsp; &nbsp;\* @var integer $id &nbsp; &nbsp; &nbsp;\* @ORM\Id &nbsp; &nbsp; &nbsp;\* @ORM\GeneratedValue(strategy="IDENTITY") &nbsp; &nbsp; &nbsp;\* @ORM\Column(name="id", type="integer", nullable=false) &nbsp; &nbsp; &nbsp;\*/ &nbsp; &nbsp; &nbsp;protected $id; &nbsp; &nbsp; /\*\* &nbsp; &nbsp; &nbsp;\* @var integer $customerStreamId &nbsp; &nbsp; &nbsp;\* &nbsp; &nbsp; &nbsp;\* @ORM\Column(name="streamID", type="integer", nullable=false) &nbsp; &nbsp; &nbsp;\*/ &nbsp; &nbsp; &nbsp;protected $customerStreamId; &nbsp; &nbsp; /\*\* &nbsp; &nbsp; &nbsp;\* @var \Shopware\Models\CustomerStream\CustomerStream &nbsp; &nbsp; &nbsp;\* &nbsp; &nbsp; &nbsp;\* @ORM\OneToOne(targetEntity="Shopware\Models\CustomerStream\CustomerStream", inversedBy="attribute") &nbsp; &nbsp; &nbsp;\* @ORM\JoinColumns({ &nbsp; &nbsp; &nbsp;\* &nbsp; @ORM\JoinColumn(name="streamID", referencedColumnName="id") &nbsp; &nbsp; &nbsp;\* }) &nbsp; &nbsp; &nbsp;\*/ &nbsp; &nbsp; protected $customerStream; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; public function getId() &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; return $this-\\>id; &nbsp; &nbsp; } &nbsp; &nbsp; public function setId($id) &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; $this-\\>id = $id; &nbsp; &nbsp; &nbsp; &nbsp; return $this; &nbsp; &nbsp; } &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; public function getCustomerStreamId() &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; return $this-\\>customerStreamId; &nbsp; &nbsp; } &nbsp; &nbsp; public function setCustomerStreamId($customerStreamId) &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; $this-\\>customerStreamId = $customerStreamId; &nbsp; &nbsp; &nbsp; &nbsp; return $this; &nbsp; &nbsp; } &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; public function getCustomerStream() &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; return $this-\\>customerStream; &nbsp; &nbsp; } &nbsp; &nbsp; public function setCustomerStream($customerStream) &nbsp; &nbsp; { &nbsp; &nbsp; &nbsp; &nbsp; $this-\\>customerStream = $customerStream; &nbsp; &nbsp; &nbsp; &nbsp; return $this; &nbsp; &nbsp; } &nbsp; &nbsp;&nbsp; } &nbsp; &nbsp; &nbsp;

---

<div class="post-metadata">

**Author:** ![BeautyLounge](https://avatars.discourse-cdn.com/v4/letter/b/919ad9/32.png) [@BeautyLounge](https://forum.shopware.com/u/BeautyLounge)\
**Post date:** [21. Juli 2018 um 18:04 UTC](https://forum.shopware.com/t/fehler-bei-kundenubersicht/50993/4 "2018-07-21T18:04:01Z")

</div>

Hab das gleiche Problem. Gibt es da eine Lösung dazu?

---

<div class="post-metadata">

**Author:** ![loewenherz1976](https://avatars.discourse-cdn.com/v4/letter/l/90ced4/32.png) [@loewenherz1976](https://forum.shopware.com/u/loewenherz1976)\
**Post date:** [3. März 2019 um 16:14 UTC](https://forum.shopware.com/t/fehler-bei-kundenubersicht/50993/5 "2019-03-03T16:14:49Z")

</div>

Hallo zusammen,

bei einem Update (5.5.4 =\> 5.5.6) trat vorab ein Problem auf. Ich musste die Datenbank über ‚Foreign Key Repair‘ reparieren. Danach konnte das Update durchführen. Nun tritt aber die gleiche Fehlermeldung, wie bei euch auf. Die Fehlermeldung ist fast identisch. Wenn ich am Model (/Applications/MAMP/htdocs/motorrad2/var/cache/production\_201902250948/doctrine/attributes/CustomerStream.php) rumspiele, wie oben beschrieben, ist die Fehlermeldung kurzzeitig weg. Gibt es hierfür schon eine Lösung? Wo könnte man noch ansetzen, um das Problem zu finden? Danke!

VG

---

<div class="post-metadata">

**Author:** ![loewenherz1976](https://avatars.discourse-cdn.com/v4/letter/l/90ced4/32.png) [@loewenherz1976](https://forum.shopware.com/u/loewenherz1976)\
**Post date:** [4. März 2019 um 10:46 UTC](https://forum.shopware.com/t/fehler-bei-kundenubersicht/50993/6 "2019-03-04T10:46:15Z")

</div>

Nachtrag: Das Problem konnte ich jetzt selbst beheben. Nachdem ich den Core durch eine Shopware-Kopie ausgetauscht habe, habe ich auch das Backend-Theme ausgetauscht:

/themes/Backend/ExtJs/backend/

Damit ließen sich die Schwierigkeiten beseitigen. Vermute, dass ich dort etwas versehentlich überschrieben habe. Anders kann ich es mir nicht erklären. :-/

VG