[kronolith] SQL-Problems during sync after upgrade

[Michael J Rubinsky]

Quoting Per olof Ljungmark <peo at intersonic.se>:

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

http://bugs.horde.org/ticket/?id=10171



-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 6062 bytes
Desc: S/MIME Cryptographic Signature
URL: <http://lists.horde.org/archives/kronolith/attachments/20120928/667dbdad/attachment.bin>