[Tickets #10171] SQL-Problems during sync

[bugs at horde.org]

BITTE NICHT AUF DIESE NACHRICHT ANTWORTEN. NACHRICHTEN AN DIESE  
E-MAIL-ADRESSE WERDEN NICHT GELESEN.

Ticket-URL: http://bugs.horde.org/ticket/10171
------------------------------------------------------------------------------
  Ticket           | 10171
  Erstellt Von     | uli-ho at uli-eckhardt.de
  Zusammenfassung  | SQL-Problems during sync
  Warteschlange    | Kronolith
  Version          | 3.0.2
  Typ              | Bug
  Status           | Unconfirmed
  Priorität        | 1. Low
  Milestone        |
  Patch            |
  Zuständige       |
------------------------------------------------------------------------------


uli-ho at uli-eckhardt.de (2011-06-01 18:35) hat geschrieben:

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.