[kronolith] SQL-Problems during sync after upgrade

[Jan Schneider]

Zitat von Ulrich Eckhardt <uli-ho at uli-eckhardt.de>:

> 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.

Please create a ticket.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/