Hallo, nach einem Update was schiefgelaufen ist, musste ich das Backup wieder drauf spielen. Dabei habe ich die Datenbank neu importiert und die Daten auf den Server geschoben. Jetzt befindet sich die Seite im Dauer Wartungsmodus. Ich habe den Befehl verwendet /recovery/update/index.php/cleanup um da wieder herauszukommen. Hat immer funktioniert. Jetzt erhalte ich folgende Fehler Meldung:
Fatal error** : Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‚usr_p409537_4.system_config‘ doesn’t exist in /html/shopware/vendor/shopware/recovery/Common/src/Service/SystemConfigService.php:21 Stack trace: #0 /html/shopware/vendor/shopware/recovery/Common/src/Service/SystemConfigService.php(21): PDOStatement->execute(Array) #1 /html/shopware/vendor/shopware/recovery/Update/src/app.php(140): Shopware\Recovery\Common\Service\SystemConfigService->set(‚core.update.tok…‘, ‚{"_value":"5ac2…‘) #2 [internal function]: Closure->{closure}(Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #3 /html/shopware/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/Handlers/Strategies/RequestResponse.php(40): call_user_func(Object(Closure), Object(Slim\Http\Request), Object(Slim\Http\Response), Array) #4 /html/shopware/vendor/shopware/recovery/Common/vendor/slim/slim/Slim/Route.php(281): Slim\Handlers\Strategies\RequestResponse->__invoke(Object(Closure), Object(Slim\Http\Request), Object(S in /html/shopware/vendor/shopware/recovery/Common/src/Service/SystemConfigService.php on line **21
Kann damit wer was anfangen? Wie kann ich den Shop wieder zum Laufen bringen?
Beste Grüße
Zusätzlich ist es so wenn Ich das Update neu startet mit /recovery/update/index.php kommt folgender fehler:
Error
Received the following error message:
An exception occurred while executing ’ CREATE TABLE language
( id
BINARY(16) NOT NULL, name
VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL, parent_id
BINARY(16) NULL, locale_id
BINARY(16) NOT NULL, translation_code_id
BINARY(16) NULL, custom_fields
JSON NULL, created_at
DATETIME(3) NOT NULL, updated_at
DATETIME(3) NULL, PRIMARY KEY (id
), UNIQUE uniq.translation_code_id
(translation_code_id), KEY idx.language.translation_code_id
(translation_code_id
), KEY idx.language.language_id_parent_language_id
(id
, parent_id
), CONSTRAINT json.language.custom_fields
CHECK (JSON_VALID(custom_fields
)), CONSTRAINT fk.language.parent_id
FOREIGN KEY (parent_id
) REFERENCES language
(id
) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; ': SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‚language‘ already exists
Please try to fix this error and restart the update.
Response
{„valid“:false,„errorMsg“:„An exception occurred while executing '\n CREATE TABLE language
(\n id
BINARY(16) NOT NULL,\n name
VARCHAR(50) COLLATE utf8mb4_unicode_ci NOT NULL,\n parent_id
BINARY(16) NULL,\n locale_id
BINARY(16) NOT NULL,\n translation_code_id
BINARY(16) NULL,\n custom_fields
JSON NULL,\n created_at
DATETIME(3) NOT NULL,\n updated_at
DATETIME(3) NULL,\n PRIMARY KEY (id
),\n UNIQUE uniq.translation_code_id
(translation_code_id),\n KEY idx.language.translation_code_id
(translation_code_id
),\n KEY idx.language.language_id_parent_language_id
(id
, parent_id
),\n CONSTRAINT json.language.custom_fields
CHECK (JSON_VALID(custom_fields
)),\n CONSTRAINT fk.language.parent_id
FOREIGN KEY (parent_id
)\n REFERENCES language
(id
) ON DELETE CASCADE ON UPDATE CASCADE\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\n ':\n\nSQLSTATE[42S01]: Base table or view already exists: 1050 Table ‚language‘ already exists“}