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
--
[email protected]
https://inverse.ca/sogo/lists
Jun 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] <MySQL4Channel[0x0x5648913564f0] connection=0x0x564891667b48> 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] <MySQL4Channel[0x0x5648913564f0] connection=0x0x564891667b48> ERROR: Column count doesn't match value count at row 1
2018-06-27 15:54:10.223 sogod[786:786] <MySQL4Channel[0x0x564891718e50] connection=0x0x564891604958> SQL: ROLLBACK;
2018-06-27 15:54:10.223 sogod[786:786] <MySQL4Channel[0x0x564891718e50] connection=0x0x564891604958> query has no results.
2018-06-27 15:54:10.223 sogod[786:786] <MySQL4Channel[0x0x5648913564f0] connection=0x0x564891667b48> SQL: ROLLBACK;
2018-06-27 15:54:10.223 sogod[786:786] <MySQL4Channel[0x0x5648913564f0] connection=0x0x564891667b48> query has no results.
Jun 27 15:54:10 sogod [786]: <0x0x564891b51af0[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <MySQL4Exception: 0x564891ab9cd0> NAME:ExecutionFailed REASON:Column count doesn't match value count at row 1
