[OGo-Users] Fedora 4 postgresql timestamp error

[Charles Buenzli]

I did an install using the 2feb07 FC4 trunk release and am getting 
the same postgresql error that was seen on Susie 10.2. I'm using 
postgresql 8.0.8-1.FC4.1. Is this the correct version?


Application Server caught exception:

   session: 2E892E890145DC436C
   element:
   context: <0x0x895ee4c[WOContext]: 00145dc436b0895ee4c 
app=ogo-webui-1.1 sn=2E892E890145DC436C eid= rqeid=>
   request: <WORequest[0x0x895b4cc]: method=GET uri=/OpenGroupware 
app=OpenGroupware rqKey= rqPath=>

   class:   PostgreSQL72Exception
   name:    PostgreSQL72FatalError
   reason:  fatal pgsql error 
(channel=<0x0x8b47224[PostgreSQL72Channel]: 
connection=<0x0x8b47424[PGConnection]:  connection=0x0x8b47c98>>): 
ERROR:  invalid input syntax for type timestamp with time zone: 
"%Y-%m-%d %H:%M:%S%z"


The recommended fix was to recompile SOPE, but I never saw a 
confirmation that this worked. There are 4 SOPE source tarballs. Do I 
need to recompile all of them?

I also tried the 21feb07 trunk release but could not get it to work 
yet. It has two versions of SOPE: sope-45 and sope-47. Only sope-45 
will install. Why are there two versions and which should I be using.

Is there an easy way to uninstall ogo completely. I'd like to start 
fresh, but don't want to rebuild my whole system.

Regards,

Charles Buenzli
Vice President & COO
Novocell Semiconductor Inc.
3182 Innovation Way, Suite 201
Hermitage, PA  16148
Phone: 724-983-0600
Fax: 724-983-1011
Email: charles@novocellsemi.com