Good day Daniel,
What if you create the missing field "c_description" in the table
"sogomueller001433769ec_quick" ?
ALTER TABLE sogomueller001433769ec_quick ADD COLUMN c_description text;
Normally, the field is created by SOGo when you add your first event.
It works under SOGo 2.3.4, centOS 6.7, PGSQL 9.4.
Julien PAQUIT // 07 82 455 855
DATABEILLE, Votre Architecte de Données
www.databeille.com
Le 19/01/2016 08:59, "Daniel Müller" a écrit :
No Idea?
If I change to my Calender in the web gui this error is written to the
log-file:
Jan 19 08:57:44 sogod [17844]: [ERROR] <0x0x7ff56a6d6008[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:
0x7ff56a712158> NAME:PostgreSQL72FatalError REASON:fatal pgsql error
(channel=<0x0x7ff56a718c48[PostgreSQL72Channel]:
connection=<0x0x7ff56a7192e8[PGConnection]:
connection=0x0x7ff56a719430>>): FEHLER: Spalte a.c_description
existiert nicht
ZEILE 1:
..._priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_descri...
^
Jan 19 08:57:44 sogod [17844]: [ERROR]
<0x6A849348[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder
fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]):
fetch failed!
Jan 19 08:57:44 sogod [17844]: 192.168.135.39 "POST
/SOGo/so/mueller/Calendar/eventsblocks?sd=20160117&ed=20160123&view=weekview
HTTP/1.1" 200 64/0 0.006 - - 4K
*Gesendet:* Montag, 18. Januar 2016 um 14:07 Uhr
*Von:* "Daniel Müller" <[email protected]>
*An:* Users <[email protected]>
*Betreff:* No Calender working after updating from SOGo 2.3.4 to SOGo
2.3.5
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[PGConnection]:
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
--
[email protected]
https://inverse.ca/sogo/lists
