Hi,
I try to remove tons of duplicate contacts After upgrading from SoGo 3.*
to 4.* 6 month ago.
So I ran this command with the errors below :
-------8<------------------
# sogo-tool remove-doubles me "Carnet\ d'adresses personnel"
<0x0xb8d380[GCSFolderManager]> ERROR(-[GCSFolderManager performSQL:]):
cannot execute
SQL 'SELECT c_folder_id, c_path, c_location, c_quick_location,
c_acl_location, c_folder_type FROM sogo_folder_info WHERE c_path1 =
'Users' AND c_path2 = 'me' AND c_path3 = 'Contacts' AND c_path4 =
'Carnet\ d'adresses personnel'':
<MySQL4Exception: 0xd75c30> NAME:ExecutionFailed REASON:You have an
error in your SQL syntax; check the manual that corresponds to your
MariaDB server version for the right syntax to use near 'adresses
personnel'' at line 1
<0x0xb8d380[GCSFolderManager]> ERROR(-[GCSFolderManager recordAtPath:]):
executing SQL failed: 'SELECT c_folder_id, c_path, c_location,
c_quick_location, c_acl_location, c_folder_type FROM sogo_folder_info
WHERE c_path1 = 'Users' AND c_path2 = 'me' AND c_path3 = 'Contacts' AND
c_path4 = 'Carnet\ d'adresses personnel''
Folder 'Carnet\ d'adresses personnel' of user 'me' not found.
-------8<------------------
Seems like a quoting issue ?
Tried many backquotes or quoting solutions, none works.
But the folder exists :
-------8<------------------
MariaDB [sogo]> select distinct c_foldername from sogo_folder_info;
+-----------------------------+
| c_foldername |
+-----------------------------+
| xxxxx |
| Agenda personnel |
| Carnet d'adresses personnel |
| Personal Calendar |
+-----------------------------+
8 rows in set (0.00 sec)
-------8<------------------
Any idea please ?
Is it the good way to remove duplicate contacts ?
If not, is there anymore way please ?
Regards.
--
[email protected]
https://inverse.ca/sogo/lists
