Author Topic: [Solved] SOGo 4.0.0 Addressbook View  (Read 797 times)

BerT666

  • Zen Warrior
  • ***
  • Posts: 215
  • Karma: +6/-0
    • View Profile
[Solved] SOGo 4.0.0 Addressbook View
« on: April 03, 2018, 04:26:32 pm »
Hi,

I upgraded my servers this morning to Zentyal 5.1 and it looks good, only one little "problem":

When I am in SOGo, and go to the Adressbook, the entries do not show up (it looks like they are loading, and loading,...).
When I click on one of the entries, I can see it...

I tried to attached a JPG to show it, but the "upload folder" is full :-( (the green bars are moving constantly from left to right)...

Tested with the latest Version of Chrome and InternetExplorer 11.0.56

Any suggestions how to solve it?

Regards

Thomas
« Last Edit: April 09, 2018, 09:38:07 pm by BerT666 »

FoxM

  • Zen Apprentice
  • *
  • Posts: 7
  • Karma: +0/-0
    • View Profile
Re: SOGo 4.0.0 Addressbook View
« Reply #1 on: April 09, 2018, 01:31:50 am »
Hi! Try clearing cookies and browser cache.
Zentyal Development Edition 5.1.1

BerT666

  • Zen Warrior
  • ***
  • Posts: 215
  • Karma: +6/-0
    • View Profile
Re: SOGo 4.0.0 Addressbook View
« Reply #2 on: April 09, 2018, 11:36:50 am »
Clearing Cache and Cookies did not help.
Happens also when accessing from a "new / not yet used" device :-(

Regards

BerT666

  • Zen Warrior
  • ***
  • Posts: 215
  • Karma: +6/-0
    • View Profile
Re: SOGo 4.0.0 Addressbook View
« Reply #3 on: April 09, 2018, 08:29:47 pm »
ok, one little step closer...

It seems that there is something wrong in my DB :-(

found this in the sogo.log:
Code: [Select]
Apr 09 20:25:22 sogod [15673]: [ERROR] <0x0x561e165bf1d0[GCSFolder]> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, c_mail, c_telephonenumber, c_categories, c_component, c_hascertificate FROM sogothomas00344171b71_quick WHERE ((c_name = '67E4-566D7F80-47-39059140') OR (c_name = '67E4-566D7F80-4B-39059140') OR (c_name = '67E4-566D7F80-53-39059140') OR (c_name = '4C73-5718CA80-1D-141F8620') OR (c_name = '7aeae3eb-a619-4f08-99f0-f3b507de46f9vcf') OR (c_name = 'A50-593EAE80-3-BF0CEC0') OR (c_name = '6301-59DF3380-3-61E95880') OR (c_name = '2654-5A1EAC00-3-6C609F80') OR (c_name = '86c494b0-3642-492d-8daf-86d666039e17vcf') OR (c_name = '244A-5A1EAD80-7-31BAEA80') OR (c_name = '88b5ad0f-ce0c-4065-a967-cfa364d639b3.vcf') OR (c_name = 'AC6-5AB23E80-3-9086DE0') OR (c_name = 'ae5e3f60-dc4a-411e-875e-31d16381c3e9vcf') OR (c_name = 'DEE-5A379300-3-349B7280') OR (c_name = '22bf5d6f-8721-45ce-9d46-2730296a3cc1.vcf') OR (c_name = '1D40-57B1B200-5-549D8A80') OR (c_name = '2796-57E02380-27-26A19D40') OR (c_name = 'F32-58147800-5-5FD1B000') OR (c_name = '2465-58722880-1D-E8123F0') OR (c_name = '1055-58A07E80-3-1D7F2320') OR (c_name = 'F30-58AAF880-7-4FCF1400') OR (c_name = '14B1-58B82680-F-6A67D280') OR (c_name = '162B-58D01580-9-4449C300') OR (c_name = 'A8B-591D4F80-5-B136950') OR (c_name = '3486-596DC300-5-6A1E2B00') OR (c_name = 'B76-59AD5280-3-7BBE9080') OR (c_name = 'B77-59AD5C00-55-29CE1280') OR (c_name = '5C2A-59AD5E00-5-F7CF070') OR (c_name = '9e1b12a3-519a-4a8c-9182-d42340f71579.vcf') OR (c_name = '9d337043-4af2-4556-9dfb-4b882dd09dcevcf') OR (c_name = '557fd425-4d75-46e7-8fec-d3afe42930ffvcf') OR (c_name = '67E4-566D7F80-B-39059140') OR (c_name = '8b1fa045-ddce-4b63-b78e-8a00580274a5vcf') OR (c_name = '7a18cdaf-d1eb-4f26-b523-f5468fce7084vcf') OR (c_name = '3dd0f7e8-fe49-4c8d-bf4d-4a7602ffdec3vcf') OR (c_name = '67E4-566D7F80-3-39059140') OR (c_name = '40fbe5d0-b42a-4c59-87d2-b0dfa5250aeavcf') OR (c_name = '67E4-566D7F80-7-39059140') OR (c_name = 'c1dfa39d-08f9-43f5-9ee2-0133d570fe70vcf') OR (c_name = 'a65f24ed-bfda-4b32-8187-b8a4299bf643vcf') OR (c_name = 'b84b6b8a-d027-43eb-a0c2-decba5721c95vcf') OR (c_name = '694db287-8496-4500-9a34-9bf87e61b790vcf') OR (c_name = '67E4-566D7F80-5B-39059140') OR (c_name = 'fb2e57f9-b2d2-4fac-aef4-598d863dddc5vcf') OR (c_name = '1ABD-591C3780-1-6B75A000.vcf') OR (c_name = '51bedf3c-e602-4bfe-86f6-25b48389b811vcf') OR (c_name = 'F3D-58789880-1-5084C200.vcf') OR (c_name = '222F-59FD7F80-5-46649E80') OR (c_name = 'b460e453-7251-4ace-a822-2d6dafe96644.vcf') OR (c_name = '74bff492-989c-4496-922c-00f342410c52vcf') OR (c_name = 'f67befaf-cc5d-4f3e-80eb-14a07a6d90c2vcf') OR (c_name = '754d39e1-8f32-4d23-ad8d-97ef81bda322vcf') OR (c_name = 'eba7a918-a050-4362-adca-aa703600bdb5vcf') OR (c_name = 'ff273696-c3e3-4efa-8389-552a30d85205vcf') OR (c_name = '69C8-569BFC00-1-4167E400') OR (c_name = '026a528d-a95c-4e39-9035-b74c83fc2e17vcf') OR (c_name = '48dd2d72-442e-4161-9732-9b7236e03ec4vcf') OR (c_name = 'db36fa62-2747-4747-bab4-9ef4b4459a2evcf') OR (c_name = '3c96ffe7-0a98-4431-ad90-5b81dba03872vcf') OR (c_name = '8e334d32-36fa-44c1-9eee-6fc21942f092vcf') OR (c_name = '762e855f-c571-47de-8e5e-f9574d73fe6cvcf') OR (c_name = '96df4416-6394-405d-aa87-850215619015vcf') OR (c_name = '070e375a-1f23-47df-b87d-7cdb8260e6d6vcf') OR (c_name = '131794e2-d837-4015-85b4-daba1338371dvcf') OR (c_name = '139cdc9c-49d9-4ce6-a276-fa7a33e5e8cevcf') OR (c_name = 'c75804f1-f2c2-4b52-8873-33e857f5fd68vcf') OR (c_name = 'f6cafa06-eab3-499d-9167-9f3020f95562vcf') OR (c_name = 'ce37b561-cc9d-4081-b926-29564ec42114vcf') OR (c_name = '7514878d-cb79-49b9-9c22-7dae25d413b8vcf') OR (c_name = '13f341f0-cff9-4217-bd21-3885bd719442vcf') OR (c_name = '67E4-566D7F80-27-39059140') OR (c_name = '67E4-566D7F80-23-39059140') OR (c_name = '271C-57225900-25-448BC600') OR (c_name = 'd6c974b6-5588-44e1-8686-a65322b06be2vcf') OR (c_name = '92e03e30-b1f3-4e24-bdff-b393e9bdb35fvcf') OR (c_name = '37ad8c39-108d-4601-9579-7de7dd6e0ce5vcf') OR (c_name = 'ed93a292-8f20-4a60-bee6-e0fe9104318cvcf') OR (c_name = '67E4-566D7F80-17-39059140') OR (c_name = '67E4-566D7F80-43-39059140') OR (c_name = '9560b88c-7354-4406-a100-fa9ecd88ea07vcf') OR (c_name = '447f18ad-8692-4aad-9881-c1272f7ed980vcf') OR (c_name = '6c4a2cfb-0184-4c2e-a783-66d201330b51vcf') OR (c_name = '183d806d-12ab-4d4b-890b-ce430c2323f6vcf') OR (c_name = 'F31-5875F780-B-2B6B2D40') OR (c_name = 'a6a9a68d-9c05-48c4-96ee-67ee7c6637f2vcf') OR (c_name = 'b2c3e7c3-62c7-43a3-a37e-ce623ccb9726vcf') OR (c_name = '6757a15b-cb98-4425-94ef-a506d5e9d6bcvcf') OR (c_name = 'a4dc8047-4cd6-402d-a229-de61914a5ebcvcf') OR (c_name = '52182cf3-8065-46c2-bc1a-7231ae081685vcf') OR (c_name = '67E4-566D7F80-37-39059140') OR (c_name = '35c9d333-2a52-4a61-8d37-c2fc9a7e36e6vcf') OR (c_name = '62efc511-95e9-43f5-b03e-fa0a9d63704evcf') OR (c_name = '67E4-566D7F80-33-39059140') OR (c_name = '67E4-566D7F80-2B-39059140') OR (c_name = '71036ee8-6bc0-4328-bc86-1412f7110d3evcf') OR (c_name = '87558a16-9acb-41a4-a2b0-c53e2c2f7044vcf') OR (c_name = '91d7d299-84f8-4d3f-bf1f-c023177c6e57vcf'))': <MySQL4Exception: 0x561e169062d0> NAME:ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'

Any ideas (besides recreating the adressbook(s) )?

Regards

Thomas

EDIT:
solved ;-) looks like the SOGo-DB-Updatescript did not run (correctly)...

/usr/share/doc/sogo/sql-update-3.2.10_to_4.0.0-mysql.sh did the trick ;-)
« Last Edit: April 09, 2018, 09:37:30 pm by BerT666 »