Hallo Zusammen
Beim Installationsabschnitt „Installation“ (Schritt 70 von 250) bekomme ich immer folgenden Fehler:
Error
Received an error message.
URL: importDatabase
Message:
Please try to fix this error and restart the update.
Response
{"valid":false,"errorMsg":"An exception occurred while executing '\n CREATE TABLE `custom_field` (\n `id` BINARY(16) NOT NULL PRIMARY KEY,\n `name` VARCHAR(255) NOT NULL,\n `type` VARCHAR(255) NOT NULL,\n `config` JSON NULL,\n `active` TINYINT(1) NOT NULL DEFAULT 1,\n `set_id` BINARY(16) NULL,\n `created_at` DATETIME(3) NOT NULL,\n `updated_at` DATETIME(3) NULL,\n CONSTRAINT `uniq.custom_field.name` UNIQUE (`name`),\n CONSTRAINT `json.custom_field.config` CHECK(JSON_VALID(`config`)),\n CONSTRAINT `fk.custom_field.set_id` FOREIGN KEY (set_id)\n REFERENCES `custom_field_set` (id) ON UPDATE CASCADE ON DELETE CASCADE\n ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;\n ':\n\nSQLSTATE[HY000]: General error: 1005 Can't create table `web0230_shop`.`custom_field` (errno: 150 \"Foreign key constraint is incorrectly formed\")"}
Merkwürdigerweise geht es, wenn ich SW6 lokal auf XAMP installiere. Auf dem Webserver will es aber nicht.
Danke & Gruß
Gan