Wir haben aktuell einen Fall, bei dem Inhalte teilweise verschwinden, wenn man ein Update von webEdition 8.0.5 auf 8.0.6 durchführt. Das Update läuft ohne Unterbrechung durch
PHP Version 7.4.32
MySQL Version 5.7.41
Verschiedene Strategien führten zum selben Ergebnis, z.B. haben wir einen kompletten Rebuild (Dokumente und Templates) durchlaufen lassen vor dem Update und haben eine Update-Wiederholung vor dem Update auf 8.0.6 gemacht.
Einziger Fehler im Update-Log:
Code
tblversions.sql: Einige Datenbankanfragen konnten nicht durchgeführt werden.1115 Unknown+character+set%3A+%27ENUM%27
-- ALTER TABLE `tblversions` MODIFY CreatorID int unsigned NOT NULL DEFAULT '0' AFTER `CreationDate`,MODIFY TemplateID int unsigned NULL AFTER `Path`,MODIFY Extension tinytext NULL AFTER `Filename`,MODIFY IsDynamic BOOLEAN NOT NULL DEFAULT '0' AFTER `Extension`,MODIFY IsSearchable BOOLEAN NOT NULL DEFAULT '0' AFTER `IsDynamic`,MODIFY DocType mediumint unsigned NOT NULL DEFAULT '0' AFTER `ClassName`,MODIFY Category text NULL AFTER `DocType`,MODIFY RestrictOwners BOOLEAN NOT NULL DEFAULT '0' AFTER `Category`,MODIFY Owners tinytext NULL AFTER `RestrictOwners`,MODIFY OwnersReadOnly text NULL AFTER `Owners`,MODIFY WebUserID bigint unsigned NULL AFTER `Language`,MODIFY Workspaces text NULL AFTER `WebUserID`,MODIFY Templates tinytext NULL AFTER `Workspaces`,MODIFY MasterTemplateID int unsigned NULL AFTER `Templates`,MODIFY TableID mediumint unsigned NULL AFTER `MasterTemplateID`,MODIFY ObjectID int unsigned NULL AFTER `TableID`,MODIFY IsClassFolder BOOLEAN NULL, Charset ENUM('','UTF-8','ISO-8859-1','ISO-8859-2','ISO-8859-3','ISO-8859-4','ISO-8859-5','ISO-8859-6','ISO-8859-7','ISO-8859-8','ISO-8859-9','ISO-8859-10','ISO-8859-11','ISO-8859-12','ISO-8859-13','ISO-8859-14','ISO-8859-15','Windows-1251','Windows-1252') NOT NULL default '' AFTER `ObjectID`,MODIFY active BOOLEAN NOT NULL DEFAULT '0' AFTER `Charset`,MODIFY fromScheduler BOOLEAN NOT NULL DEFAULT '0' AFTER `active`,MODIFY fromImport BOOLEAN NOT NULL DEFAULT '0' AFTER `fromScheduler`,MODIFY resetFromVersion bigint unsigned NULL AFTER `fromImport`,MODIFY InGlossar BOOLEAN NOT NULL DEFAULT '0' AFTER `resetFromVersion` --
1115 Unknown+character+set%3A+%27ENUM%27
-- ALTER TABLE `tblversions` MODIFY CreatorID int unsigned NOT NULL DEFAULT '0' AFTER `CreationDate`,MODIFY TemplateID int unsigned NULL AFTER `Path`,MODIFY Extension tinytext NULL AFTER `Filename`,MODIFY IsDynamic BOOLEAN NOT NULL DEFAULT '0' AFTER `Extension`,MODIFY IsSearchable BOOLEAN NOT NULL DEFAULT '0' AFTER `IsDynamic`,MODIFY DocType mediumint unsigned NOT NULL DEFAULT '0' AFTER `ClassName`,MODIFY Category text NULL AFTER `DocType`,MODIFY RestrictOwners BOOLEAN NOT NULL DEFAULT '0' AFTER `Category`,MODIFY Owners tinytext NULL AFTER `RestrictOwners`,MODIFY OwnersReadOnly text NULL AFTER `Owners`,MODIFY WebUserID bigint unsigned NULL AFTER `Language`,MODIFY Workspaces text NULL AFTER `WebUserID`,MODIFY Templates tinytext NULL AFTER `Workspaces`,MODIFY MasterTemplateID int unsigned NULL AFTER `Templates`,MODIFY TableID mediumint unsigned NULL AFTER `MasterTemplateID`,MODIFY ObjectID int unsigned NULL AFTER `TableID`,MODIFY IsClassFolder BOOLEAN NULL, Charset ENUM('','UTF-8','ISO-8859-1','ISO-8859-2','ISO-8859-3','ISO-8859-4','ISO-8859-5','ISO-8859-6','ISO-8859-7','ISO-8859-8','ISO-8859-9','ISO-8859-10','ISO-8859-11','ISO-8859-12','ISO-8859-13','ISO-8859-14','ISO-8859-15','Windows-1251','Windows-1252') NOT NULL default '' AFTER `ObjectID`,MODIFY active BOOLEAN NOT NULL DEFAULT '0' AFTER `Charset`,MODIFY fromScheduler BOOLEAN NOT NULL DEFAULT '0' AFTER `active`,MODIFY fromImport BOOLEAN NOT NULL DEFAULT '0' AFTER `fromScheduler`,MODIFY resetFromVersion bigint unsigned NULL AFTER `fromImport`,MODIFY InGlossar BOOLEAN NOT NULL DEFAULT '0' AFTER `resetFromVersion` --
Hat jemand eine Idee?