Re: PostgreSQL Exception: invalid input syntax for type timestamp

On Sun, 2009-02-15 at 22:28 +0100, Sven Arnold wrote:
> 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.

The current code uses UTF8, so that's fine.

> Is there anybody who could help?

Did you install libobcj-lf?  If so you need to remove it and rebuild.
You must use the system libobj with SOPE47, and you must use SOPE47 with
the latest/trunk/1.1 OGo.  This is documented in WMOGAG
<http://docs.opengroupware.org/Members/whitemice/wmogag/file_view>.  See
the chapter "Installation").

You do need to make a small change to the schema for PostgreSQL, this is
also covered in WMOGAG (see page 137 of the current WMOGAG).
-- 
OpenGroupware developer: [email protected]
<http://whitemiceconsulting.blogspot.com/>

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