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