General discussion on installation and configuration of SOGo

Text archives Help


Re: [SOGo] Can not create contacts in address book


Chronological Thread 
  • From: "Christian Illy" ( ) < >
  • To: "Christian Illy ( )" < >
  • Subject: Re: [SOGo] Can not create contacts in address book
  • Date: Sun, 1 Jul 2018 18:38:24 +0200
  • Dmarc-filter: OpenDMARC Filter v1.2.0 mail.inverse.ca C448711CBF92

Hi,

can really no one help me with this issue?

Regards,
Chris

Am 27.06.2018 um 19:28 schrieb Christian Illy
( ):
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





Archive powered by MHonArc 2.6.18.

Top of page