Bei einem Update auf Shopware 6.3 erscheint die folgende Fehlermeldung:
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“}
Die Tabellen wurden von der Datenbank entfernt, aber es hilft nicht (es tauchen weitere solche Fehler auf, aber bezogen auf andere Tabellen).
Der Parameter log_bin_trust_function_creators = ON wurde erfolgreich gesetzt, das hat aber auch nicht geholfen.
Alle Plugins wurden deaktiviert, bevor das Update gestartet wurde.