View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0004374SOGoBackend Address Bookpublic2018-01-15 14:132018-01-17 11:28
Reportermmccarn Assigned Tofrancis  
PrioritynormalSeveritymajorReproducibilityalways
Status closedResolutionno change required 
Platform[Server] LinuxOSRHEL/CentOSOS Version6
Product Version3.2.10 
Summary0004374: Contacts is looking for a field named "c_hascertficicate" that does not exist
Description
  • Activesync fails for contacts
  • Selecting "Address Book" in web interface displays a loading screen forever
  • Log file shows errors like:

[ERROR] <0x0x7f169d3b25b8[GCSFolder]> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SEL
ECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, c_mail, c_telephonenumber, c_categories, c_component, c_hascertificate FROM sogommccarn00203a16790_quick WH
ERE ((c_name = '2D14-58D6F900-1-58B4EC80.vcf') OR (c_name = '9A7-59830A80-1-20414D00.vcf') OR (c_name = '991-59C18C80-1-325F5D80.vcf') OR (c_name = '56CC-59B86600-
1-4098BE0.vcf') OR (c_name = '9A4-5981E100-5-2A707140.vcf'))': <MySQL4Exception: 0x7f169c4641a8> NAME:ExecutionFailed REASON:Unknown column 'c_hascertificate' in '
field list'
Jan 15 07:33:47 sogod [2757]: 192.168.200.110 "POST /SOGo/so/mmccarn/Contacts/personal/view HTTP/1.1" 200 392/46 0.052 - - 20K
Jan 15 07:33:48 sogod [2757]: [ERROR] <0x0x7f169c488578[GCSFolder]> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SEL
ECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, c_mail, c_telephonenumber, c_categories, c_component, c_hascertificate FROM sogommccarn00203a16790_quick WH
ERE (c_name = '9A4-5981E100-5-2A707140.vcf')': <MySQL4Exception: 0x7f169cdc8988> NAME:ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'
Jan 15 07:33:48 sogod [2757]: 192.168.200.110 "POST /SOGo/so/mmccarn/Contacts/personal/headers HTTP/1.1" 200 2/39 0.015 - - 0
Jan 15 07:33:48 sogod [2757]: [ERROR] <0x0x7f169cde6cd8[GCSFolder]> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SEL
ECT c_name, c_cn, c_givenname, c_sn, c_screenname, c_o, c_mail, c_telephonenumber, c_categories, c_component, c_hascertificate FROM sogommccarn00203a16790_quick WH
ERE ((c_name = '2D14-58D6F900-1-58B4EC80.vcf') OR (c_name = '9A7-59830A80-1-20414D00.vcf') OR (c_name = '991-59C18C80-1-325F5D80.vcf') OR (c_name = '56CC-59B86600-
1-4098BE0.vcf'))': <MySQL4Exception: 0x7f169bedf148> NAME:ExecutionFailed REASON:Unknown column 'c_hascertificate' in 'field list'

Steps To Reproduce
  1. Install Sogo3.2.10 sogo-3.2.10.20180111-1.centos6.x86_64
  2. Login to sogo
  3. Click on 'Address Book'
Additional Information

Running this script adds the missing field, fixes the error with "Address Book", and does not appear to introduce any new errors:

/usr/share/doc/sogo-3.2.10.20180111/sql-update-3.2.10_to_4.0.0-mysql.sh

TagsNo tags attached.

Activities

Christian Mack

Christian Mack

2018-01-17 10:50

developer   ~0012512

You always have to run the new/additional database update script after updating SOGo.
That is also hinted on the command line, when updating.

Therefore this is no error on the SOGo side.

The only thing you could argue is, that the documentation for the released version is not yet updated.
But you are using a nightly build, therefore that change didn't happen in the release yet.

Issue History

Date Modified Username Field Change
2018-01-15 14:13 mmccarn New Issue
2018-01-17 10:50 Christian Mack Note Added: 0012512
2018-01-17 11:28 francis Status new => closed
2018-01-17 11:28 francis Assigned To => francis
2018-01-17 11:28 francis Resolution open => no change required