Tickets :: Comment on [#10171] SQL-Problems during sync

* Your Email Address
* Spam protection	Enter the letters below: .__.. .. . __ . [__]\| \|\|\ \|/ ` \| \| \|\|/\\|\| \\|\__.\__\|
Comment	> With Horde 4.0.2/Kronolith 3.0.2 and postgresql 8.4. 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. > > 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. > > The horde installation runs on Debian 6.0.1 with postgresql 8.4. >
Attachment
Watch this ticket