View Issue Details

IDProjectCategoryView StatusLast Update
0004520SOGoBackend Address Bookpublic2022-05-30 18:40
ReporterMagnus Assigned To 
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionfixed 
Platform[Server] LinuxOSDebianOS Version8 (Jessie)
Product Version4.0.1 
Summary0004520: Unable to add new Contact to PGSQL-Backend.
Description

When creating a new contact, the following error occurs

=sogo.log=

Aug 05 21:13:07 sogod [3575]: [ERROR] <0x7fc2346dd150[SOGoContactGCSEntry]:dd3c07b7-7fff-****-9c4b-67ad255f7d1f.vcf> write failed: <PostgreSQL72Exception: 0x7fc2345e2680> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x7fc2345e8d80[PostgreSQL72Channel]: connection=<0x0x7fc2345e8e50[PGConnection]: connection=0x0x7fc2345aab00>>): ERROR: INSERT has more target columns than expressions
LINE 1: ...telephonenumber, c_categories, c_ou, c_o, c_mail, c_givenNam...

=postgresql-log=

sogo@sogo ERROR: INSERT has more target columns than expressions at character 159
sogo@sogo STATEMENT: INSERT INTO sogo**_quick (c_cn, c_component, c_screenname, c_sn, c_name, c_hascertificate, c_telephonenumber, c_categories, c_ou, c_o, c_mail, c_givenName) VALUES ('Anton Berta', 'vcard', '', 'Berta', 'dd3c07b7-7fff-****-9c4b-67ad255f7d1f.vcf', '789456', null, '', '', null, 'Anton')

Possible reason:
==> INSERT query defines 12 columns but gives only 11 values
==> Probably the new column "c_hascertificate" is omitted in the list of values
==> Maybe the same reason as for bug 0004442

Steps To Reproduce

Add a new contact via Web-Interface or CardDAV-Client

Problem occurs since update to SOGo v4.0.0

TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2018-08-05 19:49 Magnus New Issue
2022-05-30 18:40 francis Status new => closed
2022-05-30 18:40 francis Resolution open => fixed