Re: PostgreSQL Exception: invalid input syntax for type timestamp

> > > No, today I have repeated all steps on a fresh installation in a virtual
> > > machine to reduce side effects. There is no other GNUStep package
> > > installed I am aware of.
> > > BTW, the postgres log shows an insert statement:
> > > INSERT INTO session_log (...) VALUES (..., "%Y-%m-%d...")
> > Correct, that's what I've seen before;  obviously the %Y-%m-%d should be
> > 2009-02-16 but it isn't expanded, so it creates the error.  I don't
> > really know what to suggest;  debugging Obj-C runtime issues is pretty
> > far beyond my pay grade.
> I've recreated the issue with my newly built openSUSE 11.1 packages! :)
> Application Server caught exception:
>   session: 3DF13DF10149A83658
>   element: 
>   context: <0x0x8d01164[WOContext]: 00149a8365808d01164 app=ogo-webui-1.1 sn=3DF13DF10149A83658 eid= rqeid=>
>   request: <WORequest[0x0x8cfdc34]: method=GET uri=/OpenGroupware app=OpenGroupware rqKey= rqPath=>
>   class:   PostgreSQL72Exception
>   name:    PostgreSQL72FatalError
>   reason:  fatal pgsql error (channel=<0x0x8f16c24[PostgreSQL72Channel]: connection=<0x0x8f0e044[PGConnection]:  connection=0x0x8f17638>>): ERROR:  invalid input syntax for type timestamp with time zone: "%Y-%m-%d %H:%M:%S%z"
>   info:
> Whoo hoo!

Interesting, it even appears in the ogo-zidestore-1.5 error log
.....
Feb 27 19:47:43 ogo-zidestore-1.5 [13293]: |ogo-zidestore-1| register
ZideStore product: Projects.zsp
Feb 27 19:47:44 ogo-zidestore-1.5 [13293]: |ogo-zidestore-1| vMem Size
check enabled: shutting down app when vMem > 200 MB
%b %d %H:%M:%S ogo-zidestore-1.5 [13293]: Note: using default ZideStore
port, 21000
Feb 27 19:47:44 ogo-zidestore-1.5 [13293]: |ogo-zidestore-1|
WOHttpAdaptor listening on address *:21000
.....


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