Re: PostgreSQL Exception: invalid input syntax for type timestamp

On Mon, 2009-02-16 at 16:44 -0500, Adam Tauno Williams wrote:
> On Mon, 2009-02-16 at 18:05 +0100, Sven Arnold wrote:
> > > Seems complicated (but all Debian/Ubuntu packaging is);  but libobjc-4.3
> > > should be fine.  I've no idea what the "gobjc" package is.
> > ok, maybe I referenced the wrong package. But there is also
> > libobjc2-4.3.2.
> > > > and compiled from source only these packages:
> > > > - gnustep-make-1.10.
> > > Do you mean ogo_gnustep-make?  The gnustep-make that came from the
> > > download site?
> > yes:
> > http://download.opengroupware.org/nightly/sources/trunk/gnustep-make-latest.tar.gz
> > > > - libfoundation
> > > > - sope
> > > > - sope-mod_ngobjweb
> > > > - opengroupware.org
> > > Correct.  I assume libfoundation is libfoundation11-1.1.7 or the like.
> > yes, at least the last entry in the ChangeLog says this.
> > > > Does run ogo elswhere with postgresql-8.3 or on Ubuntu 8.10 ?
> > > Yes, it runs on 8.3 here, and elsewhere.  I have no idea about Ubuntu
> > > but it shouldn't matter - there is nothing magical about distributions,
> > > just repackaging of the same stuff.  Both previously related issues with
> > > the same error were the result of ABI/version issues I believe.  Do you
> > > possibly have GNUStep stuff installed and something is picking that up
> > > and linking to it?
> > 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 have an Ubuntu VM floating around here somewhere that I'll test on
> when I get a chance.  Otherwise, if a VM is what you want,  I can post a
> working VM for you to download if you like?

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!
    

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