Summary | DB Error in horde_syncml_map where event_uid > 64 char |
Queue | Synchronization |
Type | Bug |
State | Resolved |
Priority | 1. Low |
Owners | jan (at) horde (dot) org |
Requester | patrick.abiven (at) apitech (dot) fr |
Created | 02/23/2007 (6707 days ago) |
Due | |
Updated | 04/04/2008 (6301 days ago) |
Assigned | 03/14/2008 (6322 days ago) |
Resolved | 04/04/2008 (6301 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | |
Patch | No |
Assigned to Jan Schneider
State ⇒ Resolved
Taken from Karsten Fourmont
State ⇒ Feedback
for all columns.
This issue occurs when we are importing a Calendar .ics file coming
from Microsoft Outlook.
In the .ics file, the UID field contains a long string and this UID
will be used by Horde during the import.
UID:000000001043539B1694D21197500008C70998510700A129B1466193D211974E0008C709985100000000100C0000010135B21BBB164AAA2FE3BFEE4634F900000
02EFEEE0000
In Rfc2445 : "Implementations MUST be able to receive and persist
values of at least 255 characters for this property".
Regards
Patrick
I used only 64 byte length because there's an sql index on
syncpartner+db+id in syncml_map and an index is restricted to 256
bytes length in mysql.
What's the supposed maximum length for an ID?
Assigned to Karsten Fourmont
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ DB Error in horde_syncml_map where event_uid > 64 char
Queue ⇒ Synchronization
State ⇒ Unconfirmed
The new version with horde_syncml_map table instead of horde_datatree
greatly improves performances !
But synchronizing a calendar generates some DB Errors 'created Map for
cuid=.... and suid=<more than 64 char>'
In kronolith_events, the field event_uid is defined as VARCHAR(255),
but in the horde_syncmap_map, the field is defined as VARCHAR(64).
Regards
Patrick