Fehler bei Kundenübersicht

Hallo.

nach dem 5.3.4 -> 5.3.7 Update bekomme ich bei der Kundenübersicht (im Backend) die folgende 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

 {

     "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",

     "method": "GET",

     "query": {

         "\_dc": "1518085349021",

         "page": "1",

         "start": "0",

         "limit": "50000",

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

         "module": "backend",

         "controller": "CustomerStream",

         "action": "list"

     },

     "post": []

 }

 No shop data available

 {

     "userId": "65",

     "roleId": "1"

 }

 

 

 

 

Grüße

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

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 Datei CustomerStream.php entsteht. Dann könnte man auch die Gründe für die Fehlermeldung finden.

 

\var\cache\production_201803081536\doctrine\attributes\CustomerStream.php

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

<?php

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

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

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

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

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