View Issue Details

IDProjectCategoryView StatusLast Update
0004880SOGosogo-toolpublic2020-01-06 22:03
ReporterStardustOne Assigned Tofrancis  
PrioritynormalSeverityminorReproducibilityalways
Status feedbackResolutionreopened 
PlatformLinuxOSDebianOS Version10
Product Version4.0.7 
Summary0004880: 'sogo-tool remove-doubles' with spaces and single quote issue
Description

Hi,

I try to remove tons of contact dupes.

So I ran this command :

-------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<------------------

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<------------------

Tried many backquotes or quoting solutions, none works.

Any idea please ?

Steps To Reproduce

Run again the command

TagsNo tags attached.

Activities

StardustOne

StardustOne

2019-11-29 02:19

reporter   ~0013936

Was needing:

sogo-tool remove-doubles me@domain.tld personal

StardustOne

StardustOne

2020-01-06 22:03

reporter   ~0014027

You should describe what means an 'id' in the documentation and the --help of sogo-tool

Issue History

Date Modified Username Field Change
2019-11-13 18:52 StardustOne New Issue
2019-11-29 02:19 StardustOne Note Added: 0013936
2020-01-06 20:24 francis Assigned To => francis
2020-01-06 20:24 francis Status new => closed
2020-01-06 20:24 francis Resolution open => no change required
2020-01-06 22:03 StardustOne Status closed => feedback
2020-01-06 22:03 StardustOne Resolution no change required => reopened
2020-01-06 22:03 StardustOne Note Added: 0014027