Scalable OGo (SOGo)

View Issue Details Jump to Notes ] Related Changesets ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0004322SOGoBackend Address Bookpublic2017-10-24 08:272017-10-24 14:22
ReporterMarcel 
Assigned Tofrancis 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Versionnightly v3 
Target VersionFixed in Version3.2.11 
Summary0004322: Cannot enter vCard mailing list with multiple recipients: Postgres "ERROR: value too long for type character varying(255)"
DescriptionTrying 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 InformationI 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
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0012397)
Marcel (reporter)
2017-10-24 08:30

Probably not related to 000027
User avatar (0012398)
francis (administrator)
2017-10-24 08:42

The c_mail field of the contacts quick tables should be extend from varchar(255) to "text".
(0012399)
Marcel (reporter)
2017-10-24 12:45

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?
User avatar (0012400)
francis (administrator)
2017-10-24 14:22

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

- Related Changesets
sogo: master f5aeed44
Timestamp: 2017-10-24 14:19:25
Author: francis
Details ] Diff ]
Increase mail column size of Contacts quick tables

Fixes 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 => 3.2.11


Copyright © 2000 - 2017 MantisBT Team
Powered by Mantis Bugtracker