Hello
Am 20.11.19 um 21:31 schrieb Gilles Quenot ([email protected]): > 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 ? > You have to provide the ID of the addressbook, not its name. Therefore use: sogo-tool remove-doubles me personal The ID of other addressbooks than personal can be extracted from sogo-tool backup via sogo-tool restore -l /backupdir/ username 2>&1 | grep Contacts You get that error message, because ' characters are invalid in those IDs. Kind regards, Christian Mack -- Christian Mack Universität Konstanz Kommunikations-, Informations-, Medienzentrum (KIM) Abteilung Basisdienste 78457 Konstanz +49 7531 88-4416
smime.p7s
Description: S/MIME Cryptographic Signature
