Hi,

I ran successfully 'sogo-tool me personal' to remove some duplicates contacts, removed =~ 50 000 duplicates. Thanks Christian Mack <https://lists.inverse.ca/sogo/arc/users/2019-11/msg00087.html>

But still remains =~ 200 000 contacs, where I should have less than 2000 items.

Is someone have a clue to remove duplicates contacts properly ?

The duplicates was coming from the update of sogo 3.* to sogo 4.*.

It makes ActiveSync failing to synchronize contacts.

Configuration :
Sogo 4.0.7.20190404-1
MariaDB
Linux Debian 10

List of sogo tables :
-------8<------------------
MariaDB [sogo]> show tables;
+---------------------------------------------------+
| Tables_in_sogo                                    |
+---------------------------------------------------+
| sogo_acl                                          |
| sogo_alarms_folder                                |
| sogo_cache_folder                                 |
| sogo_folder_info                                  |
| sogo_quick_appointment                            |
| sogo_quick_contact                                |
| sogo_sessions_folder                              |
| sogo_store                                        |
| sogo_user_profile                                 |
| sogogillesqu0014c5cb855                           |
| sogogillesqu0014c5cb855_acl                       |
| sogogillesqu0014c5cb855_quick                     |
| sogogillesqu0015396f580                           |
| sogogillesqu0015396f580_acl                       |
| sogogillesqu0015396f580_quick                     |
| sogogillesqu0024bb73092                           |
| sogogillesqu0024bb73092_acl                       |
| sogogillesqu0024bb73092_quick                     |
| sogogillesqu002647702b5                           |
| sogogillesqu002647702b5_acl                       |
| sogogillesqu002647702b5_quick                     |
| sogogillesqu003044ce6c4                           |
| sogogillesqu003044ce6c4_acl                       |
| sogogillesqu003044ce6c4_quick                     |
| sogogillesqu003686d9622                           |
| sogogillesqu003686d9622_acl                       |
| sogogillesqu003686d9622_quick
-------8<------------------

Regards

--
users@sogo.nu
https://inverse.ca/sogo/lists

Reply via email to