СправошнаяПоиск

Ошибка при переключении механизма кэширования с диска на базу

После переключения кэширования TYPO3 на диск и Compare Database удаляются таблицы кэша. При обратном переключении они не восстанавливаются и их надо просто добавить руками.

 

CREATE TABLE `cache_rootline` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`expires` int(10) UNSIGNED NOT NULL DEFAULT 0,
`content` longblob DEFAULT NULL,
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_hash` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`expires` int(10) UNSIGNED NOT NULL DEFAULT 0,
`content` longblob DEFAULT NULL,
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_hash_tags`  (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`tag` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_rootline_tags` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`tag` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_pagesection` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`expires` int(10) UNSIGNED NOT NULL DEFAULT 0,
`content` longblob DEFAULT NULL,
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_pagesection_tags` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`tag` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_pages` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`expires` int(10) UNSIGNED NOT NULL DEFAULT 0,
`content` longblob DEFAULT NULL,
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_pages_tags` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`tag` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_imagesizes` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`expires` int(10) unsigned NOT NULL DEFAULT '0',
`content` longblob,
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_imagesizes_tags` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`tag` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

 

При установленной adminPanel

 

CREATE TABLE `cache_adminpanel_requestcache` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`expires` int(10) unsigned NOT NULL DEFAULT '0',
`content` longblob,
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE `cache_adminpanel_requestcache_tags` (
`id` int(10) UNSIGNED NOT NULL auto_increment,
`identifier` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`tag` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;