GroupOffice upgrade 6.3 -> 6.4 mysql syntax error
When running the upgrade script (simply open https://fairkom.net/groupoffice) then we get an alter table problem.
@indigoxela @armin.felder what means ADD
col_4 mediumtext(16777216) NULL,
??
We are running mysql Ver 14.14 Distrib 5.7.27 on Ubuntu. MariaDB is no option here (not available for i686) unless we offload the DB to heu13.
GroupOffice 6.3 backup is in root home: groupofficecom6.3.sql
Upgrading Group-Office
Skipping module blacklist because it's not available.
Skipping module dokuwiki because it's not available.
Skipping module ispconfig3 because it's not available.
[core/core] Excuting query: ALTER TABLE `core_search` CHANGE `description` `description` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL;
core/core updated from 115 to 116
[community/addressbook] Running callable function
Migrating custom fields
ALTER TABLE addressbook_contact_custom_fields ADD `col_1` double NULL,
ADD `col_2` date NULL,
ADD `col_3` double NULL,
ADD `col_4` mediumtext(16777216) NULL,
ADD `col_5` double NULL,
ADD `col_6` tinyint(1) NOT NULL DEFAULT FALSE,
ADD `col_11` varchar(50) NOT NULL DEFAULT '',
ADD `col_23` varchar(50) NOT NULL DEFAULT '',
ADD `col_24` varchar(50) NOT NULL DEFAULT '',
ADD `col_25` varchar(50) NOT NULL DEFAULT '',
ADD `col_26` varchar(50) NOT NULL DEFAULT '',
ADD `col_27` varchar(50) NOT NULL DEFAULT '';
Error: PDOException in /usr/share/groupoffice/go/core/db/Connection.php at line 127: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(16777216) NULL,
ADD `col_5` double NULL,
ADD `col_6` tinyint(1) NOT NULL DEFAUL' at line 4
#0 /usr/share/groupoffice/go/core/db/Connection.php(127): PDO->query('ALTER TABLE add...')
#1 /usr/share/groupoffice/go/modules/community/addressbook/install/Migrate63to64.php(141): go\core\db\Connection->query('ALTER TABLE add...')
#2 /usr/share/groupoffice/go/modules/community/addressbook/install/Migrate63to64.php(107): go\modules\community\addressbook\install\Migrate63to64->mergeCompanyCustomFields()
#3 /usr/share/groupoffice/go/modules/community/addressbook/install/Migrate63to64.php(42): go\modules\community\addressbook\install\Migrate63to64->migrateCustomFields()
#4 /usr/share/groupoffice/go/modules/community/addressbook/install/updates.php(11): go\modules\community\addressbook\install\Migrate63to64->run()
#5 [internal function]: go\core\Installer->{closure}()
#6 /usr/share/groupoffice/go/core/Installer.php(480): call_user_func(Object(Closure))
#7 /usr/share/groupoffice/go/core/Installer.php(314): go\core\Installer->upgradeModules()
#8 /usr/share/groupoffice/install/upgrade.php(45): go\core\Installer->upgrade()
#9 {main}
Issue also reported to maintainer https://github.com/Intermesh/groupoffice/issues/446#issuecomment-524530498