[kronolith] SQL-Problems during sync after upgrade

[Per olof Ljungmark]

On 2011-06-01 19:44, Jan Schneider wrote:
>
> 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.
>


Was this fixed or a ticket created? Could not find anything in bugs.

//per