Hi,
I am trying to upgrade eGroupware from 20.1 to 21.1, but the upgrade/installation fails.
NOTE: I am using Postgresql as database.
The logging shows the following for “kanban”:
The following applications are NOT installed: kanban
Backup started, this might take a few minutes ...
Backup finished.
<p>db::get_last_insert_id(table='egw_kanban_column',field='column_id') not yet implemented for db-type 'pgsql' OR no insert operation before</p>
<p>EGroupware\Api\Db->get_last_insert_id:963 / include:60(/kanban/setup/default_records.inc.php) / setup_process->default_records:507 / setup_process->upgrade:628 / setup_process->pass:151 / setup_cmd_update->exec:118 / admin_cmd->run:239 / do_update:303(default,egroupwareheaderadmin,wUeMV=d4rgvRvB15,)</p>
<p>db::get_last_insert_id(table='egw_kanban_column',field='column_id') not yet implemented for db-type 'pgsql' OR no insert operation before</p>
<p>EGroupware\Api\Db->get_last_insert_id:963 / include:60(/kanban/setup/default_records.inc.php) / setup_process->default_records:507 / setup_process->upgrade:628 / setup_process->pass:151 / setup_cmd_update->exec:118 / admin_cmd->run:239 / do_update:303(default,egroupwareheaderadmin,wUeMV=d4rgvRvB15,)</p>
<p>db::get_last_insert_id(table='egw_kanban_column',field='column_id') not yet implemented for db-type 'pgsql' OR no insert operation before</p>
<p>EGroupware\Api\Db->get_last_insert_id:963 / include:60(/kanban/setup/default_records.inc.php) / setup_process->default_records:507 / setup_process->upgrade:628 / setup_process->pass:151 / setup_cmd_update->exec:118 / admin_cmd->run:239 / do_update:303(default,egroupwareheaderadmin,wUeMV=d4rgvRvB15,)</p>
<p>CreateTableSQL('egw_calls','call_id I AUTOINCREMENT NOTNULL PRIMARY,
It also fails with the “egw_calls” table:
<p>CreateTableSQL('egw_calls','call_id I AUTOINCREMENT NOTNULL PRIMARY,
call_uid C(64),
call_started T NOTNULL,
call_accepted T,
call_hangup T,
call_incoming L NOTNULL,
account_id I4,
call_to C(16) NOTNULL,
call_from C(16),
call_events X,
contact_id I4') sql=Array
(
[0] => CREATE TABLE "egw_calls" (
"call_id" SERIAL,
"call_uid" VARCHAR(64),
"call_started" TIMESTAMP NOT NULL,
"call_accepted" TIMESTAMP,
"call_hangup" TIMESTAMP,
"call_incoming" BOOLEAN NOT NULL,
"account_id" INT4,
"call_to" VARCHAR(16) NOT NULL,
"call_from" VARCHAR(16),
"call_events" TEXT,
"contact_id" INT4,
PRIMARY KEY ("call_id")
)
)
<br>
<p><b>ERROR: relation "egw_calls" already exists</b></p>
<p>AlterColumnSQL('egw_calls','account_id2',Array
(
[type] => int
[meta] => user
[precision] => 4
[comment] => account_id, if contact is a user
)
) sql=Array
(
[0] => ALTER TABLE "egw_calls" ADD COLUMN "account_id2" INT4
)
<br>
<p><b>ERROR: column "account_id2" of relation "egw_calls" already exists</b></p>
<p>AlterColumnSQL('egw_calls','call_related',Array
(
[type] => int
[precision] => 4
[comment] => call_id of related / transferred call
)
) sql=Array
(
[0] => ALTER TABLE "egw_calls" ADD COLUMN "call_related" INT4
)
<br>
<p><b>ERROR: column "call_related" of relation "egw_calls" already exists</b></p>
Database error: Invalid SQL: SELECT message_id,content FROM egw_lang WHERE lang='en' AND app_name='custom'
ERROR: current transaction is aborted, commands ignored until end of transaction block (-1)
Installation failed --> exiting!
Retrying EGroupware installation in 3 seconds ...
And this last block repeats
