| Ticket modified by Jörg Lehrke at 2009/07/03 14:22 |
| Tracking System: Bugs |
| Category: SyncML |
| Version: Trunk |
| Status: Closed |
| Resolution: Fixed |
| Completed: 0% |
| Priority: 5 - medium |
| Created By: camel camel |
| Assigned to: Jörg Lehrke |
| Summary: #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.
|
| Comment by Jörg Lehrke at 2009/07/03 14:22: |
Hi Ralf,
that my fault. I newer tested with a Postgres DB. Thanks for your help! I will adopt your solution for my 1.6.001 patch, too. |
| Comment by Ralf Becker at 2009/07/03 09:55: |
It's only in SyncML 1.2 branch. I fixed it there.
Ralf |
| Comment by Ralf Becker at 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 |
| Comment by camel camel at 1970/01/01 01:33: |
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
