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