Bestellungen lassen sich im Admin-Bereich nicht öffnen

Shopware 6 (German)
1

Hallo zusammen,

ich habe einen komplett neuen SW6-Shop erstellt und nachdem nun alles fertig ist - habe ich meine ersten Testbestellungen durchgeführt.

Die Bestellungen kommen rein, der E-Mail-Versand, usw. funktioniert alles einwandfrei - aber ich komme im Admin-Bereich über die Übersicht der Bestellungen nicht in die einzelnen Bestellungen rein.

Die jeweilige Bestellung lädt sich ins unendliche - siehe Screenshot.

Screenshot 2023-09-07 at 13-47-11 Bestellungen Shopware Administration
Screenshot 2023-09-07 at 13-47-11 Bestellungen Shopware Administration3314×1891 151 KB

Ich habe nun einmal alle Plugins und das Theme deaktiviert, den Cache geleert und den Shop einmal auf die aktuelle SW-Version 6.5.5.1 upgedatet - aber es funktioniert immer noch nicht.

Mein Verdacht war zuerst, dass die Ressourcen des Hosters evtl. nicht ausreichen, aber der Hoster konnte keine entsprechenden Fehler finden. Es gibt auch keine Log-Meldungen, die auf das Problem hinweisen könnten.

Weiss jemand von euch, woran das evtl. liegen kann? Oder hat jemand eine Idee was ich noch ausprobieren könnte?

LG

2

In solchen Fälle immer die Logs durchsuchen. Vom Betrachten des Screenshots habe ich leider auch keine Ahnung :slight_smile:

3

Also ich hab tatsächlich nicht in die log-Datei von SW gestöbert… aber hier sind u.a. folgende Einträge, die sich ständig wiederholen:

[2023-09-07T10:08:26.046519+00:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\UniqueConstraintViolationException: „An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‚\x01\x8Ao\x1Axfs\x13\x82\x8D59\xA5R\x05\xDA‘ for key ‚order.PRIMARY‘“ at /…/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 62 {„exception“:„[object] (Doctrine\DBAL\Exception\UniqueConstraintViolationException(code: 1062): An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‚\x01\x8Ao\x1Axfs\x13\x82\x8D59\xA5R\x05\xDA‘ for key ‚order.PRIMARY‘ at /…/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:62)\n[previous exception] [object] (Doctrine\DBAL\Driver\PDO\Exception(code: 1062): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‚\x01\x8Ao\x1Axfs\x13\x82\x8D59\xA5R\x05\xDA‘ for key ‚order.PRIMARY‘ at /…/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‚\x01\x8Ao\x1Axfs\x13\x82\x8D59\xA5R\x05\xDA‘ for key ‚order.PRIMARY‘ at /…/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:32)“}

[2023-09-07T10:03:56.207612+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: „Another worker is already running for receiver: „async““ at /…/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php line 37 {„exception“:„[object] (Shopware\Core\Framework\MessageQueue\MessageQueueException(code: 0): Another worker is already running for receiver: "async" at /…/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:37)“}

4

Du müsstest ggf. die Logs heraus suchen, welche auch zeitlich zu dem Öffnen der Bestellungen im Admin passen.

5

Weitere Logs waren nicht mehr vorhanden. Aber ich konnte das Problem tatsächlich anhand des Log-Eintrages oben finden und beheben.

In der Datebank-Tabelle „order“ fehlte im Schlüsselnamen PRIMARY die Spalte „version_id“ - darauf kam ich als ich die Tabelle mit einer anderen SW6-Installation verglich.

Seit dem Hinzufügen der Spalte im Schlüsselnamen funktioniert es nun und die einzelen Bestellungen laden und sind aufrufbar. Hoffentlich tauchen keine weiteren Fehler auf :slight_smile:

Aber vielen Dank für deine Mithilfe.

6

Moin,

du solltest dir deine Message Queue noch anschauen. Es scheint so, als hättest du Admin Worker und CLI Worker aktiv:

„Another worker is already running for receive“

7

Ich habe das selbe Problem, ich habe die Tabelle „order“ angesehen, aber die Spalte version_id ist vorhanden. Den Rest verstehe ich nicht ganz, soweit ich in phpMyAdmin sehen kann ist die Spalte auch als Primärschlüssel definiert, was meinst du mit „im Schlüsselnamen PRIMARY“ das hat sich mir nicht ganz erschlossen. Anbei Screenshots aus phpMyAdmin:

shopware-6-screen-order-tabelle-struktur
shopware-6-screen-order-tabelle-struktur1078×506 95.5 KB

shopware-6-screen-order-tabelle
shopware-6-screen-order-tabelle1644×603 84.6 KB

shopware-6-screen-order-tabelle-indizes
shopware-6-screen-order-tabelle-indizes1028×412 81.5 KB

8

Ähm, das ist alles in Ordnung und soll auch so sein.

9

Danke für deine schnelle Antwort, ja schon klar, der Vorredner meinte das dies bei Ihm das Problem war:

In der Datebank-Tabelle „order“ fehlte im Schlüsselnamen PRIMARY die Spalte „version_id“ - darauf kam ich als ich die Tabelle mit einer anderen SW6-Installation verglich.<

Dies ist auch als Lösung markiert.

10

ah ganz übersehen, alles klar :slight_smile:

11

Kein Problem, aber nun ist es so auch bei mir ist die Bestellung vorhanden in der übersicht, sobald man diese öffnen will lädt diese unendlich. Fehlerlog:

[2024-10-22T13:39:42.063928+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:40:32.544976+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:40:42.676518+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:41:11.362151+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\System\Language\Exception\LanguageForeignKeyDeleteException: "The language cannot be deleted because foreign key constraints exist." at LanguageExceptionHandler.php line 20 {"exception":"[object] (Shopware\\Core\\System\\Language\\Exception\\LanguageForeignKeyDeleteException(code: 0): The language cannot be deleted because foreign key constraints exist. at /html/shopware/vendor/shopware/core/System/Language/LanguageExceptionHandler.php:20)\n[previous exception] [object] (Doctrine\\DBAL\\Exception\\ForeignKeyConstraintViolationException(code: 1216): An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1216 Cannot add or update a child row: a foreign key constraint fails at /html/shopware/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:56)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1216): SQLSTATE[23000]: Integrity constraint violation: 1216 Cannot add or update a child row: a foreign key constraint fails at /html/shopware/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1216 Cannot add or update a child row: a foreign key constraint fails at /html/shopware/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:33)"} []
[2024-10-22T13:41:33.103160+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:41:43.240310+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:42:33.807685+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:42:43.985748+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:43:34.539533+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:43:44.694584+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:44:35.163003+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:44:45.321101+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:45:35.882675+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:45:46.010778+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:46:36.496145+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:46:46.653452+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:47:37.129476+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:47:47.283660+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:48:37.793830+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:48:47.936778+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:49:34.755575+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:50:25.247760+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:50:35.425278+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:51:25.942016+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:51:36.114059+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:52:26.624048+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:52:36.815881+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:53:27.340909+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:53:37.521564+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:54:28.062640+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:54:38.225838+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:55:28.749357+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:55:38.892264+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:56:29.368130+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:56:39.503443+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:57:30.088284+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:57:40.224319+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:58:30.719024+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:58:40.900257+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:59:31.462294+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T13:59:41.589107+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T14:00:32.094854+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T14:00:42.238234+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T14:01:32.715131+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T14:01:42.907881+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T14:02:33.417394+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T14:02:43.626295+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T14:03:34.077004+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []
[2024-10-22T14:03:44.853945+00:00] request.ERROR: Uncaught PHP Exception Shopware\Core\Framework\MessageQueue\MessageQueueException: "Another worker is already running for receiver: "async"" at MessageQueueException.php line 39 {"exception":"[object] (Shopware\\Core\\Framework\\MessageQueue\\MessageQueueException(code: 0): Another worker is already running for receiver: \"async\" at /html/shopware/vendor/shopware/core/Framework/MessageQueue/MessageQueueException.php:39)"} []

Zeitpunkt der Testbestellung
14:31 Uhr

12

Ich habe gerade nachgesehen, aber anhand deiner Screenshots passt das alles. Bei mir war es damals so, dass die Spalte version_Id tatsächlich einfach so fehlte, aber das scheint bei dir nicht der Fall zu sein - dann bringt dir meine Lösung gar nichts.

Evtl. ist dieser Beitrag noch interessant für dich? Fehler: Another worker is already running for receiver: “async”

13

Vielen Dank für die Rückmeldungen. Der verlinkte Beitrag beschäftigt sich mit einem anderen Problem, dem doppelten Worker. Auch dies versuche ich zu lösen und auch hier bin ich noch nicht erfolgreich fündig geworden. Aber dies ist denke ich ein eigener Thread. Die Testbestellung lässt sich leider immer noch nicht öffnen. In der Übersicht sieht alles top aus, sobald man auf Anzeigen oder die Bestellnummer Klickt lädt die Seite unendlich. Siehe Screenshots anbei.

shopware-6-screen-bestellung-uebersicht
shopware-6-screen-bestellung-uebersicht1577×200 25.1 KB

shopware-6-screen-bestellung-laedt-unendlich
shopware-6-screen-bestellung-laedt-unendlich1093×697 16.7 KB

14

Schau mal in der Browser-Entwicklerkonsole, was bei den entsprechenden Requests zurückkommt. Gegebenenfalls Dev-Modus noch zusätzlich aktivieren.

Grundsätzlich ist die Einrichtung/Konfiguration und der (technische) Betrieb von Shopware 6 ohne tiefergehendes technischen Wissen und Erfahrung mit Shopware leider nicht mehr (wie bei Shopware 5) möglich/sinnvoll.

15

Hier die Ausgabe der Entwicklerkonsole:

shopware-6-screen-bestellung-laedt-unendlich-dev
shopware-6-screen-bestellung-laedt-unendlich-dev1614×950 134 KB

16

Geh mal dort in den Netzwerk-Tab, klicke auf den „roten“ Request und schaue was dort als Fehlermeldung in der Rückgabe/Preview steht.

Edit:
Ach - bist du ja schon oben. Da sollte es mindestens einen fehlerhaften Request (Order Detail vermutlich) geben. Da wäre die Rückgabe, bzw. die genaue Fehlermeldung interessant.

17

Okay ich habe folgendes gefunden:

shopware-6-screen-bestellung-laedt-unendlich-dev-network
shopware-6-screen-bestellung-laedt-unendlich-dev-network503×539 52.5 KB

{
    "errors": [
        {
            "status": "400",
            "code": "FRAMEWORK__LANGUAGE_FOREIGN_KEY_DELETE",
            "title": "Bad Request",
            "detail": "The language cannot be deleted because foreign key constraints exist.",
            "meta": {
                "parameters": []
            }
        }
    ]
}
18

Da müsste man sich die Bestellung mal in der Datenbank ansehen. Da fehlt mit aller Wahrscheinlichkeit nach irgendeine Verknüpfung.

Von welcher Version hast du auf die 6.5.5.1 aktualisiert?

Insgesamt denke ich aber, dass es sich um grundlegende Probleme bei der Installation/Einrichtung handelt. Zeit- und kostengünstiger wird da tendenziell sein, den Shop einmal sauber auf einem entsprechend optimierten Hosting-Provider aufzusetzen. Beziehungsweise bringen die entsprechenden Provider meistens ein vorinstalliertes Shopware mit.

19

Es handelt sich um die Version 6.6.7.0. Die Installation ist relativ frisch, daher auch eine Testbestellung. Die Installation wurde von unserem Hoster Mittwald, bzw. deren System durchgeführt (Softwaremanager). Danach wurde eine Übernahme unserer ca. 4000 Artikel aus dem aktuell bestehenden Shopware 5 Shop (Livesystem) mittels Shopware Migrations Assistent durchgeführt und nun bin ich dabei alles einzurichten, da unser Shopware 5 Shop abgelöst werden muss. Weil es Shopware eingefallen ist den Shopware 5 Shop nicht mehr weiterzuentwickeln, dieser nun ein extremes Sicherheitsproblem ist und gleichzeitig wird einem mmn. ein unfertiges Produkt vor die Nase gesetzt, welches viele Shopware 5 Grundfunktionen einfach gar nicht mehr aufweist. So, jetzt ist es so aus mir herausgeplatzt :dizzy_face: Screenshots der Bestellung in der Datenbank habe ich weiter oben sogar gepostet, da ist mir auf anhieb nichts aufgefallen.

20

Hmmmmm, es ist schwer von Außerhalb das zu beurteilen. Könnte sein, dass die Migration nicht so gelaufen ist wie sie sollte. Bei der Migration gibt es auch ein Migrations-Log. Wurde das schon analysiert?

Wurden alle Einstellungen aus dem SW5 sauber in SW6 übertragen? Alle Versandarten, alle Zahlungsarten, eingestellten Sparchen korrekt? Wenn sich Bestellungen nicht öffnen lassen, fehlt vermutlich etwas. Eventuell beim öffnen einer Bestellung auch mal im Server-Log schauen ob es da PHP Fehler gibt. Zusätzlich kann man noch das Frosh-Tool installieren und sich die Shopware-Logs ansehen. Da sollten auch Infos stehen.