General discussion on installation and configuration of SOGo

Text archives Help


[SOGo] Can not create contacts in address book


Chronological Thread 
  • From: "Christian Illy" ( ) < >
  • To:
  • Subject: [SOGo] Can not create contacts in address book
  • Date: Wed, 27 Jun 2018 19:28:58 +0200
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca D8789108601D

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


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





  • [SOGo] Can not create contacts in address book, Christian Illy, 06/27/2018

Archive powered by MHonArc 2.6.18.

Top of page