Re: [SOGo] Can not create contacts in address book
Hi, seems like this issue was totally my fault in the end :( Prior to switching to using the nightly builds for Debian last year I tried to set up SOGo from sources. Seems like when switching I missed cleaning up leftovers from /usr/local and for some reason it seems like the current Debian package installation decided to use some of the files in there resulting in this issue. Anyway, it's all working again now and I'm back at using this great product :) Regards, Chris Am 07.07.2018 um 17:44 schrieb Christian Illy (christ...@illy.bz): Hi Chris, first of all thanks for your feedback :) - I wouldn't use a nightly build. I don't really have a choice due to the licensing model SOGo uses these days. I would like to support the development but I'm only hosting this for my family and I can't really spend 700 € per year for that ;) - Seems to be a similar issue like in https://sogo.nu/bugs/view.php?id=4418. Yeah, found that ticket when searching for the issue before posting here (and also https://sogo.nu/bugs/view.php?id=4442 ). Unfortunately neither seemed to apply to my situation as I did make sure the database schema does match as explained in those two, both by running the very latest sql-update-3.2.10_to_4.0.0-mysql.sh script as well as manually looking at the tables. Also made sure all the packages are up to date and no old stuff (pre SOGo 3) left installed. - Why don't you restore the last working backup? Sogo and database? Might help but would scratch any calendar data changes that happened afterwards. Would be really nice to just know what's wrong here and fix it instead :) Regards, Chris -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can not create contacts in address book
Hi Chris, first of all thanks for your feedback :) - I wouldn't use a nightly build. I don't really have a choice due to the licensing model SOGo uses these days. I would like to support the development but I'm only hosting this for my family and I can't really spend 700 € per year for that ;) - Seems to be a similar issue like in https://sogo.nu/bugs/view.php?id=4418. Yeah, found that ticket when searching for the issue before posting here (and also https://sogo.nu/bugs/view.php?id=4442 ). Unfortunately neither seemed to apply to my situation as I did make sure the database schema does match as explained in those two, both by running the very latest sql-update-3.2.10_to_4.0.0-mysql.sh script as well as manually looking at the tables. Also made sure all the packages are up to date and no old stuff (pre SOGo 3) left installed. - Why don't you restore the last working backup? Sogo and database? Might help but would scratch any calendar data changes that happened afterwards. Would be really nice to just know what's wrong here and fix it instead :) Regards, Chris -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Can not create contacts in address book
Hi,
can really no one help me with this issue?
Regards,
Chris
Am 27.06.2018 um 19:28 schrieb Christian Illy (christ...@illy.bz):
Hi,
since yesterday I got the issue that has popped up once or twice
regarding not being able to create contacts.
For what happened:
I created a new address book and shared it with another account. Then I
tried to create a contact from Thunderbird in that new address book and
that one showed up in the "collected addresses" book in the web
interface instead of the actual new one.
Then I tried to create a contact (again in the new book) from the web
interface and nothing happened.
Since that moment I wasn't able to create any contact in any address
book, neither from the web interface nor from Thunderbird.
What I tried so far:
Was running SOGo nightly 3.2.10.20180128-1. Manually added
c_hascertificate (int(11), null, default=0) to the new address book's
MySQL table, all others already had this. Did not help. Updated SOGo to
4.0.0.20180627-1 and also reran the sql-update-3.2.10_to_4.0.0-mysql.sh
script and even rebooted the server (as I was in doubt if anything else
but SOGo or memcached could cache some information).
Current output of the specific address book table ("explain
sogochristia001094804ad_quick"):
c_name varchar(255) NO PRI NULL
c_givenname varchar(255) YES NULL
c_cn varchar(255) YES NULL
c_sn varchar(255) YES NULL
c_screenname varchar(255) YES NULL
c_l varchar(255) YES NULL
c_mail text YES NULL
c_o varchar(255) YES NULL
c_ou varchar(255) YES NULL
c_telephonenumber varchar(255) YES NULL
c_categories varchar(255) YES NULL
c_component varchar(10) NO NULL
c_hascertificate int(11) YES 0
Attached part of the log file that shows one of the attempts to add a
contact. Same (with different table name of course) for other address
books.
Any ideas what else might be wrong or what I could try to fix it? Will
gladly provide any other information that might help :)
Regards,
Chris
--
users@sogo.nu
https://inverse.ca/sogo/lists
[SOGo] Can not create contacts in address book
Hi,
since yesterday I got the issue that has popped up once or twice
regarding not being able to create contacts.
For what happened:
I created a new address book and shared it with another account. Then I
tried to create a contact from Thunderbird in that new address book and
that one showed up in the "collected addresses" book in the web
interface instead of the actual new one.
Then I tried to create a contact (again in the new book) from the web
interface and nothing happened.
Since that moment I wasn't able to create any contact in any address
book, neither from the web interface nor from Thunderbird.
What I tried so far:
Was running SOGo nightly 3.2.10.20180128-1. Manually added
c_hascertificate (int(11), null, default=0) to the new address book's
MySQL table, all others already had this. Did not help. Updated SOGo to
4.0.0.20180627-1 and also reran the sql-update-3.2.10_to_4.0.0-mysql.sh
script and even rebooted the server (as I was in doubt if anything else
but SOGo or memcached could cache some information).
Current output of the specific address book table ("explain
sogochristia001094804ad_quick"):
c_name varchar(255)NO PRI NULL
c_givenname varchar(255)YES NULL
c_cnvarchar(255)YES NULL
c_snvarchar(255)YES NULL
c_screennamevarchar(255)YES NULL
c_l varchar(255)YES NULL
c_mail textYES NULL
c_o varchar(255)YES NULL
c_ouvarchar(255)YES NULL
c_telephonenumber varchar(255)YES NULL
c_categoriesvarchar(255)YES NULL
c_component varchar(10) NO NULL
c_hascertificateint(11) YES 0
Attached part of the log file that shows one of the attempts to add a
contact. Same (with different table name of course) for other address books.
Any ideas what else might be wrong or what I could try to fix it? Will
gladly provide any other information that might help :)
Regards,
Chris
--
users@sogo.nu
https://inverse.ca/sogo/listsJun 27 15:54:10 sogod [786]: [ERROR] <0x0x564891b51af0[GCSFolder]> -[GCSFolder _generateInsertStatementForRow:adaptor:tableName:]: no type found for column name c_hascertificate
2018-06-27 15:54:10.222 sogod[786:786] SQL: INSERT INTO sogochristia001094804ad_quick (c_cn, c_component, c_screenname, c_sn, c_name, c_hascertificate, c_categories, c_ou, c_o, c_mail, c_givenName) VALUES ('tests', 'vcard', '', '', '312-5B339700-1-6B6BE780.vcf', null, '', '', null, '');
2018-06-27 15:54:10.222 sogod[786:786]ERROR: Column count doesn't match value count at row 1
2018-06-27 15:54:10.223 sogod[786:786] SQL: ROLLBACK;
2018-06-27 15:54:10.223 sogod[786:786]query has no results.
2018-06-27 15:54:10.223 sogod[786:786] SQL: ROLLBACK;
2018-06-27 15:54:10.223 sogod[786:786]query has no results.
Jun 27 15:54:10 sogod [786]: <0x0x564891b51af0[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : NAME:ExecutionFailed REASON:Column count doesn't match value count at row 1
