PostgreSQL Exception: invalid input syntax for type timestamp

Sven Arnold <[email protected]> Sun, 15 Feb 2009 22:28:51 +0100
Newsgroups gmane.comp.cms.opengroupware.user
Message-ID <1234733331.6391.38.camel@schnuppe>
Hello guys,

I just tried to build ogo from source and install in on a fresh Ubuntu 8.10. I used the *-latest sources from http://download.opengroupware.org/nightly/sources/trunk/ 
as of February, 15th and also tried SOPE-4.6.

When connecting to the ogo-webui I receive following exception:

Application Server caught exception:

  session: 10DB10DB0149987E62
  element: 
  context: <0x0x9791b1c[WOContext]: 00149987e6209791b1c app=ogo-webui-1.1 sn=10DB10DB0149987E62 eid= rqeid=>
  request: <WORequest[0x0x9792ac4]: method=GET uri=/OpenGroupware app=OpenGroupware rqKey= rqPath=>

  class:   PostgreSQL72Exception
  name:    PostgreSQL72FatalError
  reason:  fatal pgsql error (channel=<0x0x998c014[PostgreSQL72Channel]: connection=<0x0x998c214[PGConnection]:  connection=0x0x998ca90>>): ERROR:  invalid input syntax for type timestamp with time zone: "%Y-%m-%d %H:%M:%S%z"

  info:


I found some mails regarding this issue in the past (2006-2007):

http://mail.opengroupware.org/pipermail/developer/2006-December/002802.html
http://mail.opengroupware.org/pipermail/users/2007-February/017335.html

They indicate this issue occured with OpenSUSE 10.2 and was solved.
Unfortunately it seems to be back... :-(

Postgresql is at version 8.3.5 and the database encoding is UTF8.
I tried to switch to LATIN to see if this is the problem, but postgresql
did not allow me that because it conflicts with the server locale.

Is there anybody who could help?

Thanks a lot,

Sven

-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users