[OGo-Users] Postgre fatal error after new install on Suse 10.2

Adam Tauno Williams users@opengroupware.org
Mon, 29 Jan 2007 08:37:39 -0500


> Nope, no effect what-so-ever.
> I've tried adding:
> export PGDATESTYLE=ISO
> export PGTZ=GMT
> to both the PostgreSQL and OGo WebUI startup script;  no change at all.

Setting:
datestyle = ISO
timezone = GMT 
 in postgresql.conf (and restarting PostgreSQL) also has no effect. :(

> Application Server caught exception:
>   session: 781078100145BDE84C
>   element: 
>   context: <0x0x86f791c[WOContext]: 00145bde84c086f791c app=ogo-webui-1.1 sn=781078100145BDE84C eid= rqeid=>
>   request: <WORequest[0x0x86f3f24]: method=GET uri=/OpenGroupware app=OpenGroupware rqKey= rqPath=>
>   class:   PostgreSQL72Exception
>   name:    PostgreSQL72FatalError
>   reason:  fatal pgsql error (channel=<0x0x88e0214[PostgreSQL72Channel]: connection=<0x0x88e0414[PGConnection]:  connection=0x0x88e0c88>>): ERROR:  invalid input syntax for type timestamp with time zone: "%Y-%m-%d %H:%M:%S%z"
>   info: