View Issue Details

IDProjectCategoryView StatusLast Update
0001848SOGoBackend Calendarpublic2012-07-18 15:38
ReporterDavid Assigned Tojraby 
PrioritynormalSeveritymajorReproducibilityalways
Status resolvedResolutionfixed 
Product Version1.3.16 
Target Version1.3.17 
Summary0001848: Recurrent event can not be edited
Description

When deleting single occurrence of recurrent event nothing happens.

Additional Information

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

TagsNo tags attached.

Relationships

related to 0001712 closed proxy error when editing an occurance of a recurring event 

Activities

2012-06-21 10:41

 

event.ics (4,106 bytes)
Christian Mack

Christian Mack

2012-06-22 08:58

developer   ~0004086

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?

David

David

2012-06-25 12:31

reporter   ~0004090

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.

jraby

jraby

2012-07-18 15:38

viewer   ~0004173

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.

Issue History

Date Modified Username Field Change
2012-06-21 10:41 David New Issue
2012-06-21 10:41 David File Added: event.ics
2012-06-22 08:58 Christian Mack Note Added: 0004086
2012-06-25 12:31 David Note Added: 0004090
2012-06-27 13:09 francis Target Version => 1.3.17
2012-07-13 17:56 ludovic Status new => assigned
2012-07-13 17:56 ludovic Assigned To => jraby
2012-07-18 15:38 jraby Note Added: 0004173
2012-07-18 15:38 jraby Status assigned => resolved
2012-07-18 15:38 jraby Resolution open => fixed
2012-07-23 13:38 ludovic Relationship added related to 0001712