View Issue Details
|ID||Project||Category||View Status||Date Submitted||Last Update|
|0001339||SOGo||Apple iPhone OS||public||2011-06-15 08:57||2011-12-30 19:42|
|Target Version||1.3.12||Fixed in Version||1.3.12|
|Summary||0001339: Photo problem on iPhone|
When a photo is attached to a contact on the iPhone contact sync failed from then on and will not be synced again untill the photo is removed from the contact. The error in the logs looks like this
Jun 15 10:44:56 sogod : [ERROR] <0x09BCE868[SOGoContactGCSEntry]:C4C40B0C-73E0-0001-F24B-1F9E11001FA6.vcf> write failed: <PostgreSQL72Exception: 0x96b5550> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x943de68[PostgreSQL72Channel]: connection=<0x0x97715f0[PGConnection]: connection=0x0x9a43190>>): ERROR: value too long for type character varying(100000)
This is due to the photo being to big to fit in the column c_content. This column is of type character varying(100000), thus 100 kB is reserved for the contact VCARD which includes also the photo data. In this case the photo is jpeg data so it's possible that it doens't always fail depending on the amount of compression done on the jpeg. But most photos I attached to a contact on the iPhone were about 150kB in size in the VCARD data.
imo there are 2 ways to fix this.
For people who are having these problems with contacts, you can actually easily manually change this through eg. pgadmin (in case of postgresql) or phpmyadmin (incase of mySQL).
It works for me by setting the type to text.
|Tags||No tags attached.|
|2011-06-15 08:57||mzeedijk||New Issue|
|2011-12-12 18:31||francis||Target Version||=> 1.3.12|
|2011-12-30 19:42||ludovic||Note Added: 0003242|
|2011-12-30 19:42||ludovic||Status||new => resolved|
|2011-12-30 19:42||ludovic||Fixed in Version||=> 1.3.12|
|2011-12-30 19:42||ludovic||Resolution||open => fixed|
|2011-12-30 19:42||ludovic||Assigned To||=> ludovic|
|2011-12-30 19:42||ludovic||Status||resolved => closed|