Bekomme folgenden Fehler, wenn ich versuche das Update zu machen!
Warning: unlink(C:\xampp\htdocs\haupt/updates/Master-2.1.44.zip): Resource temporarily unavailable in C:\xampp\htdocs\haupt\application\libraries\Ilch\Transfer.php on line 509
An unexpected error occurred:
MySQL Error: Can't create table `1`.`ilch_articles_access` (errno: 150 "Foreign key constraint is incorrectly formed")
in Query[SubQuery 1]: CREATE TABLE `ilch_articles_access` (
`article_id` INT(11) NOT NULL,
`group_id` INT(11) NOT NULL,
PRIMARY KEY (`article_id`, `group_id`) USING BTREE,
INDEX `FK_ilch_articles_access_[prefix]_groups` (`group_id`) USING BTREE,
CONSTRAINT `FK_ilch_articles_access_[prefix]_articles` FOREIGN KEY (`article_id`) REFERENCES `ilch_articles` (`id`) ON UPDATE NO ACTION ON DELETE CASCADE,
CONSTRAINT `FK_ilch_articles_access_[prefix]_groups` FOREIGN KEY (`group_id`) REFERENCES `ilch_groups` (`id`) ON UPDATE NO ACTION ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
Und bei meiner anderen Seite geht das update, aber im Frontend kommt der Fehler!
MySQL Error: Table '3.ilch_articles_access' doesn't exist
in Query: SELECT `p`.`id`,`p`.`cat_id`,`p`.`date_created`,GROUP_CONCAT(ra.group_id) AS `read_access`,`pc`.`visits`,`pc`.`author_id`,`pc`.`description`,`pc`.`keywords`,`pc`.`title`,`pc`.`teaser`,`pc`.`perma`,`pc`.`content`,`pc`.`img`,`pc`.`img_source`,`pc`.`votes`,`m`.`url_thumb`,`m`.`url`,`u`.`name` FROM `ilch_articles` AS `p` LEFT JOIN `ilch_articles_access` AS `ra` ON `p`.`id` = `ra`.`article_id` LEFT JOIN `ilch_articles_content` AS `pc` ON `p`.`id` = `pc`.`article_id` LEFT JOIN `ilch_media` AS `m` ON `pc`.`img` = `m`.`url` LEFT JOIN `ilch_users` AS `u` ON `pc`.`author_id` = `u`.`id` WHERE (`ra`.`group_id` IN ("3", "9", "1", "2") AND `pc`.`locale` = "") GROUP BY `p`.`id`,`p`.`cat_id`,`p`.`date_created`,`pc`.`visits`,`pc`.`author_id`,`pc`.`description`,`pc`.`keywords`,`pc`.`title`,`pc`.`teaser`,`pc`.`perma`,`pc`.`content`,`pc`.`img`,`pc`.`img_source`,`pc`.`votes`,`m`.`url_thumb`,`m`.`url` ORDER BY `date_created` DESC LIMIT 5
Dazu kann man keine Layouts auswählen, die man haben möchte, die Installiert sind! Oder es wird gesagt das sie Manipuliert worden sind!