[kronolith] SQL-Problems during sync after upgrade

[Ulrich Eckhardt]

Am 21.05.2011 14:51, schrieb Ulrich Eckhardt:
> 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.

Hi,

this happens always when the event_uid for some reasons contains only 
numbers. Deleting this one event with the numeric uid solved at least my 
sync problem, but it looks like the framework or database driver does 
some guesswork on the type. Whenever the event_uid is only numeric the 
wrong type integer instead of character is guessed, leading to this 
error message.

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)