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

Adam Tauno Williams wrote:
> 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.
>
>
>   
Running the update script worked. The WebUI is working now. Thanks

But it did give an error like this

psql:pg-update-1.x-to-5.5.psql:45: ERROR:  column "owner_id" of relation 
"job" already exists

I looked for birthname in pg-build-schema.psql, at least not in the 
version arrived from the yum repository today.....


Thanks

Ken



-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

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