Re: Projects in Webui

Adam Tauno WIlliams schrieb:
>=20
> Ah! Doh!  You're missing some v5.5 schema changes.
>=20
> -- object_id & auth_id in ACLs should be an INT
> -- may already be fixed in some databases for PG8.3 compat
> ALTER TABLE object_acl=20
>   ALTER COLUMN object_id TYPE INT USING object_id::int;
> ALTER TABLE object_acl=20
>   ALTER COLUMN auth_id   TYPE INT USING auth_id::int;
> -- field to connect documents and notes to contacts
> ALTER TABLE document ADD COLUMN company_id INT NULL;
>=20
> See if that fixes your issue.
Yep this fixes it! Thanks.
Is there a way you recommend to do updates so I don't miss such changes?
Like always dropping the DB and later restore from backup?

Regards

Christian



--=20
Dr. Christian Naumer
Senior Scientist Analytics & Engineering

B.R.A.I.N Aktiengesellschaft
Darmstaedter Str. 34-36, D-64673 Zwingenberg
e-mail [email protected], homepage www.brain-biotech.de
fon +49-6251-9331-30  /   fax +49-6251-9331-11

Sitz der Gesellschaft: Zwingenberg/Bergstrasse
Registergericht AG Darmstadt, HRB 24758
Vorstand: Dr. Holger Zinke (Vorsitz), Dr. J=FCrgen Eck
Vorsitzender des Aufsichtsrats: Ulrich Putsch
-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users