Guten Abend und vielen Dank für die Tipps.
Ich bin gerade wieder zu meiner Sicherung 3.10.6 zurückgekehrt
In der DB habe ich die unter #17 genannten Tabellen gelöscht (#_finder_logging, #_mail_template, #_workflows...... 4 Stück, #_history, wenn vorhanden" gab es bei mir nicht)
Unter => Global Configuration / Server steht bei mir Database tables => prefix => jsd_
Diese Tabellen habe ich aber nicht angerührt.
DB Version: 5.5.5-10.1.48-MariaDB-0+deb9u2
Ergebnis DB reparieren (da gab es nichts zu tun):
- Database schema version (in #__schemas): 3.10.0-2021-05-28.
- Update version (in #__extensions): 3.10.6.
- Database driver: mysqli.
- 190 database changes were checked.
- 219 database changes did not alter table structure and were skipped.
Letzter Versuch der Migration war leider auch erfolglos. Nachdem ich mich jetzt wirklich über viele Stunden mit dem Thema beschäftigt habe, habe ich jetzt keine Idee mehr.
Letztes Script unter /administrator/components/com_admin/sql/updates/mysql => 4.1.0-2022-01-24.sql
Dies ist die Info aus joomla/logs/joomla_update.php:
Starting installation of new version. |
Finalising installation. |
Start of SQL updates. |
The current database version (schema) is 3.10.0-2021-05-28. |
Ran query from file 4.0.0-2018-03-05. Query text: INSERT INTO `#__extensions` (`name`, `type`, `element`, `folder`, `client_id`, `. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__extensions` WHERE `type` = 'library' AND `element` = 'phputf8';. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__extensions` WHERE `type` = 'plugin' AND `element` = 'p3p' AND `f. |
Ran query from file 4.0.0-2018-03-05. Query text: ALTER TABLE `#__user_keys` DROP COLUMN `invalid`;. |
Ran query from file 4.0.0-2018-03-05. Query text: INSERT INTO `#__extensions` (`name`, `type`, `element`, `folder`, `client_id`, `. |
Ran query from file 4.0.0-2018-03-05. Query text: INSERT INTO `#__template_styles` (`template`, `client_id`, `home`, `title`, `inh. |
Ran query from file 4.0.0-2018-03-05. Query text: UPDATE `#__modules` SET `position` = 'status' WHERE `module` = 'mod_version' AND. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__extensions` WHERE `type` = 'template' AND `element` = 'hathor' A. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__template_styles` WHERE `template` = 'hathor' AND `client_id` = 1. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__extensions` WHERE `type` = 'template' AND `element` = 'isis' AND. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__template_styles` WHERE `template` = 'isis' AND `client_id` = 1;. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__extensions` WHERE `type` = 'template' AND `element` = 'protostar. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__template_styles` WHERE `template` = 'protostar' AND `client_id` . |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__extensions` WHERE `type` = 'template' AND `element` = 'beez3' AN. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__template_styles` WHERE `template` = 'beez3' AND `client_id` = 0;. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__extensions` WHERE `name` = 'mod_submenu';. |
Ran query from file 4.0.0-2018-03-05. Query text: ALTER TABLE `#__extensions` DROP COLUMN `system_data`;. |
Ran query from file 4.0.0-2018-03-05. Query text: INSERT INTO `#__extensions` (`name`, `type`, `element`, `folder`, `client_id`, `. |
Ran query from file 4.0.0-2018-03-05. Query text: UPDATE `#__menu` SET `link` = 'index.php?option=com_config&view=config' WHERE `l. |
Ran query from file 4.0.0-2018-03-05. Query text: UPDATE `#__menu` SET `link` = 'index.php?option=com_config&view=templates' WHERE. |
Ran query from file 4.0.0-2018-03-05. Query text: ALTER TABLE `#__extensions` ADD COLUMN `changelogurl` text AFTER `element`;. |
Ran query from file 4.0.0-2018-03-05. Query text: ALTER TABLE `#__updates` ADD COLUMN `changelogurl` text AFTER `infourl`;. |
Ran query from file 4.0.0-2018-03-05. Query text: INSERT INTO `#__extensions` (`name`, `type`, `element`, `folder`, `client_id`, `. |
Ran query from file 4.0.0-2018-03-05. Query text: INSERT INTO `#__postinstall_messages` (`extension_id`, `title_key`, `description. |
Ran query from file 4.0.0-2018-03-05. Query text: DELETE FROM `#__extensions` WHERE `type` = 'library' AND `element` = 'idna_conve. |
Ran query from file 4.0.0-2018-03-05. Query text: ALTER TABLE `#__modules` CHANGE `content` `content` TEXT NULL;. |
Ran query from file 4.0.0-2018-05-15. Query text: CREATE TABLE IF NOT EXISTS `#__workflows` ( `id` int NOT NULL AUTO_INCREMENT, . |
Ran query from file 4.0.0-2018-05-15. Query text: INSERT INTO `#__workflows` (`id`, `asset_id`, `published`, `title`, `description. |
JInstaller: :Install: Error SQL Duplicate entry '1' for key 'PRIMARY' |
End of SQL updates - INCOMPLETE. |
Cleaning up after installation. |
Update to version 4.1.0 is complete. |