Re: [SOGo] sogo-tool remove-doubles
Am 20.01.2016 um 18:49 schrieb Louis-Philippe: > Hi, > > In the documentation, sogo-tool remove-doubles is for contacts only. There > is a way with sogo-tool to delete duplicate events ? > > A Blackberry push a lot of existing events many times (up to 1800 times > (copies) for one event !) > The events have the same c_startdate and same c_enddate but not the same > title (encoding problem with accented letter) > No, there is no such feature in SOGo. 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
[SOGo] sogo-tool remove-doubles
Hi, In the documentation, sogo-tool remove-doubles is for contacts only. There is a way with sogo-tool to delete duplicate events ? A Blackberry push a lot of existing events many times (up to 1800 times (copies) for one event !) The events have the same c_startdate and same c_enddate but not the same title (encoding problem with accented letter) Thanks -- Louis-Philippe Gauthier -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] sogo-tool remove-doubles
Hello Donny Brooks On 2012-03-22 19:38, Donny Brooks wrote: I am trying to remove some duplicate entries in my address book by using sogo-tool. However this is what I get when I try to do so: -bash-3.2$ /usr/sbin/sogo-tool remove-doubles dbrooks personal Mar 22 13:36:43 sogo-tool [16656]: [ERROR] 0x0x808fa98[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,a.c_givenname,a.c_cn,a.c_sn,a.c_screenname,a.c_l,a.c_mail,a.c_o,a.c_ou,b.c_telephoneNumber,b.c_content,b.c_version,b.c_creationdate,b.c_lastmodified FROM sogodbrooks0022dd33700_quick a, sogodbrooks0022dd33700 b WHERE (c_component = 'vcard') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': MySQL4Exception: 0x7f8bb38 NAME:ExecutionFailed REASON:Unknown column 'b.c_telephoneNumber' in 'field list' Unable to fetch required fields from folder. I am running it as the sogo user but that looks like a mysql error to me. What can I do to fix this? Seems there is a column c_telephoneNumber missing in your table sogodbrooks0022dd33700. Did you execute all database upgrade scripts on upgrading SOGo? (We use postgres so I can't check if this is a bug or not myself.) Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] sogo-tool remove-doubles
I am trying to remove some duplicate entries in my address book by using sogo-tool. However this is what I get when I try to do so: -bash-3.2$ /usr/sbin/sogo-tool remove-doubles dbrooks personal Mar 22 13:36:43 sogo-tool [16656]: [ERROR] 0x0x808fa98[GCSFolder] -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL SELECT b.c_name,a.c_givenname,a.c_cn,a.c_sn,a.c_screenname,a.c_l,a.c_mail,a.c_o,a.c_ou,b.c_telephoneNumber,b.c_content,b.c_version,b.c_creationdate,b.c_lastmodified FROM sogodbrooks0022dd33700_quick a, sogodbrooks0022dd33700 b WHERE (c_component = vcard) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL): MySQL4Exception: 0x7f8bb38 NAME:ExecutionFailed REASON:Unknown column b.c_telephoneNumber in field list Unable to fetch required fields from folder. I am running it as the sogo user but that looks like a mysql error to me. What can I do to fix this? -- Donny B.