OGO-WebUI Error column t1.birthname does not exist

[Ken Smith-13]

Hi,

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.


Application Server caught exception:

  session: 54FD54FD014ACC7724
  element:
  context: <0x0xa464034[WOContext]: 0014acc77240a464034 app=ogo-webui-5.5 sn=54FD54FD014ACC7724 eid= rqeid=>
  request: <WORequest[0x0xa4607d4]: method=GET uri=/OpenGroupware app=OpenGroupware rqKey= rqPath=>

  class:   PostgreSQL72Exception
  name:    PostgreSQL72FatalError
  reason:  fatal pgsql error (channel=<0x0xa68b574[PostgreSQL72Channel]: connection=<0x0xa68b75c[PGConnection]:  \
connection=0x0xa68bfb0>>): ERROR:  column t1.birthname does not exist

  info:


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;


:-(

Any ideas. I've probably missed something obvious.

Thanks

Ken

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

--
OpenGroupware.org Users
users@...
http://mail.opengroupware.org/mailman/listinfo/users

[Adam Tauno Williams]

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
users@...
http://mail.opengroupware.org/mailman/listinfo/users

[Ken Smith-13]

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
users@...
http://mail.opengroupware.org/mailman/listinfo/users