[OGo-Users] SuSE 10 - invalid input syntax for type timestamp

[Willi Fendt]

Hello, Adam !

Thank you for your response.

I installed the packages from the suse 10 directory:


rpm -qa | grep -i sope gives:

sope47-gdl1-4.7-trunk_r1503.0
sope47-gdl1-devel-4.7-trunk_r1503.0
sope47-xml-devel-4.7-trunk_r1503.0
sope47-appserver-4.7-trunk_r1503.0
sope47-gdl1-tools-4.7-trunk_r1503.0
sope47-xml-4.7-trunk_r1503.0
sope47-mime-4.7-trunk_r1503.0
sope47-appserver-tools-4.7-trunk_r1503.0
sope47-gdl1-postgresql-4.7-trunk_r1503.0
sope47-ldap-tools-4.7-trunk_r1503.0
sope47-ldap-4.7-trunk_r1503.0
sope47-appserver-devel-4.7-trunk_r1503.0
sope47-gdl1-mysql-4.7-trunk_r1503.0
sope47-ldap-devel-4.7-trunk_r1503.0
sope47-xml-tools-4.7-trunk_r1503.0
sope47-ical-4.7-trunk_r1503.0
sope47-ical-devel-4.7-trunk_r1503.0
sope47-core-4.7-trunk_r1503.0
sope47-core-devel-4.7-trunk_r1503.0
sope47-mime-devel-4.7-trunk_r1503.0

rpm -qa | grep -i ogo gives:

ogo-logic-tools-1.1-trunk_r1985.0
ogo-zidestore-devel-1.1-trunk_r1985.0
ogo-theme-default-1.1-trunk_r1985.0
ogo-webui-contact-1.1-trunk_r1985.0
ogo-theme-ooo-1.1-trunk_r1985.0
ogo-logic-1.1-trunk_r1985.0
ogo-tools-1.1-trunk_r1985.0
ogo-docapi-db-project-devel-1.1-trunk_r1985.0
ogo-pda-1.1-trunk_r1985.0
ogo-webui-task-1.1-trunk_r1985.0
ogo-docapi-db-project-1.1-trunk_r1985.0
ogo-zidestore-1.1-trunk_r1985.0
ogo-docapi-fs-project-devel-1.1-trunk_r1985.0
ogo-logic-devel-1.1-trunk_r1985.0
ogo-webui-app-1.1-trunk_r1985.0
ogo-environment-1.1-0
ogo-webui-project-1.1-trunk_r1985.0
ogo-theme-blue-1.1-trunk_r1985.0
ogo-webui-mailer-devel-1.1-trunk_r1985.0
ogo-gnustep_make-1.10.0-0
ogo-webui-core-1.1-trunk_r1985.0
ogo-webui-core-devel-1.1-trunk_r1985.0
ogo-docapi-devel-1.1-trunk_r1985.0
ogo-webui-resource-en-1.1-trunk_r1985.0
ogo-webui-mailer-1.1-trunk_r1985.0
ogo-webui-news-1.1-trunk_r1985.0
ogo-pda-devel-1.1-trunk_r1985.0
ogo-theme-orange-1.1-trunk_r1985.0
ogo-docapi-1.1-trunk_r1985.0
ogo-xmlrpcd-1.1-trunk_r1985.0
ogo-webui-resource-de-1.1-trunk_r1985.0
ogo-meta-1.1-trunk_r1985.0
ogo-docapi-fs-project-1.1-trunk_r1985.0
ogo-database-setup-1.1-0
ogo-webui-calendar-1.1-trunk_r1985.0
ogo-theme-kde-1.1-trunk_r1985.0

rpm -qa | grep -i libfoun
libfoundation11-1.1.5-trunk_r157.0
libfoundation11-devel-1.1.5-trunk_r157.0

>From this source:
http://download.opengroupware.org/nightly/packages/suse10-0/trunk/

I saw a discussion where a Problem which sounds very like this
was solved für opensuse 10.2 ?
For SUSE 10.2 there are new packages on this website:
http://docs.opengroupware.org/Members/whitemice/misc/ogo-install-for-opensuse102/view?searchterm=opensuse%2010.2 

Willi

Adam Tauno Williams schrieb:

>> I installed Opengroupware on a SuSE 10.0 Server.
>> Installation worked with rpm.
>> When I try to open http://localhost/OpenGroupware
>> there is an error message: 
>> "Application Server caught exception"
>> "invalid input syntax for type timestamp"
>> I use sope47 r1502 rpm packages from download.opengroupware.org
>> I tried to find the problem in postgresql:
>> but there is also just the error message "ungültige Eingabesyntax für Typ
>> timestamp with time zone: »%Y-%m-%d %H:%M:%S%z«"
>> How can i fix this Problem ?
>>     
>
> What packages did you install?  I've had this before, and I believe it
> is an ABI problem.
>
>