| Ticket geändert von Ralf Becker am 2009/07/03 09:31 |
| Verfolgungssystem: Bugs |
| Kategorie: SyncML |
| Version: Trunk |
| Status: Offen |
| Lösung: Keine |
| Prozent erledigt: 0% |
| Priorität: 5 - mittlere |
| Erstellt von: camel camel |
| Zugewiesen an: Jörg Lehrke |
| Zusammenfassung: #2153 - database error on normal syncing - contacts --> operator does not exist: |
[last trunk + syncml-1.2-last branch, (ldap, postgresql8.3)]
[EGW-Syncml setting -> is set to "client wins"]
at first i synced contacts via recover sync to EGW -> works fine
then i tried to sync notrmal again.
then - i got an error on contact syncing
Database error
Database error
Invalid SQL: DELETE FROM egw_contentmap WHERE map_id = 'sync@...' AND map_expired = 1 AND map_timestamp <= '2009-07-03 0:22:07':
ERROR: operator does not exist: boolean = integer
LINE 1: ...UMzpBZG1pbmlzdHJhdG9ysifcontacts' AND map_expired = 1 AND ma...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
|
| Kommentar von Ralf Becker am 2009/07/03 09:31: |
That's a postgres specific problem, you need to use either egw_db::delete(), which casts automatic to boolean (t or f for postgres), or use db->quote($value,'boolean').
Ralf |
| Kommentar von camel camel am 1970/01/01 01:00: |
but i'm quite sure, that this was working on rev. 27240
and on syncing i can sync (settings: both direction), then all items are sending to server + import to EGW server db, but then i get the error, and the data from server won't send to client.
maybe this helps for finding the bug.
last trunk + last branch of syncml-1.2 |
Linked entries:
Bugs #2153: database error on normal syncing - contacts --> operator does not exist:
------------------------------------------------------------------------------
_______________________________________________
eGroupWare-tracker mailing list
eGroupWare-tracker@...
https://lists.sourceforge.net/lists/listinfo/egroupware-tracker
