search

tine-groupware / tine

tine groupware main repository
https://www.tine-groupware.de
GNU Affero General Public License v3.0
12 stars 2 forks source link

zusätzliche Komponenten lassen sich nicht installieren. #37

Closed JPRuehmann closed 5 months ago

JPRuehmann commented 6 months ago

Ich habe am Wocchenende die aktuelle Weekly eingespielt. Da werden in der Setup.php eine reihe zusätzlicher Komponenten als nicht installiert angezeigt. Wenn ich diese versuche zu installieren kriege ich nur Fehlermeldungen, z.B. das Handbuch.

An exception occurred while executing 'ALTER TABLE tine20_humanresources_freetimetype ADD color VARCHAR(7) DEFAULT NULL, ADD workingTimeCalculationStrategy LONGTEXT DEFAULT NULL, CHANGE wage_type wage_type VARCHAR(255) DEFAULT NULL, CHANGE timeaccount timeaccount VARCHAR(255) DEFAULT NULL, CHANGE is_deleted is_deleted TINYINT(1) DEFAULT '0' NOT NULL': SQLSTATE[HY000]: General error: 1832 Cannot change column 'wage_type': used in a foreign key constraint 'FK_F5F985AB6F7B263A'

.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
.../vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(922): Doctrine\DBAL\Connection->executeQuery()
.../Setup/SchemaTool.php(193): Doctrine\ORM\Tools\SchemaTool->updateSchema()
.../Setup/Controller.php(1830): Setup_SchemaTool::updateAllSchema()
.../Setup/Frontend/Json.php(93): Setup_Controller->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(231): Setup_Frontend_Json->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(603): Zend_Server_Abstract->_dispatch()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(206): Zend_Json_Server->_handle()
.../Setup/Server/Json.php(90): Zend_Json_Server->handle()
.../Setup/Core.php(117): Setup_Server_Json->handle()
.../setup.php(14): Setup_Core::dispatchRequest()
JPRuehmann commented 5 months ago

Folgende Komponenten laßen sich nicht installieren.

DFCom

An exception occurred while executing 'ALTER TABLE tine20_humanresources_freetimetype ADD color VARCHAR(7) DEFAULT NULL, ADD workingTimeCalculationStrategy LONGTEXT DEFAULT NULL, CHANGE wage_type wage_type VARCHAR(255) DEFAULT NULL, CHANGE timeaccount timeaccount VARCHAR(255) DEFAULT NULL, CHANGE is_deleted is_deleted TINYINT(1) DEFAULT '0' NOT NULL': SQLSTATE[HY000]: General error: 1832 Cannot change column 'wage_type': used in a foreign key constraint 'FK_F5F985AB6F7B263A'

.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
.../vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(922): Doctrine\DBAL\Connection->executeQuery()
.../Setup/SchemaTool.php(193): Doctrine\ORM\Tools\SchemaTool->updateSchema()
.../Setup/Controller.php(1830): Setup_SchemaTool::updateAllSchema()
.../Setup/Frontend/Json.php(93): Setup_Controller->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(231): Setup_Frontend_Json->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(603): Zend_Server_Abstract->_dispatch()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(206): Zend_Json_Server->_handle()
.../Setup/Server/Json.php(90): Zend_Json_Server->handle()
.../Setup/Core.php(117): Setup_Server_Json->handle()
.../setup.php(14): Setup_Core::dispatchRequest()

EFile

An exception occurred while executing 'ALTER TABLE tine20_humanresources_freetimetype ADD color VARCHAR(7) DEFAULT NULL, ADD workingTimeCalculationStrategy LONGTEXT DEFAULT NULL, CHANGE wage_type wage_type VARCHAR(255) DEFAULT NULL, CHANGE timeaccount timeaccount VARCHAR(255) DEFAULT NULL, CHANGE is_deleted is_deleted TINYINT(1) DEFAULT '0' NOT NULL': SQLSTATE[HY000]: General error: 1832 Cannot change column 'wage_type': used in a foreign key constraint 'FK_F5F985AB6F7B263A'

.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
.../vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(922): Doctrine\DBAL\Connection->executeQuery()
.../Setup/SchemaTool.php(193): Doctrine\ORM\Tools\SchemaTool->updateSchema()
.../Setup/Controller.php(1830): Setup_SchemaTool::updateAllSchema()
.../Setup/Frontend/Json.php(93): Setup_Controller->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(231): Setup_Frontend_Json->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(603): Zend_Server_Abstract->_dispatch()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(206): Zend_Json_Server->_handle()
.../Setup/Server/Json.php(90): Zend_Json_Server->handle()
.../Setup/Core.php(117): Setup_Server_Json->handle()
.../setup.php(14): Setup_Core::dispatchRequest()

GDPR

An exception occurred while executing 'ALTER TABLE tine20_humanresources_freetimetype ADD color VARCHAR(7) DEFAULT NULL, ADD workingTimeCalculationStrategy LONGTEXT DEFAULT NULL, CHANGE wage_type wage_type VARCHAR(255) DEFAULT NULL, CHANGE timeaccount timeaccount VARCHAR(255) DEFAULT NULL, CHANGE is_deleted is_deleted TINYINT(1) DEFAULT '0' NOT NULL': SQLSTATE[HY000]: General error: 1832 Cannot change column 'wage_type': used in a foreign key constraint 'FK_F5F985AB6F7B263A'

.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
.../vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(922): Doctrine\DBAL\Connection->executeQuery()
.../Setup/SchemaTool.php(193): Doctrine\ORM\Tools\SchemaTool->updateSchema()
.../Setup/Controller.php(1830): Setup_SchemaTool::updateAllSchema()
.../Setup/Frontend/Json.php(93): Setup_Controller->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(231): Setup_Frontend_Json->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(603): Zend_Server_Abstract->_dispatch()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(206): Zend_Json_Server->_handle()
.../Setup/Server/Json.php(90): Zend_Json_Server->handle()
.../Setup/Core.php(117): Setup_Server_Json->handle()
.../setup.php(14): Setup_Core::dispatchRequest()

OnlyOfficeIntegrator

An exception occurred while executing 'ALTER TABLE tine20_humanresources_freetimetype ADD color VARCHAR(7) DEFAULT NULL, ADD workingTimeCalculationStrategy LONGTEXT DEFAULT NULL, CHANGE wage_type wage_type VARCHAR(255) DEFAULT NULL, CHANGE timeaccount timeaccount VARCHAR(255) DEFAULT NULL, CHANGE is_deleted is_deleted TINYINT(1) DEFAULT '0' NOT NULL': SQLSTATE[HY000]: General error: 1832 Cannot change column 'wage_type': used in a foreign key constraint 'FK_F5F985AB6F7B263A'

.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
.../vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(922): Doctrine\DBAL\Connection->executeQuery()
.../Setup/SchemaTool.php(193): Doctrine\ORM\Tools\SchemaTool->updateSchema()
.../Setup/Controller.php(1830): Setup_SchemaTool::updateAllSchema()
.../Setup/Frontend/Json.php(93): Setup_Controller->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(231): Setup_Frontend_Json->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(603): Zend_Server_Abstract->_dispatch()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(206): Zend_Json_Server->_handle()
.../Setup/Server/Json.php(90): Zend_Json_Server->handle()
.../Setup/Core.php(117): Setup_Server_Json->handle()
.../setup.php(14): Setup_Core::dispatchRequest()

UserManual

An exception occurred while executing 'ALTER TABLE tine20_humanresources_freetimetype ADD color VARCHAR(7) DEFAULT NULL, ADD workingTimeCalculationStrategy LONGTEXT DEFAULT NULL, CHANGE wage_type wage_type VARCHAR(255) DEFAULT NULL, CHANGE timeaccount timeaccount VARCHAR(255) DEFAULT NULL, CHANGE is_deleted is_deleted TINYINT(1) DEFAULT '0' NOT NULL': SQLSTATE[HY000]: General error: 1832 Cannot change column 'wage_type': used in a foreign key constraint 'FK_F5F985AB6F7B263A'

.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(159): Doctrine\DBAL\DBALException::wrapException()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(2225): Doctrine\DBAL\DBALException::driverExceptionDuringQuery()
.../vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(1312): Doctrine\DBAL\Connection->handleExceptionDuringQuery()
.../vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(922): Doctrine\DBAL\Connection->executeQuery()
.../Setup/SchemaTool.php(193): Doctrine\ORM\Tools\SchemaTool->updateSchema()
.../Setup/Controller.php(1830): Setup_SchemaTool::updateAllSchema()
.../Setup/Frontend/Json.php(93): Setup_Controller->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(231): Setup_Frontend_Json->installApplications()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(603): Zend_Server_Abstract->_dispatch()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(206): Zend_Json_Server->_handle()
.../Setup/Server/Json.php(90): Zend_Json_Server->handle()
.../Setup/Core.php(117): Setup_Server_Json->handle()
.../setup.php(14): Setup_Core::dispatchRequest()

Kann mir da jemand weiterhelfen? Danke,

JPRuehmann commented 5 months ago

Habe es händisch bis auf folgenden SQL Befehl zurückgeführt

ALTER TABLE tine20_humanresources_freetimetype 
CHANGE wage_type wage_type VARCHAR(255) DEFAULT NULL;

1832 - Cannot change column 'wage_type': used in a foreign key constraint 'FK_F5F985AB6F7B263A'

Deaktivieren der foreign key überprüfung ändert nichts.

und

ALTER TABLE tine20_humanresources_freetimetype
CHANGE is_deleted is_deleted TINYINT(1) DEFAULT '0' NOT NULL;

Zeigt zwar keinen Fehler beim Ausführen, wird aber weiter als Fehler beim installieren der Komponente angezeigt.

JPRuehmann commented 5 months ago

Habe den Constraint gelöscht, jetzt läuft das Install der Komponenten Fehlerfrei durch. Der Eintrag in der Application Tabelle wird aber nicht erstellt. Somit werden die Komponenten weiterhin als nicht installiert angezeigt. Wie kriege ich die Einträge?

JPRuehmann commented 5 months ago

Problem gefunden.

Tine20.log

Skipping installation of application UserManual because it is not allowed by license.

Danke, das ihr den Nutzer Dumm sterben lasst! Eine Empfehlung kriegt ihr so bestimmt nicht. Ich weiss ja nichteinmal was diese Komponenten tun sollen.