Meanwhile i downgraded sogo to sogo 2.3.4 again but the same effect.
Where do I find the databaseupdate for 2.3 to make SOGo calender workiong again?
Greetings
Daniel
Gesendet: Montag, 18. Januar 2016 um 16:56 Uhr
Von: "Christian Mack" <[email protected]>
An: [email protected]
Betreff: Re: [SOGo] No Calender working after updating from SOGo 2.3.4 to SOGo 2.3.5
Von: "Christian Mack" <[email protected]>
An: [email protected]
Betreff: Re: [SOGo] No Calender working after updating from SOGo 2.3.4 to SOGo 2.3.5
Am 18.01.2016 um 14:07 schrieb "Daniel Müller":
> Dear all,
>
> after updatiing SOGo to 2.3.5 I can not add any item to my calender, below the error. Is there any special database update?
>
>
> Jan 18 14:01:10 sogod [31275]: [ERROR] <0x0x7f8749f6aea8[GCSFolder]> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogomueller001433769ec_quick a, sogomueller001433769ec b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1453589999)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1452985200)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <PostgreSQL72Exception: 0x7f874a044508> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x7f8748cb4348[PostgreSQL72Channel]: connection=<0x0x7f87492d2f98[PGCo
nnection]: connection=0x0x7f87491b5eb0>>): FEHLER: Spalte a.c_description existiert nicht
> ZEILE 1: ..._priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_descri...
> ^
>
> Jan 18 14:01:10 sogod [31275]: [ERROR] <0x4A022BF8[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed!
> Jan 18 14:01:10 sogod [31275]: 192.168.135.39 "POST /SOGo/so/mueller/Calendar/eventsblocks?sd=20160117&ed=20160123&view=weekview HTTP/1.1" 200 64/0 0.006 - - 0
>
There was a database update for SOGo 2.3.0.
That was the last one.
Kind regards,
Christian Mack
--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416
> Dear all,
>
> after updatiing SOGo to 2.3.5 I can not add any item to my calender, below the error. Is there any special database update?
>
>
> Jan 18 14:01:10 sogod [31275]: [ERROR] <0x0x7f8749f6aea8[GCSFolder]> -[GCSFolder fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL 'SELECT b.c_name,b.c_content,b.c_creationdate,b.c_lastmodified,b.c_version,a.c_component,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_category,a.c_classification,a.c_isallday,a.c_isopaque,a.c_participants,a.c_partmails,a.c_partstates,a.c_sequence,a.c_priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_description,a.c_uid,a.c_startdate,a.c_enddate FROM sogomueller001433769ec_quick a, sogomueller001433769ec b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1453589999)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1452985200)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <PostgreSQL72Exception: 0x7f874a044508> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x7f8748cb4348[PostgreSQL72Channel]: connection=<0x0x7f87492d2f98[PGCo
nnection]: connection=0x0x7f87491b5eb0>>): FEHLER: Spalte a.c_description existiert nicht
> ZEILE 1: ..._priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_descri...
> ^
>
> Jan 18 14:01:10 sogod [31275]: [ERROR] <0x4A022BF8[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): fetch failed!
> Jan 18 14:01:10 sogod [31275]: 192.168.135.39 "POST /SOGo/so/mueller/Calendar/eventsblocks?sd=20160117&ed=20160123&view=weekview HTTP/1.1" 200 64/0 0.006 - - 0
>
There was a database update for SOGo 2.3.0.
That was the last one.
Kind regards,
Christian Mack
--
Christian Mack
Universität Konstanz
Kommunikations-, Informations-, Medienzentrum (KIM)
Abteilung Basisdienste
78457 Konstanz
+49 7531 88-4416
