Re: [SOGo] problem removing doubles with sogo-tool
Hi Donny On 2012-04-12, at 1:58 PM, Donny Brooks wrote: > On Tuesday, April 3, 2012 07:23 AM CDT, Francis Lachapelle > wrote: > >> Hi Roberto >> >> On 2012-03-07, at 6:25 PM, Roberto wrote: >> >> > For the first time, I'm trying to delete duplicates for a user, but I get >> > the following message: >> > >> > sogo@donfierro:~$ /usr/sbin/sogo-tool remove-doubles mperez@mydomain >> > personal >> > >> > <0x0x170f420[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 sogomperezid00179ea8c6b_quick a, sogomperezid00179ea8c6b b WHERE >> > (c_component = 'vcard') AND a.c_name = b.c_name AND (c_deleted != 1 OR >> > c_deleted IS NULL)': NAME:ExecutionFailed REASON:La columna >> > 'b.c_telephoneNumber' en field list es desconocida >> > Unable to fetch required fields from folder. >> > >> > I translate the REASON: Field 'b.c_telephoneNumer' in field list is >> > unknown. >> > >> > Any idea about what I don't have the expected table structure? >> >> It was a bug. The character case was inconsistent. I just fixed it in >> revision 73baf2c24acbb1fb98296fc8ab448b3b3c5ba7a7. >> >> Thanks, >> >> Francis > Francis, > > This fix should be included in the next release correct? Or is there a > way I can patch our system in the meantime? We have a number of users that > have duplicate entries and we would like to clean them up without having to > go through manually. Grab the sogo-tool package from the nightly builds (2.0 branch). Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] problem removing doubles with sogo-tool
On Tuesday, April 3, 2012 07:23 AM CDT, Francis Lachapelle wrote: Hi Roberto On 2012-03-07, at 6:25 PM, Roberto wrote: > For the first time, I'm trying to delete duplicates for a user, but I get the following message: > > sogo@donfierro:~$ /usr/sbin/sogo-tool remove-doubles mperez@mydomain personal > > <0x0x170f420[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 sogomperezid00179ea8c6b_quick a, sogomperezid00179ea8c6b b WHERE (c_component = 'vcard') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': NAME:ExecutionFailed REASON:La columna 'b.c_telephoneNumber' en field list es desconocida > Unable to fetch required fields from folder. > > I translate the REASON: Field 'b.c_telephoneNumer' in field list is unknown. > > Any idea about what I don't have the expected table structure? It was a bug. The character case was inconsistent. I just fixed it in revision 73baf2c24acbb1fb98296fc8ab448b3b3c5ba7a7. Thanks, Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists Francis, This fix should be included in the next release correct? Or is there a way I can patch our system in the meantime? We have a number of users that have duplicate entries and we would like to clean them up without having to go through manually. -- Donny B.
Re: [SOGo] problem removing doubles with sogo-tool
Hi Roberto On 2012-03-07, at 6:25 PM, Roberto wrote: > For the first time, I'm trying to delete duplicates for a user, but I get the > following message: > > sogo@donfierro:~$ /usr/sbin/sogo-tool remove-doubles mperez@mydomain personal > > <0x0x170f420[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 sogomperezid00179ea8c6b_quick a, sogomperezid00179ea8c6b b WHERE > (c_component = 'vcard') AND a.c_name = b.c_name AND (c_deleted != 1 OR > c_deleted IS NULL)': NAME:ExecutionFailed > REASON:La columna 'b.c_telephoneNumber' en field list es desconocida > Unable to fetch required fields from folder. > > I translate the REASON: Field 'b.c_telephoneNumer' in field list is unknown. > > Any idea about what I don't have the expected table structure? It was a bug. The character case was inconsistent. I just fixed it in revision 73baf2c24acbb1fb98296fc8ab448b3b3c5ba7a7. Thanks, Francis -- flachape...@inverse.ca :: +1.514.755.3640 :: http://www.inverse.ca Inverse :: Leaders behind SOGo (http://sogo.nu) and PacketFence (http://packetfence.org) -- users@sogo.nu https://inverse.ca/sogo/lists
Re: MySQL structure verification / Was Re: [SOGo] problem removing doubles with sogo-tool
On 2012-03-14 20:46, robe...@indomitux.com.ar wrote: > El 07/03/12 20:25, Roberto escribió: > >> I translate the REASON: Field 'b.c_telephoneNumer' in field list is > unknown. >> >> Any idea about what I don't have the expected table structure? > > Dear people, > > Any ideas of how may I verify SOGo's MySQL database structure? > How about: mysqldump -u sogo -p -h localhost --no-data --databases sogo >db_dump.sql Kind regards, Christian Mack -- Christian Mack Gruppe Informationsdienste Rechenzentrum Universität Konstanz -- users@sogo.nu https://inverse.ca/sogo/lists
MySQL structure verification / Was Re: [SOGo] problem removing doubles with sogo-tool
El 07/03/12 20:25, Roberto escribió: > I translate the REASON: Field 'b.c_telephoneNumer' in field list is unknown. > > Any idea about what I don't have the expected table structure? Dear people, Any ideas of how may I verify SOGo's MySQL database structure? TIA, -- roberto -- users@sogo.nu https://inverse.ca/sogo/lists
[SOGo] problem removing doubles with sogo-tool
Hi, For the first time, I'm trying to delete duplicates for a user, but I get the following message: sogo@donfierro:~$ /usr/sbin/sogo-tool remove-doubles mperez@mydomain personal <0x0x170f420[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 sogomperezid00179ea8c6b_quick a, sogomperezid00179ea8c6b b WHERE (c_component = 'vcard') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': NAME:ExecutionFailed REASON:La columna 'b.c_telephoneNumber' en field list es desconocida Unable to fetch required fields from folder. I translate the REASON: Field 'b.c_telephoneNumer' in field list is unknown. Any idea about what I don't have the expected table structure? TIA, -- roberto -- users@sogo.nu https://inverse.ca/sogo/lists