Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Problem tine20 zu aktualisieren / v2019.12.3 #7123

Open
jaybenn opened this issue Dec 23, 2019 · 8 comments
Open

Problem tine20 zu aktualisieren / v2019.12.3 #7123

jaybenn opened this issue Dec 23, 2019 · 8 comments
Labels

Comments

@jaybenn
Copy link

@jaybenn jaybenn commented Dec 23, 2019

Moin,

wie bereits an andere Stelle moniert: 1 von 3 tine updates funktionieren nicht ohne Störung. Mein aktuelles Problem: Nach kompletter Neuinstallation der aktuellen tine20version (s.o) mit kopierter Datenbank der arbeitenden tine20version bekomme ich im Setup beim Versuch, die einzelnen Awendungen (tinebase, Calendar usw.) zu aktualisieren, die Meldung: "Setup Admin undefined".
Das kommt regelmäßig vor und erledigt sich meistens mit dem folgenden Update. Es nervt trotzdem. Was ist so schwierig daran, eine komplett neu installiertes System lauffähig zu veröffentlichen?
Nächstes Problem: Der Versuch, auf einen anderen Kalender zu wechseln (z.B. Nextcloud) wird dadurch sabotiert, daß die Community-Version über kein ernstzunehmendes (geschweige denn praktikables) Exportformat verfügt. Das grenzt nun wirklich schon fast an bösem Willen …

Ich nutze tine20 schon seit vielen Jahren, aber so langsam verliere ich wirklich das Verständnis für diese Unsäglichkeiten. Wenn Ihr wirklich nur die Bezahl-Version ordentliche bedienen könnt/wollt, dann zieht die doch bitte die entsprechende Konsequenz.

Trotzdem: Frohe Weihnachten und eine guten Start ins Neue!

@jaybenn jaybenn changed the title Problem tine20 zu aktualisieren 7 v2019.12.3 Problem tine20 zu aktualisieren / v2019.12.3 Dec 23, 2019
@gerryfrancis

This comment has been minimized.

Copy link

@gerryfrancis gerryfrancis commented Dec 23, 2019

Ich glaube, das hängt sehr von der Art und Weise ab, wie man Tine "aktualisiert", denn so wie Du das machst, macht man es in der Regel nicht. Eine Neuinstallation und das nachträgliche Zuweisen der Datenbank verhindert z. B., dass deren Inhalte (Tabellen, Datensätze, Scripts, etc.) an die neue Tine-Version angepasst werden, was der Setup-User mit der Aktualisierung der Module u. a. erledigt.

Kann es sein, dass Du gelegentlich "vergisst", die Datei "config.inc.php" aus dem bisherigen Tine-Arbeitsverzeichnis zu übernehmen? Wenn ja, weiß Tine natürlich nicht, dass Du bereits einen Setup-User hast.

Mehr Infos über wie Du Tine aktualisierst, findest Du hier: https://github.com/tine20/tine20/wiki/EN:Update-Howto

Viel Erfolg, frohe Weihnachten und einen guten Rutsch ins Neue Jahr!

@pavaroo

This comment has been minimized.

Copy link

@pavaroo pavaroo commented Dec 25, 2019

Ich habe eben eine bestehende Installation updaten wollen und bekomme beim aktualisieren der Anwendungen den Fehler "Setup Admin undefined"

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'addressbook_lists.xprops' in 'field list', query was: SELECT groups.*, addressbook_lists.container_id, addressbook_lists.xpropsFROMtine20_groupsASgroupsLEFT JOINtine20_addressbook_listsASaddressbook_listsONgroups.list_id=addressbook_lists.id WHERE (groups.name` = 'Administrators')

.../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()
.../Tinebase/Group/Sql.php(780): Zend_Db_Adapter_Pdo_Abstract->query()
.../Tinebase/Group/Sql.php(755): Tinebase_Group_Sql->getGroupByPropertyFromSqlBackend()
.../Tinebase/Group/Abstract.php(223): Tinebase_Group_Sql->getGroupByName()
.../Tinebase/Group/Abstract.php(149): Tinebase_Group_Abstract->_getDefaultGroup()
.../Tinebase/User/Abstract.php(670): Tinebase_Group_Abstract->getDefaultAdminGroup()
.../Setup/Update/Abstract.php(534): Tinebase_User_Abstract->assertAdminGroupMembership()
.../Setup/Update/Abstract.php(492): Setup_Update_Abstract::assertAdminGroupMembership()
.../Setup/Controller.php(497): Setup_Update_Abstract::getSetupFromConfigOrCreateOnTheFly()
.../Setup/Frontend/Json.php(118): Setup_Controller->updateApplications()
.../vendor/zendframework/zendframework1/library/Zend/Server/Abstract.php(232): Setup_Frontend_Json->updateApplications()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(590): Zend_Server_Abstract->_dispatch()
.../vendor/zendframework/zendframework1/library/Zend/Json/Server.php(197): 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()`

Bei einer Neuinstallation komme ich auch nicht weiter - hierfür habe ich einen gesonderten Thread erstellt.

@gerryfrancis

This comment has been minimized.

Copy link

@gerryfrancis gerryfrancis commented Dec 26, 2019

Hast Du die neuen Dateien in das bereits bestehende Tine-Verzeichnis kopiert und dabei die alten überschrieben? Wenn ja, wird Deine Installation nicht rund laufen und Du züchtest Dir weitere, für die Entwickler schwer vorhersehbare Probleme.

Falls Du wie in der Update-Anleitung beschrieben vorgegangen bist, hast Du womöglich vergessen, die Konfigurationsdatei "config.inc.php" aus dem alten Tine-Verzeichnis zu übernehmen.

@pavaroo

This comment has been minimized.

Copy link

@pavaroo pavaroo commented Dec 26, 2019

ich habe das Update mittlerweile verworfen, weil dort eh kaum Daten vorhanden waren und konzentriere mich lieber auf die Neuinstallation, die aber auch nicht funktioniert (siehe extra Thread)

@ftrojahn

This comment has been minimized.

Copy link

@ftrojahn ftrojahn commented Dec 31, 2019

Bekomme ziemlich denselben Fehler, kann meine alte Installation aber nicht verwerfen.
Gibt es irgendeine Lösung für das Problem?

:~/public_html$ php setup.php --update
PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'addressbook_lists.xprops' in 'field list' in /home/tine20/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Statement/Pdo.php:228
Stack trace:
#0 /home/tine20/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Statement/Pdo.php(228): PDOStatement->execute(Array)
#1 /home/tine20/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#2 /home/tine20/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#3 /home/tine20/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `groups`...', Array)
#4 /home/tine20/public_html/Tinebase/Group/Sql.php(780): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))
#5 /home/tine20/public_html/Tinebase/Group/Sql.php(755): Tinebase_Group_Sql->getGroupByPropertyFromSqlBackend('name', 'Administrators')
#6 /home/tine20/public_html/Tinebase/Group/Abstract.php(223): Tinebase_Group_Sql->getGroupByName('Administrators')
#7 /home/tine20/public_html/Tinebase/Group/Abstract.php(149): Tinebase_Group_Abstract->_getDefaultGroup('Administrators')
#8 /home/tine20/public_html/Tinebase/User/Abstract.php(670): Tinebase_Group_Abstract->getDefaultAdminGroup()
#9 /home/tine20/public_html/Setup/Update/Abstract.php(534): Tinebase_User_Abstract->assertAdminGroupMembership(Object(Tinebase_Model_FullUser))
#10 /home/tine20/public_html/Setup/Update/Abstract.php(492): Setup_Update_Abstract::assertAdminGroupMembership(Object(Tinebase_Model_FullUser))
#11 /home/tine20/public_html/Setup/Controller.php(497): Setup_Update_Abstract::getSetupFromConfigOrCreateOnTheFly()
#12 /home/tine20/public_html/Setup/Frontend/Cli.php(451): Setup_Controller->updateApplications()
#13 /home/tine20/public_html/Setup/Frontend/Cli.php(81): Setup_Frontend_Cli->_update(Object(Zend_Console_Getopt))
#14 /home/tine20/public_html/Setup/Server/Cli.php(141): Setup_Frontend_Cli->handle(Object(Zend_Console_Getopt))
#15 /home/tine20/public_html/Setup/Core.php(117): Setup_Server_Cli->handle()
#16 /home/tine20/public_html/setup.php(14): Setup_Core::dispatchRequest()
#17 {main}

Next Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'addressbook_lists.xprops' in 'field list', query was: SELECT `groups`.*, `addressbook_lists`.`container_id`, `addressbook_lists`.`xprops` FROM `tine20_groups` AS `groups`
 LEFT JOIN `tine20_addressbook_lists` AS `addressbook_lists` ON `groups`.`list_id` = `addressbook_lists`.`id` WHERE (`groups`.`name` = 'Administrators') in /home/tine20/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Statement/Pdo.php:235
Stack trace:
#0 /home/tine20/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Statement.php(303): Zend_Db_Statement_Pdo->_execute(Array)
#1 /home/tine20/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Abstract.php(480): Zend_Db_Statement->execute(Array)
#2 /home/tine20/public_html/vendor/zendframework/zendframework1/library/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT `groups`...', Array)
#3 /home/tine20/public_html/Tinebase/Group/Sql.php(780): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))
#4 /home/tine20/public_html/Tinebase/Group/Sql.php(755): Tinebase_Group_Sql->getGroupByPropertyFromSqlBackend('name', 'Administrators')
#5 /home/tine20/public_html/Tinebase/Group/Abstract.php(223): Tinebase_Group_Sql->getGroupByName('Administrators')
#6 /home/tine20/public_html/Tinebase/Group/Abstract.php(149): Tinebase_Group_Abstract->_getDefaultGroup('Administrators')
#7 /home/tine20/public_html/Tinebase/User/Abstract.php(670): Tinebase_Group_Abstract->getDefaultAdminGroup()
#8 /home/tine20/public_html/Setup/Update/Abstract.php(534): Tinebase_User_Abstract->assertAdminGroupMembership(Object(Tinebase_Model_FullUser))
#9 /home/tine20/public_html/Setup/Update/Abstract.php(492): Setup_Update_Abstract::assertAdminGroupMembership(Object(Tinebase_Model_FullUser))
#10 /home/tine20/public_html/Setup/Controller.php(497): Setup_Update_Abstract::getSetupFromConfigOrCreateOnTheFly()
#11 /home/tine20/public_html/Setup/Frontend/Cli.php(451): Setup_Controller->updateApplications()
#12 /home/tine20/public_html/Setup/Frontend/Cli.php(81): Setup_Frontend_Cli->_update(Object(Zend_Console_Getopt))
#13 /home/tine20/public_html/Setup/Server/Cli.php(141): Setup_Frontend_Cli->handle(Object(Zend_Console_Getopt))
#14 /home/tine20/public_html/Setup/Core.php(117): Setup_Server_Cli->handle()
#15 /home/tine20/public_html/setup.php(14): Setup_Core::dispatchRequest()
#16 {main}

Bin nach Update-Anleitung vorgegangen, config.inc.php ist vorhanden, keine anderen Dateien außer filestore/.

@pschuele

This comment has been minimized.

Copy link
Member

@pschuele pschuele commented Jan 16, 2020

wichtig ist immer, dass keine major-version zwischendrin ausgelassen wird:

2017.08 -> 2018.02 Community Edition

2018.02 -> 2018.08 Community Edition

2018.08 -> 2019.02 Community Edition

2019.02 -> 2019.08 Community Edition

2019.08 -> 2019.12 Community Edition

hier auch darauf achten, dass die letzte minor genommen wird. die tarballs findet ihr hier: https://packages.tine20.org/source/

bitte bescheid sagen, falls das update trotz eingespielter jeweils letzter major version nicht klappt.

@pschuele pschuele added the Update label Jan 16, 2020
@gerryvel

This comment has been minimized.

Copy link

@gerryvel gerryvel commented Jan 17, 2020

Das müsste mal an zentrale Stelle >unter Update.

@ftrojahn

This comment has been minimized.

Copy link

@ftrojahn ftrojahn commented Jan 18, 2020

ok, some remarks about the consecutive updates:

  • 2017.08 -> 2017.08.11:

    • using php 7.x throws error, php 5.6 works using /opt/php-5.6/bin/php setup.php --update
    • gui login possible after switching to php 5.6
  • 2017.08.11 -> 2018.02.7

    • using php 5.6 -> update works using /opt/php-5.6/bin/php setup.php --update
  • 2018.02.7 -> 2018.08.9

  • php 5.6 throws error

  • using php 7.0 -> update fails using /opt/php-7.0/bin/php setup.php --update
    with:

Spoiler: throws errors
/opt/php-7.0/bin/php setup.php --update
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 byt
es is stored inline. in /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
Stack trace:
#0 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('ALTER TABLE `ti...')
#1 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('ALTER TABLE `ti...')
#2 /home/tine20/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(843): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `ti...')
#3 /home/tine20/public_html/Setup/SchemaTool.php(159): Doctrine\ORM\Tools\SchemaTool->updateSchema(Array, true)
#4 /home/tine20/public_html/Setup/Controller.php(616): Setup_SchemaTool::updateAllSchema()
#5 /home/tine20/public_html/Setup/Controller.php(458): Setup_Controller->_legacyUpdateApplications(Object(Tinebase_Record_RecordSetFast))                                                     
#6 /home/tine20/public_html/Setup/Frontend/Cli.php(459): Setup_Controller->updateApplications()                                                                                               
#7 /home/tine20/public_html/Setup/Frontend/Cli.php(443): Setup_Frontend_Cli->_updateApplications()                                                                                            
#8 /home/tine20/public_html/Setup/Frontend/Cli.php(73): Setup_Frontend_Cli->_update(Object(Zend_Console_Getopt))                                                                              
#9 /home/tine20/public_html/Setup/Server/Cli.php(141): Setup_Frontend_Cli->handle(Object(Zend_Console_Getopt))                                                                                
#10 /home/tine20/public_html/Setup/Core.php(115): Setup_Server_Cli->handle()                                                                                                                  
#11 /home/tine20/public_html/setup.php(14): Setup_Core::dispatchRequest()                                                                                                                     
#12 {main}                                                                                                                                                                                    
                                                                                                                                                                                              
Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row fo
rmat, BLOB prefix of 0 bytes is stored inline. in /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106                                                
Stack trace:
#0 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('ALTER TABLE `ti...')
#1 /home/tine20/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(843): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `ti...')
#2 /home/tine20/public_html/Setup/SchemaTool.php(159): Doctrine\ORM\Tools\SchemaTool->updateSchema(Array, true)
#3 /home/tine20/public_html/Setup/Controller.php(616): Setup_SchemaTool::updateAllSchema()
#4 /home/tine20/public_html/Setup/Controller.php(458): Setup_Controller->_legacyUpdateApplications(Object(Tinebase_Record_RecordSetFast))
#5 /home/tine20/public_html/Setup/Frontend/Cli.php(459): Setup_Controller->updateApplications()
#6 /home/tine20/public_html/Setup/Frontend/Cli.php(443): Setup_Frontend_Cli->_updateApplications()
#7 /home/tine20/public_html/Setup/Frontend/Cli.php(73): Setup_Frontend_Cli->_update(Object(Zend_Console_Getopt))
#8 /home/tine20/public_html/Setup/Server/Cli.php(141): Setup_Frontend_Cli->handle(Object(Zend_Console_Getopt))
#9 /home/tine20/public_html/Setup/Core.php(115): Setup_Server_Cli->handle()
#10 /home/tine20/public_html/setup.php(14): Setup_Core::dispatchRequest()
#11 {main}

Next Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE `tine20_addressbook` ADD `n_short` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_countryname` `ad
r_one_countryname` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_locality` `adr_one_locality` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_postalcode` `adr_one_postalcode` VARCHAR(64) DEFAULT NULL,
 CHANGE `adr_one_region` `adr_one_region` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_street` `adr_one_street` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_street2` `adr_one_street2` VARCHAR(64)
DEFAULT NULL, CHANGE `adr_two_countryname` `adr_two_countryname` VARCHAR(64) DEFAULT NULL, CHANGE `adr_two_locality` `adr_two_locality` VARCHAR(64) DEFAULT NULL, CHANGE `adr_two_postalcode`
`adr_two_postalcode` VARCHAR(64) DEFAULT NULL, CHANGE `adr_two_region` `adr_two_region` VARCHAR(64) DEFAULT NULL, CHANGE `adr_two_street` `adr_two_street` VARCHAR(64) DEFAULT NULL, CHANGE `a
dr_two_street2` `adr_two_street2` VARCHAR(64) DEFAULT NULL, CHANGE `cat_id` `cat_id` VARCHAR(255) DEFAULT NULL, CHANGE `assistent` `assistent` VARCHAR(64) DEFAULT NULL, CHANGE `bday` `bday`
DATETIME DEFAULT NULL, CHANGE `calendar_uri` `calendar_uri` VARCHAR(128) DEFAULT NULL, CHANGE `email` `email` VARCHAR(255) DEFAULT NULL, CHANGE `email_home` `email_home` VARCHAR(255) DEFAULT
 NULL, CHANGE `freebusy_uri` `freebusy_uri` VARCHAR(128) DEFAULT NULL, CHANGE `geo` `geo` VARCHAR(32) DEFAULT NULL, CHANGE `container_id` `container_id` VARCHAR(40) DEFAULT NULL, CHANGE `pri
vate` `private` TINYINT(1) DEFAULT '0', CHANGE `role` `role` VARCHAR(64) DEFAULT NULL, CHANGE `room` `room` VARCHAR(64) DEFAULT NULL, CHANGE `tid` `tid` VARCHAR(1) DEFAULT 'n', CHANGE `salut
ation` `salutation` VARCHAR(40) DEFAULT NULL, CHANGE `title` `title` VARCHAR(64) DEFAULT NULL, CHANGE `tz` `tz` VARCHAR(8) DEFAULT NULL, CHANGE `url` `url` VARCHAR(128) DEFAULT NULL, CHANGE
`url_home` `url_home` VARCHAR(128) DEFAULT NULL, CHANGE `n_family` `n_family` VARCHAR(255) DEFAULT NULL, CHANGE `n_fileas` `n_fileas` VARCHAR(255) DEFAULT NULL, CHANGE `n_fn` `n_fn` VARCHAR(
255) DEFAULT NULL, CHANGE `n_given` `n_given` VARCHAR(64) DEFAULT NULL, CHANGE `n_middle` `n_middle` VARCHAR(64) DEFAULT NULL, CHANGE `n_prefix` `n_prefix` VARCHAR(64) DEFAULT NULL, CHANGE `
n_suffix` `n_suffix` VARCHAR(64) DEFAULT NULL, CHANGE `org_name` `org_name` VARCHAR(255) DEFAULT NULL, CHANGE `org_unit` `org_unit` VARCHAR(64) DEFAULT NULL, CHANGE `tel_assistent` `tel_assi
stent` VARCHAR(40) DEFAULT NULL, CHANGE `tel_car` `tel_car` VARCHAR(40) DEFAULT NULL, CHANGE `tel_cell` `tel_cell` VARCHAR(40) DEFAULT NULL, CHANGE `tel_cell_private` `tel_cell_private` VARC
HAR(40) DEFAULT NULL, CHANGE `tel_fax` `tel_fax` VARCHAR(40) DEFAULT NULL, CHANGE `tel_fax_home` `tel_fax_home` VARCHAR(40) DEFAULT NULL, CHANGE `tel_home` `tel_home` VARCHAR(40) DEFAULT NUL
L, CHANGE `tel_other` `tel_other` VARCHAR(40) DEFAULT NULL, CHANGE `tel_pager` `tel_pager` VARCHAR(40) DEFAULT NULL, CHANGE `tel_prefer` `tel_prefer` VARCHAR(40) DEFAULT NULL, CHANGE `tel_work` `tel_work` VARCHAR(40) DEFAULT NULL, CHANGE `created_by` `created_by` VARCHAR(40) DEFAULT NULL, CHANGE `creation_time` `creation_time` DATETIME DEFAULT NULL, CHANGE `last_modified_by` `l
ast_modified_by` VARCHAR(40) DEFAULT NULL, CHANGE `last_modified_time` `last_modified_time` DATETIME DEFAULT NULL, CHANGE `is_deleted` `is_deleted` TINYINT(1) DEFAULT '0' NOT NULL, CHANGE `d
eleted_by` `deleted_by` VARCHAR(40) DEFAULT NULL, CHANGE `deleted_time` `deleted_time` DATETIME DEFAULT NULL, CHANGE `adr_one_lon` `adr_one_lon` DOUBLE PRECISION DEFAULT NULL, CHANGE `adr_on
e_lat` `adr_one_lat` DOUBLE PRECISION DEFAULT NULL, CHANGE `type` `type` VARCHAR(128) DEFAULT 'contact' NOT NULL, CHANGE `adr_two_lon` `adr_two_lon` DOUBLE PRECISION DEFAULT NULL, CHANGE `ad
r_two_lat` `adr_two_lat` DOUBLE PRECISION DEFAULT NULL, CHANGE `tel_assistent_normalized` `tel_assistent_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_car_normalized` `tel_car_normalized
` VARCHAR(40) DEFAULT NULL, CHANGE `tel_cell_normalized` `tel_cell_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_cell_private_normalized` `tel_cell_private_normalized` VARCHAR(40) DEFAUL
T NULL, CHANGE `tel_fax_normalized` `tel_fax_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_fax_home_normalized` `tel_fax_home_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_home_norma
lized` `tel_home_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_other_normalized` `tel_other_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_pager_normalized` `tel_pager_normalized` VAR
CHAR(40) DEFAULT NULL, CHANGE `tel_prefer_normalized` `tel_prefer_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_work_normalized` `tel_work_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `i
ndustry` `industry` VARCHAR(40) DEFAULT NULL, CHANGE `preferred_address` `preferred_address` INT DEFAULT NULL':

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored i
nline. in /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
Stack trace:
#0 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DB
AL\Driver\PDOException))
#1 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver),
Object(Doctrine\DBAL\Driver\PDOException), 'ALTER TABLE `ti...', Array)
#2 /home/tine20/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(843): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `ti...')
#3 /home/tine20/public_html/Setup/SchemaTool.php(159): Doctrine\ORM\Tools\SchemaTool->updateSchema(Array, true)
#4 /home/tine20/public_html/Setup/Controller.php(616): Setup_SchemaTool::updateAllSchema()
#5 /home/tine20/public_html/Setup/Controller.php(458): Setup_Controller->_legacyUpdateApplications(Object(Tinebase_Record_RecordSetFast))
#6 /home/tine20/public_html/Setup/Frontend/Cli.php(459): Setup_Controller->updateApplications()
#7 /home/tine20/public_html/Setup/Frontend/Cli.php(443): Setup_Frontend_Cli->_updateApplications()
#8 /home/tine20/public_html/Setup/Frontend/Cli.php(73): Setup_Frontend_Cli->_update(Object(Zend_Console_Getopt))
#9 /home/tine20/public_html/Setup/Server/Cli.php(141): Setup_Frontend_Cli->handle(Object(Zend_Console_Getopt))
#10 /home/tine20/public_html/Setup/Core.php(115): Setup_Server_Cli->handle()
#11 /home/tine20/public_html/setup.php(14): Setup_Core::dispatchRequest()
#12 {main}

  • revert to 2017.08.11, update -> 2018.02.1, -> 2018.02.7, -> 2018.08.1
    => ok with php 5.6 up to this release

  • 2018.08.9 -> switch to php 7.0, as setup gui throws error with php 5.6, spinning wheel with php 7.0
    cmd line update /opt/php-7.0/bin/php setup.php --update'' throws:

Spoiler: errors
PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 byt
es is stored inline. in /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104
Stack trace:
#0 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query('ALTER TABLE `ti...')
#1 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('ALTER TABLE `ti...')
#2 /home/tine20/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(843): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `ti...')
#3 /home/tine20/public_html/Setup/SchemaTool.php(159): Doctrine\ORM\Tools\SchemaTool->updateSchema(Array, true)
#4 /home/tine20/public_html/Setup/Controller.php(616): Setup_SchemaTool::updateAllSchema()
#5 /home/tine20/public_html/Setup/Controller.php(458): Setup_Controller->_legacyUpdateApplications(Object(Tinebase_Record_RecordSetFast))
#6 /home/tine20/public_html/Setup/Frontend/Cli.php(459): Setup_Controller->updateApplications()
#7 /home/tine20/public_html/Setup/Frontend/Cli.php(443): Setup_Frontend_Cli->_updateApplications()
#8 /home/tine20/public_html/Setup/Frontend/Cli.php(73): Setup_Frontend_Cli->_update(Object(Zend_Console_Getopt))
#9 /home/tine20/public_html/Setup/Server/Cli.php(141): Setup_Frontend_Cli->handle(Object(Zend_Console_Getopt))
#10 /home/tine20/public_html/Setup/Core.php(115): Setup_Server_Cli->handle()
#11 /home/tine20/public_html/setup.php(14): Setup_Core::dispatchRequest()
#12 {main}

Next Doctrine\DBAL\Driver\PDOException: SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row fo
rmat, BLOB prefix of 0 bytes is stored inline. in /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:106
Stack trace:
#0 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query('ALTER TABLE `ti...')
#1 /home/tine20/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(843): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `ti...')
#2 /home/tine20/public_html/Setup/SchemaTool.php(159): Doctrine\ORM\Tools\SchemaTool->updateSchema(Array, true)
#3 /home/tine20/public_html/Setup/Controller.php(616): Setup_SchemaTool::updateAllSchema()
#4 /home/tine20/public_html/Setup/Controller.php(458): Setup_Controller->_legacyUpdateApplications(Object(Tinebase_Record_RecordSetFast))
#5 /home/tine20/public_html/Setup/Frontend/Cli.php(459): Setup_Controller->updateApplications()
#6 /home/tine20/public_html/Setup/Frontend/Cli.php(443): Setup_Frontend_Cli->_updateApplications()
#7 /home/tine20/public_html/Setup/Frontend/Cli.php(73): Setup_Frontend_Cli->_update(Object(Zend_Console_Getopt))
#8 /home/tine20/public_html/Setup/Server/Cli.php(141): Setup_Frontend_Cli->handle(Object(Zend_Console_Getopt))
#9 /home/tine20/public_html/Setup/Core.php(115): Setup_Server_Cli->handle()
#10 /home/tine20/public_html/setup.php(14): Setup_Core::dispatchRequest()
#11 {main}
ext Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE `tine20_addressbook` ADD `n_short` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_countryname` `adr_one_countryname` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_locality` `adr_one_locality` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_postalcode` `adr_one_postalcode` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_region` `adr_one_region` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_street` `adr_one_street` VARCHAR(64) DEFAULT NULL, CHANGE `adr_one_street2` `adr_one_street2` VARCHAR(64)
DEFAULT NULL, CHANGE `adr_two_countryname` `adr_two_countryname` VARCHAR(64) DEFAULT NULL, CHANGE `adr_two_locality` `adr_two_locality` VARCHAR(64) DEFAULT NULL, CHANGE `adr_two_postalcode`
`adr_two_postalcode` VARCHAR(64) DEFAULT NULL, CHANGE `adr_two_region` `adr_two_region` VARCHAR(64) DEFAULT NULL, CHANGE `adr_two_street` `adr_two_street` VARCHAR(64) DEFAULT NULL, CHANGE `adr_two_street2` `adr_two_street2` VARCHAR(64) DEFAULT NULL, CHANGE `cat_id` `cat_id` VARCHAR(255) DEFAULT NULL, CHANGE `assistent` `assistent` VARCHAR(64) DEFAULT NULL, CHANGE `bday` `bday`
DATETIME DEFAULT NULL, CHANGE `calendar_uri` `calendar_uri` VARCHAR(128) DEFAULT NULL, CHANGE `email` `email` VARCHAR(255) DEFAULT NULL, CHANGE `email_home` `email_home` VARCHAR(255) DEFAULT NULL, CHANGE `freebusy_uri` `freebusy_uri` VARCHAR(128) DEFAULT NULL, CHANGE `geo` `geo` VARCHAR(32) DEFAULT NULL, CHANGE `container_id` `container_id` VARCHAR(40) DEFAULT NULL, CHANGE `private` `private` TINYINT(1) DEFAULT '0', CHANGE `role` `role` VARCHAR(64) DEFAULT NULL, CHANGE `room` `room` VARCHAR(64) DEFAULT NULL, CHANGE `tid` `tid` VARCHAR(1) DEFAULT 'n', CHANGE `salutation` `salutation` VARCHAR(40) DEFAULT NULL, CHANGE `title` `title` VARCHAR(64) DEFAULT NULL, CHANGE `tz` `tz` VARCHAR(8) DEFAULT NULL, CHANGE `url` `url` VARCHAR(128) DEFAULT NULL, CHANGE
`url_home` `url_home` VARCHAR(128) DEFAULT NULL, CHANGE `n_family` `n_family` VARCHAR(255) DEFAULT NULL, CHANGE `n_fileas` `n_fileas` VARCHAR(255) DEFAULT NULL, CHANGE `n_fn` `n_fn` VARCHAR(255) DEFAULT NULL, CHANGE `n_given` `n_given` VARCHAR(64) DEFAULT NULL, CHANGE `n_middle` `n_middle` VARCHAR(64) DEFAULT NULL, CHANGE `n_prefix` `n_prefix` VARCHAR(64) DEFAULT NULL, CHANGE `n_suffix` `n_suffix` VARCHAR(64) DEFAULT NULL, CHANGE `org_name` `org_name` VARCHAR(255) DEFAULT NULL, CHANGE `org_unit` `org_unit` VARCHAR(64) DEFAULT NULL, CHANGE `tel_assistent` `tel_assistent` VARCHAR(40) DEFAULT NULL, CHANGE `tel_car` `tel_car` VARCHAR(40) DEFAULT NULL, CHANGE `tel_cell` `tel_cell` VARCHAR(40) DEFAULT NULL, CHANGE `tel_cell_private` `tel_cell_private` VARCHAR(40) DEFAULT NULL, CHANGE `tel_fax` `tel_fax` VARCHAR(40) DEFAULT NULL, CHANGE `tel_fax_home` `tel_fax_home` VARCHAR(40) DEFAULT NULL, CHANGE `tel_home` `tel_home` VARCHAR(40) DEFAULT NULL, CHANGE `tel_other` `tel_other` VARCHAR(40) DEFAULT NULL, CHANGE `tel_pager` `tel_pager` VARCHAR(40) DEFAULT NULL, CHANGE `tel_prefer` `tel_prefer` VARCHAR(40) DEFAULT NULL, CHANGE `tel_work` `tel_work` VARCHAR(40) DEFAULT NULL, CHANGE `created_by` `created_by` VARCHAR(40) DEFAULT NULL, CHANGE `creation_time` `creation_time` DATETIME DEFAULT NULL, CHANGE `last_modified_by` `last_modified_by` VARCHAR(40) DEFAULT NULL, CHANGE `last_modified_time` `last_modified_time` DATETIME DEFAULT NULL, CHANGE `is_deleted` `is_deleted` TINYINT(1) DEFAULT '0' NOT NULL, CHANGE `deleted_by` `deleted_by` VARCHAR(40) DEFAULT NULL, CHANGE `deleted_time` `deleted_time` DATETIME DEFAULT NULL, CHANGE `adr_one_lon` `adr_one_lon` DOUBLE PRECISION DEFAULT NULL, CHANGE `adr_one_lat` `adr_one_lat` DOUBLE PRECISION DEFAULT NULL, CHANGE `type` `type` VARCHAR(128) DEFAULT 'contact' NOT NULL, CHANGE `adr_two_lon` `adr_two_lon` DOUBLE PRECISION DEFAULT NULL, CHANGE `adr_two_lat` `adr_two_lat` DOUBLE PRECISION DEFAULT NULL, CHANGE `tel_assistent_normalized` `tel_assistent_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_car_normalized` `tel_car_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_cell_normalized` `tel_cell_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_cell_private_normalized` `tel_cell_private_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_fax_normalized` `tel_fax_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_fax_home_normalized` `tel_fax_home_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_home_normalized` `tel_home_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_other_normalized` `tel_other_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_pager_normalized` `tel_pager_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_prefer_normalized` `tel_prefer_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `tel_work_normalized` `tel_work_normalized` VARCHAR(40) DEFAULT NULL, CHANGE `industry` `industry` VARCHAR(40) DEFAULT NULL, CHANGE `preferred_address` `preferred_address` INT DEFAULT NULL':

SQLSTATE[42000]: Syntax error or access violation: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. in /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115
Stack trace:
#0 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php(128): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDOException))
#1 /home/tine20/public_html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(855): Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Object(Doctrine\DBAL\Driver\PDOMySql\Driver),
Object(Doctrine\DBAL\Driver\PDOException), 'ALTER TABLE `ti...', Array)
#2 /home/tine20/public_html/vendor/doctrine/orm/lib/Doctrine/ORM/Tools/SchemaTool.php(843): Doctrine\DBAL\Connection->executeQuery('ALTER TABLE `ti...')
#3 /home/tine20/public_html/Setup/SchemaTool.php(159): Doctrine\ORM\Tools\SchemaTool->updateSchema(Array, true)
#4 /home/tine20/public_html/Setup/Controller.php(616): Setup_SchemaTool::updateAllSchema()
#5 /home/tine20/public_html/Setup/Controller.php(458): Setup_Controller->_legacyUpdateApplications(Object(Tinebase_Record_RecordSetFast))
#6 /home/tine20/public_html/Setup/Frontend/Cli.php(459): Setup_Controller->updateApplications()
#7 /home/tine20/public_html/Setup/Frontend/Cli.php(443): Setup_Frontend_Cli->_updateApplications()
#8 /home/tine20/public_html/Setup/Frontend/Cli.php(73): Setup_Frontend_Cli->_update(Object(Zend_Console_Getopt))
#9 /home/tine20/public_html/Setup/Server/Cli.php(141): Setup_Frontend_Cli->handle(Object(Zend_Console_Getopt))
#10 /home/tine20/public_html/Setup/Core.php(115): Setup_Server_Cli->handle()
#11 /home/tine20/public_html/setup.php(14): Setup_Core::dispatchRequest()
#12 {main}

Sorry, jetzt erst gesehn, dass das Ticket auf Deutsch ist ;)

Fragen:

  • gibt es Beschränkungen bzgl. spezifischer php Version je nach major Version?

  • kann das Problem etwas mit MySql / MariaDB Server zu tun haben? Verwende debian 10 Buster

mariadb-server-10.3:amd64/buster 1:10.3.18-0+deb10u1 uptodate
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
6 participants
You can’t perform that action at this time.