SOGo - BTS - SOGo
View Issue Details
0001848SOGoBackend Calendarpublic2012-06-21 06:412012-07-18 11:38
David 
jraby 
normalmajoralways
resolvedfixed 
1.3.16 
1.3.17 
0001848: Recurrent event can not be edited
When deleting single occurrence of recurrent event nothing happens.
Event attached

SOGo log presents this:

localhost.localdomain - - [21/Jun/2012:12:01:04 GMT] "GET /SOGo/so/don.joe/Calendar/alice_personal/8F6-4BBDDB00-1A3-266E6E40/edit HTTP/1.1" 200 10467/0 0.183 31382 66% 80K
2012-06-21 12:01:07.917 sogod[6997] WARNING(-[NSNull(misc) count]): called NSNull -count (returns 0) !!!
localhost.localdomain - - [21/Jun/2012:12:01:07 GMT] "GET /SOGo/so/don.joe/Calendar/editRecurrence HTTP/1.1" 200 9777/0 0.082 31507 68% 0
Jun 21 12:01:13 sogod [6997]: <0x0xfdab208[GCSFolder]> ERROR(-[GCSFolder writeContent:toName:baseVersion:]): cannot update content : <PostgreSQL72Exception: 0x10210338> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0xfbc3018[PostgreSQL72Channel]: connection=<0x0xfbcb828[PGConnection]: connection=0x0xfdc27c0>>): ERROR: value too long for type character varying(1000)
Jun 21 12:01:13 sogod [6997]: [ERROR] <0x10356258[SOGoAppointmentObject]:8F6-4BBDDB00-1A3-266E6E40> write failed: <PostgreSQL72Exception: 0x10210338> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0xfbc3018[PostgreSQL72Channel]: connection=<0x0xfbcb828[PGConnection]: connection=0x0xfdc27c0>>): ERROR: value too long for type character varying(1000)
localhost.localdomain - - [21/Jun/2012:12:01:13 GMT] "POST /SOGo/so/don.joe/Calendar/alice_personal/8F6-4BBDDB00-1A3-266E6E40/saveAsAppointment HTTP/1.1" 200 21/807 0.082 - - 60K
No tags attached.
related to 0001712closed  proxy error when editing an occurance of a recurring event 
? event.ics (4,106) 2012-06-21 06:41
https://sogo.nu/bugs/file_download.php?file_id=639&type=bug
Issue History
2012-06-21 06:41DavidNew Issue
2012-06-21 06:41DavidFile Added: event.ics
2012-06-22 04:58Christian MackNote Added: 0004086
2012-06-25 08:31DavidNote Added: 0004090
2012-06-27 09:09francisTarget Version => 1.3.17
2012-07-13 13:56ludovicStatusnew => assigned
2012-07-13 13:56ludovicAssigned To => jraby
2012-07-18 11:38jrabyNote Added: 0004173
2012-07-18 11:38jrabyStatusassigned => resolved
2012-07-18 11:38jrabyResolutionopen => fixed
2012-07-23 09:38ludovicRelationship addedrelated to 0001712

Notes
(0004086)
Christian Mack   
2012-06-22 04:58   
connection=<0x0xfbcb828[PGConnection]: connection=0x0xfdc27c0>>): ERROR: value too long for type character varying(1000)

Seems this event contains a really large text value (description?), which is too large for the corresponding postgres database field (1000 characters max).

Could you check this event via sogo-tool?
Or look into the postgres logs for the corresponding update?
(0004090)
David   
2012-06-25 08:31   
Honestly, I do not know what do you mean by checking via sogo-tool.

I think there's no doubt the event contains large field. As you can see from the attached event there are many date exceptions. These are being stored in database field 'c_cycleinfo'. The field is in 'sogouserxxxx_quick' table and is limited to 1000 chars (character varying(1000)). This field prevents event changes.

I already have 2 users with error like this. When it happens they are unable to
manage their event in any way. The only solution is to shorten the field 'c_cycleinfo' manually in database.
(0004173)
jraby   
2012-07-18 11:38   
I've added new scripts to the distribution: Scripts/sql-update-1.3.16_to_1.3.17*.sh

These will go through the table list and expand the c_cycleinfo column to its default size (1000000, since sogo 1.3.3).

Please note that this problem only occurs to accounts created with a really old version of sogo (pre 1.3.3). New users should already be fine.