6.0.0-beta6
▾
Tasks
New Task
Search
Photos
Wiki
▾
Tickets
New Ticket
Search
dev.horde.org
Toggle Alerts Log
Help
4/10/26
H
istory
A
ttachments
C
omment
W
atch
Download
Comment on [#6056] Contacts get tripled using Synthesis Client
*
Your Email Address
*
Spam protection
Enter the letters below:
._..__ ._.. ,.__ | | \ | \./ [ __ _|_|__/_|_ | [_./
Comment
> Looks like the indizes for horde_syncml_map are severly broken in the > old database. Probably something gone bad somewhere in one of the > upgrade steps from 3.1 to 3.2-rcX. > > > > mysql> show index from horde_syncml_map; > > +------------------+------------+------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+ > > | Table | Non_unique | Key_name | > Seq_in_index | Column_name | Collation | Cardinality | > Sub_part | Packed | Null | Index_type | Comment | > > +------------------+------------+------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+ > > | horde_syncml_map | 1 | syncml_cuid_idx | > 1 | syncml_syncpartner | A | 5 | NULL | NULL > | | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_cuid_idx | > 2 | syncml_db | A | 12 | NULL | NULL > | | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_cuid_idx | > 3 | syncml_uid | A | 12 | NULL | NULL > | | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_cuid_idx | > 4 | syncml_cuid | A | 3860 | NULL | NULL > | YES | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_suid_idx | > 1 | syncml_syncpartner | A | 5 | NULL | NULL > | | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_suid_idx | > 2 | syncml_db | A | 12 | NULL | NULL > | | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_suid_idx | > 3 | syncml_uid | A | 12 | NULL | NULL > | | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_suid_idx | > 4 | syncml_suid | A | 1930 | NULL | NULL > | YES | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_syncpartner_idx | > 1 | syncml_syncpartner | A | 5 | NULL | NULL > | | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_db_idx | > 1 | syncml_db | A | 4 | NULL | NULL > | | BTREE | NULL | > > | horde_syncml_map | 1 | syncml_uid_idx | > 1 | syncml_uid | A | 2 | NULL | NULL > | | BTREE | NULL | > > +------------------+------------+------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+ > > 11 rows in set (0.00 sec) > > > > I did remove the horde_synml_map and horde_syncml_anchor tables, > cleaned up addressbook and calender, and now the sync seem to work, > at least with test account and VPA. > > > > With the production VPA and my normal account, it doesn't like to add > contacts now, but I will investigate that tomorrow. > > > >
Attachment
Watch this ticket
N
ew Ticket
M
y Tickets
S
earch
Q
uery Builder
R
eports
Saved Queries
Open Bugs
Bugs waiting for Feedback
Open Bugs in Releases
Open Enhancements
Enhancements waiting for Feedback
Bugs with Patches
Enhancements with Patches
Release Showstoppers
Stalled Tickets
New Tickets
Horde 5 Showstoppers