View Issue Details

IDProjectCategoryView StatusLast Update
0004322SOGoBackend Address Bookpublic2017-10-24 14:22
ReporterMarcel Assigned Tofrancis  
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Versionnightly master 
Fixed in Version4.0.0 
Summary0004322: Cannot enter vCard mailing list with multiple recipients: Postgres "ERROR: value too long for type character varying(255)"
Description

Trying to create a mail group of a dozen or more entries in Evolution will result in (sogo.log):

Oct 24 09:14:45 sogod [1635]: <0x7f01d2da6ca0[SOGoContactGCSEntry]:E990D258-6488C47D-54ACDE5D.vcf> TODO: implement if-none-match for etag: '*'
Oct 24 09:14:45 sogod [1635]: <0x0x7f01d2fc2600[GCSFolder]> ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:]): cannot insert content : <PostgreSQL72Exception: 0x7f01d3590be0> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x7f01d2f98d60[PostgreSQL72Channel]: connection=<0x0x7f01d2f45a40[PGConnection]: connection=0x0x7f01d2f67b00>>): ERROR: value too long for type character varying(255)

The problem is in the following SQL statement (postgresql.log with statements):

2017-10-24 09:14:45 CEST ERROR: value too long for type character varying(255)
2017-10-24 09:14:45 CEST STATEMENT: INSERT INTO sogomarcel001024c7f3e_quick (c_cn, c_component, c_screenname, c_sn, c_name, c_categories, c_ou, c_o, c_mail, c_givenName) VALUES ('MailGroup', 'vcard', '', '', 'E990D258-6488C47D-54ACDE5D.vcf', null, '', '', 'Recipient One <recipient.one@example.org>, Recipient Two <recipient.two@example.org>, …', 'MailGroup')

c_mail exceeds 255 characters. It would be necessary to chose a larger data type or not store this information in the _quick database.

Steps To Reproduce
  • Start Evolution
  • "New Contact List"
  • select a CardDAV store backed by SOGo
  • enter >255 chars worth of email addresses
  • "save"
  • error 500
Additional Information

I have not run "sql-update-3.0.0-to-combined.sh", but I guess it would not make a difference in this case.

TagsCardDAV, vCard

Activities

Marcel

Marcel

2017-10-24 08:30

reporter   ~0012397

Probably not related to 000027

francis

francis

2017-10-24 08:42

administrator   ~0012398

The c_mail field of the contacts quick tables should be extend from varchar(255) to "text".

Marcel

Marcel

2017-10-24 12:45

reporter   ~0012399

This can be done easily by the admin in the nine-table variant, but is hard to do in the dynamic table variant. Will you change code and/or inform users?

francis

francis

2017-10-24 14:22

administrator   ~0012400

Please try the next nightly build and run Scripts/sql-update-3.2.10_to_3.3.0.sh

Related Changesets

sogo: master f5aeed44

2017-10-24 14:19:25

francis

Details Diff
Increase mail column size of Contacts quick tables

Fixes 0004322
Affected Issues
0004322
mod - SOPE/GDLContentStore/contact-oracle.ocs Diff File
mod - SOPE/GDLContentStore/contact.ocs Diff File
mod - Scripts/sql-update-3.2.10_to_3.3.0-mysql.sh Diff File
add - Scripts/sql-update-3.2.10_to_3.3.0.sh Diff File

Issue History

Date Modified Username Field Change
2017-10-24 08:27 Marcel New Issue
2017-10-24 08:28 Marcel Tag Attached: CardDAV
2017-10-24 08:29 Marcel Tag Attached: vCard
2017-10-24 08:30 Marcel Note Added: 0012397
2017-10-24 08:42 francis Note Added: 0012398
2017-10-24 12:45 Marcel Note Added: 0012399
2017-10-24 14:20 francis Changeset attached => sogo master f5aeed44
2017-10-24 14:20 francis Assigned To => francis
2017-10-24 14:20 francis Resolution open => fixed
2017-10-24 14:22 francis Note Added: 0012400
2017-10-24 14:22 francis Status new => resolved
2017-10-24 14:22 francis Fixed in Version => 4.0.0