[OGo-Users] Postgre fatal error after new install on Suse 10.2
Adam Tauno Williams
users@opengroupware.org
Fri, 26 Jan 2007 12:59:05 -0500
> > When I try to goto http://localhost/OpenGroupware I get this:
> > Application Server caught exception:
> > session: 164716470145B81989
> > element:
> > context: <0x0x86ee43c[WOContext]: 00145b81988086ee43c app=ogo-webui-1.1
> > sn=164716470145B81989 eid= rqeid=>
> > request: <WORequest[0x0x86eaafc]: method=GET uri=/OpenGroupware
> > app=OpenGroupware rqKey= rqPath=>
> > class: PostgreSQL72Exception
> > name: PostgreSQL72FatalError
> > reason: fatal pgsql error (channel=<0x0x88d6bcc[PostgreSQL72Channel]:
> > connection=<0x0x88d6dcc[PGConnection]: connection=0x0x88d7640>>): ERROR:
> > invalid input syntax for type timestamp with time zone: "%Y-%m-%d
> > %H:%M:%S%z"
> > info:
> > I've never used PostgreSQL so I'm not familiar with it's errors. What can
> > I do to correct this.
> Hmmm. I remember seeing something like this previously.
> http://mail.opengroupware.org/pipermail/developer/2006-December/002798.html
> But the problem just vanished as mysteriously as it appeared. This
> error message is coming up from PostgreSQL, not from 'inside' OGo.
> I'll run a fresh install and see what happens.
It seems this pops up on OX [OpenExchange] occasionally as well. What
is the locale/encoding on your DB server?