[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: