tine-groupware / tine

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

Problems Update sales via setup.php #47

Closed JPRuehmann closed 6 months ago

JPRuehmann commented 7 months ago

:Habe gerade versucht von [weekly-2024.16.1] auf [weekly-2024.18.1] Upzudaten :Habe gerade versucht von [weekly-2024.16.1] auf [weekly-2024.17.1] Upzudaten :Habe gerade versucht von [weekly-2024.15.1] auf [weekly-2024.16.1] Upzudaten

Jedesmal wen ich versuche die Apps via `setup.php' zu aktualisieren erhalte ich folgenden Fehler.

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'd034b4d5.tine20_sales_divisions' doesn't exist, query was: ALTER TABLE `tine20_sales_divisions` RENAME TO `tine20_humanresources_division`

.../vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
.../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
.../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query()
.../Setup/Backend/Abstract.php(207): Zend_Db_Adapter_Pdo_Abstract->query()
.../Setup/Backend/Abstract.php(329): Setup_Backend_Abstract->execQueryVoid()
.../Sales/Setup/Update/15.php(200): Setup_Backend_Abstract->renameTable()
.../Setup/Controller.php(686): Sales_Setup_Update_15->update003()
.../Setup/Frontend/Json.php(118): Setup_Controller->updateApplications()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(231): Setup_Frontend_Json->updateApplications()
.../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()

Wenn ich in der Datenbank nachschaue gibt es zwar eine 'tine20_sales_division' aber keine 'tine20_sales_divisions' wenn ich den SQL Befehl ALTER TABLE `tine20_sales_division` RENAME TO `tine20_humanresources_division` ausführe wird dieser Fehlerfrei ausgeführt.

Wenn ich zuerst ALTER TABLE `tine20_sales_division` RENAME TO ALTER TABLE `tine20_sales_divisions` ausführe funktioniert das Update für das Addressbok aber wenn ich sales versuche upzudaten erhalte ich folgenden Fehler.

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'c99bbe38049b67338fdaf5cedc2d1cb7c2e7399e-Tinebase_Model_Evalu...' for key 'application_id-name', query was: INSERT INTO `tine20_customfield_config` (`name`, `application_id`, `model`, `is_system`, `definition`, `id`) VALUES (?, ?, ?, 1, ?, ?)

.../vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute()
.../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute()
.../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query()
.../vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(577): Zend_Db_Adapter_Pdo_Abstract->query()
.../Tinebase/Backend/Sql/Abstract.php(1048): Zend_Db_Adapter_Abstract->insert()
.../Tinebase/CustomField.php(121): Tinebase_Backend_Sql_Abstract->create()
.../Sales/Setup/Initialize.php(144): Tinebase_CustomField->addCustomField()
.../Sales/Setup/Update/17.php(265): Sales_Setup_Initialize::createTbSystemCFEvaluationDimension()
.../Setup/Controller.php(686): Sales_Setup_Update_17->update005()
.../Setup/Frontend/Json.php(118): Setup_Controller->updateApplications()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(231): Setup_Frontend_Json->updateApplications()
.../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()

Screenshot 2024-04-28 at 12-19-05 v154361 kasserver com _ localhost _ d034b4d5 _ tine20_customfield_config phpMyAdmin 5 2 1

Wenn ich versuche '''INSERT INTO tine20_customfield_config (name, application_id, model, is_system, definition, id) VALUES (?, ?, ?, 1, ?, ?)''' direkt auszuführen sagt mir mysqladmin nur Variablenname erwartet bei"?".

Was muss ich da eintragen? Welchen Eintrag muß ich löschen?

Wie bringe ich die Updates sauber zum laufen??

after deleting both entrys it works.