Probleme mit Installtool / Datenbank Überprüfung

[mapfei]

Hi zusammen,

ich habe aktuell massiv Probleme, Erweiterungen zu installieren bzw. zu deinstallieren.

Installtool schmiert mit folgender Meldung ab:

[2024-02-27T08:32:28.150129+01:00] request.INFO: Matched route "contao_install". {"route":"contao_install","route_parameters":{"_route":"contao_install","_scope":"backend","_token_check":true,"_controller":"Contao\\InstallationBundle\\Controller\\InstallationController::installAction"},"request_uri":"https://mywebsite.de/contao/install","method":"POST"} []
[2024-02-27T08:32:28.488566+01:00] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DriverException: "An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs" at /home/website/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php line 117 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 1118): An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /home/website/vendor/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php:117)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 1118): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /home/website/vendor/doctrine/dbal/src/Driver/PDO/Exception.php:28)\n[previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs at /home/website/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:33)"} []

Überprüfung der Datenbank über den CM ergibt:

ALTER TABLE tl_module DROP addSocialTags
ALTER TABLE tl_module DROP googleMapPopupTemplate
ALTER TABLE tl_module DROP realEstateTemplate
ALTER TABLE tl_module DROP realEstateContactPersonTemplate
ALTER TABLE tl_module DROP realEstateProviderTemplate
ALTER TABLE tl_module DROP filter
ALTER TABLE tl_module DROP listMode
ALTER TABLE tl_module DROP hideOnEmpty
ALTER TABLE tl_module DROP realEstateGroups
ALTER TABLE tl_module DROP realEstateTypes
ALTER TABLE tl_module DROP addCountLabel
ALTER TABLE tl_module DROP listSorting
ALTER TABLE tl_module DROP addSorting
ALTER TABLE tl_module DROP filterByProvider
ALTER TABLE tl_module DROP provider
ALTER TABLE tl_module DROP defaultSorting
ALTER TABLE tl_module DROP addCustomOrder
ALTER TABLE tl_module DROP customOrder
ALTER TABLE tl_module DROP addProvider
ALTER TABLE tl_module DROP addContactPerson
ALTER TABLE tl_module DROP filterMode
ALTER TABLE tl_module DROP maxTextLength
ALTER TABLE tl_module DROP statusTokens
ALTER TABLE tl_module DROP allowUnpublishedRecords
ALTER TABLE tl_module DROP exposeModules
ALTER TABLE tl_module DROP contactPersonImgSize
ALTER TABLE tl_module DROP providerImgSize
ALTER TABLE tl_module DROP numberOfMainDetails
ALTER TABLE tl_module DROP numberOfMainAttributes
ALTER TABLE tl_module ADD plentaJobsBasicSortingFields MEDIUMTEXT DEFAULT NULL
ALTER TABLE tl_module ADD plentaJobsBasicShowSorting CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD plentaJobsBasicShowLocationQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD plentaJobsBasicShowAllLocations CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD plentaJobsBasicLocationsHeadline TINYTEXT DEFAULT NULL
ALTER TABLE tl_module ADD plentaJobsBasicShowLocations CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD plentaJobsBasicShowQuantity CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD plentaJobsBasicShowAllTypes CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD plentaJobsBasicTypesHeadline TINYTEXT DEFAULT NULL
ALTER TABLE tl_module ADD plentaJobsBasicShowTypes CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD plentaJobsBasicSubmit VARCHAR(64) DEFAULT '' NOT NULL
ALTER TABLE tl_module ADD plentaJobsBasicShowButton CHAR(1) CHARACTER SET ascii DEFAULT '' NOT NULL COLLATE `ascii_bin`
ALTER TABLE tl_module ADD plentaJobsBasicHeadlineTag VARCHAR(3) CHARACTER SET ascii DEFAULT 'h2' NOT NULL COLLATE `ascii_bin`

Datenbank-Version ist 10.6-MariaDB, Hoster ist hostpoint.ch

[Spooky]

Erstelle ein Datenbank Backup, danach folgenden Query ausführen:

OPTIMIZE TABLE tl_module;

Danach auf Contao 4.13.37 oder 5.3.0 aktualisieren, falls das noch nicht gemacht wurde.