"account_description" column missing in egw_accounts

[slemmens]

Hi All, Hope we can sort this out.

Since a few updates ago (cannot reproduce it) I have an issue with the accounts table during an upgrade.
During upgrade it fails with following log:

Database is version 17.1 and up to date.
Backup started, this might take a few minutes …
Backup finished.
Database error: Invalid SQL: INSERT INTO egw_accounts
(account_type,account_lid,account_status,account_primary_group,account_expires,account_description,account_pwd) VALUES
(‘g’,‘NoGroup’,‘A’,0,-1,‘EGroupware anonymous users group, do NOT delete’,’’)
Unknown column ‘account_description’ in ‘field list’ (1054)

It expects a colomn that does not excists… (Oops)

anyone a clue?

Sacha.

[RalfBecker]

Hi Sacha,

account_description column was added in 14.2 update.

If you don’t have it, just create it as varchar(255).

Ralf

[slemmens]

Ok, thank you for your quick reply Ralf, but what else did we miss there, because, when I add it a lot of errors in the web-end arise. all kind of database error’s (SQL).

Sacha

[RalfBecker]

That is hard to tell without knowing which updates you made and which failed.

You can only compare the columns you have with our schema files $app/setup/tables_current.inc.php

Ralf

[slemmens]

Looks like that we have to do that.
More specific: On login in and opening the addressbook we get the error:

Invalid SQL: 1, egw_addressbook.n_given as n_given, …, account_description FROM egw_addressbook
RIGHT JOIN egw_accounts… ORDER BY n_family, n_given,account_lid

The error: Column ‘account_description’ in field list is ambiguous (1052)

Sacha

[slemmens]

Resolved,… sorry my error…
I’ve been looking into this earlier, and looks like I allready created this column. But in the addressbook table…

Then its difficult for SQL to choose between the two…
Removed it there and resolved.
Now trying the upgrades again…

Sacha.