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

I had to revert as eGroupware 21.1 refuses to get past that and become available.
That last block just keeps repeating every 3 seconds.

Personally, I think the probiem is that the select from “egw_lang” is failing due to the transaction being aborted and that happens because of the errors with the alter table before.

I can live without kanban for now, but it’s the one new feature I have really been looking forward to since it was announced.

Ralf,

Sorry for the late response.

Thank you for this. Any idea when the next release will be available?

Ralf,

Thank you.
Then I will wait for the release before testing the upgrade again.

Ralf and Stefan,

The upgrade now works using Postgresql.
(Not been able to test before)

Many thanks,

Joost