[kronolith] SQL-Problems during sync after upgrade

Ulrich Eckhardt uli-ho at uli-eckhardt.de
Sat May 21 12:51:14 UTC 2011


Hi,

with Horde 4.0.2/Kronolith 3.0.2 I always get the following SQL-Error 
when i try to sync the calendar data from my mobile phone to the server:

h1690828 HORDE: HORDE [horde] SQLSTATE[42883]: Undefined function: 7 
FEHLER:  Operator existiert nicht: character varying = integer LINE 1: 
...riginaldate FROM kronolith_events WHERE event_uid = 96437035 ... 
                                                          ^ HINT:  Kein 
Operator stimmt mit dem angegebenen Namen und den Argumenttypen überein. 
Sie müssen möglicherweise ausdrückliche Typumwandlungen hinzufügen. [pid 
14062 on line 481 of "/var/apache/mail/kronolith/lib/Driver/Sql.php"]

Since event_uid is of type character, this error message is correct. I 
had equal problems when i tried to convert the old Horde 3.x 
installation. Several conversion scripts complained about the numeric 
event_uid. Any ideas whats going wrong here?

The horde installation runs on Debian 6.0.1 with postgresql 8.4.

Best Regards
Uli
-- 
Ulrich Eckhardt                  http://www.uli-eckhardt.de

Ein Blitzableiter auf dem Kirchturm ist das denkbar stärkste
Misstrauensvotum gegen den lieben Gott. (Karl Krauss)



More information about the kronolith mailing list