# Nach Update --\> Fatal error: Uncaught PDOException: SQLSTATE\[42S02\]: Base table or view not found: 1146 Table 'usr\_p409537\_4.system\_config' doesn't exist

**URL:** <https://forum.shopware.com/t/nach-update-fatal-error-uncaught-pdoexception-sqlstate-42s02-base-table-or-view-not-found-1146-table-usr-p409537-4-system-config-doesnt-exist/85867>\
**Category:** Shopware 6 (German)\
**Created:** [11. März 2021 um 07:50 UTC](https://forum.shopware.com/t/nach-update-fatal-error-uncaught-pdoexception-sqlstate-42s02-base-table-or-view-not-found-1146-table-usr-p409537-4-system-config-doesnt-exist/85867 "2021-03-11T07:50:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![webdesign-vogel](https://avatars.discourse-cdn.com/v4/letter/w/b4bc9f/32.png) [@webdesign-vogel](https://forum.shopware.com/u/webdesign-vogel)\
**Post date:** [11. März 2021 um 07:50 UTC](https://forum.shopware.com/t/nach-update-fatal-error-uncaught-pdoexception-sqlstate-42s02-base-table-or-view-not-found-1146-table-usr-p409537-4-system-config-doesnt-exist/85867/1 "2021-03-11T07:50:05Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![webdesign-vogel](https://avatars.discourse-cdn.com/v4/letter/w/b4bc9f/32.png) [@webdesign-vogel](https://forum.shopware.com/u/webdesign-vogel)\
**Post date:** [11. März 2021 um 08:01 UTC](https://forum.shopware.com/t/nach-update-fatal-error-uncaught-pdoexception-sqlstate-42s02-base-table-or-view-not-found-1146-table-usr-p409537-4-system-config-doesnt-exist/85867/2 "2021-03-11T08:01:56Z")

</div>

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“}