Re: OGO-WebUI Error column t1.birthname does not exist

On Wed, 2009-10-07 at 14:29 +0100, Ken Smith wrote:
> Just setup OGO 5.5 from the repository at 
> http://download.opensuse.org/repositories/server://OpenGroupware/CentOS_5/ 
> on a Centos system to do some testing with Zideone and I get this error 
> in the browser when I first try to log in
> The same error message is in the WebUI error log.
> Postgres has the OGo database installed by the .rpm. I can't see a table 
> with a t1.birthname column.
> I recall seeing some discussion about schema alterations but not 
> involving t1.birthname as far as I recall
> I noticed that the file pg-update-1.x-to-5.5.psql includes the stanza
> ALTER TABLE company ADD COLUMN birthname     VARCHAR(255) NULL;

Did you try running the update script?  Possibly the dbsetup package
isn't using the correct [current] script.

Looking at the script it does look like the default creation script is
missing that attribute, among others.
<http://svn.opengroupware.org/OpenGroupware.org/trunk/Database/PostgreSQL/pg-build-schema.psql>
Try running the update script.
<http://svn.opengroupware.org/OpenGroupware.org/trunk/Database/PostgreSQL/pg-update-1.x-to-5.5.psql>

> Any ideas. I've probably missed something obvious.

More likely that I did.


-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users