[OGo-Users] Postgre fatal error after new install on Suse 10.2

[Adam Tauno Williams]

> > > Application Server caught exception:
> > >   reason:  fatal pgsql error (channel=<0x0x88e0214[PostgreSQL72Channel]: connection=<0x0x88e0414[PGConnection]:  connection=0x0x88e0c88>>): ERROR:  invalid input syntax for type timestamp with time zone: "%Y-%m-%d %H:%M:%S%z"
> A snippet of the log with PGDebugEnabled and command profiling enabled
> looks like:
...
> Jan 29 14:29:37 ogo-webui-1.1 [31395]: PG0x0x88e6274 SQL: INSERT INTO
> session_log (account_id, session_log_id, action, log_date) VALUES
> (10000, 10280, 'login', '%Y-%m-%d %H:%M:%S%z')

This really looks to me like it is attempting to insert the *LITERAL*
value of "%Y-%m-%d %H:%M:%S%z" which isn't getting replaced with the
timestamp values.

Perhaps this relates to
http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1828 ["Times
do not display in view appointment", we see "%Y-%m-%d %H:%M %Z"] which
recently appeared.

I think something has gone wrong with date/time handling.

This is with OGo straight from the repository/packages,  no local
hackery.