There is a script to add the column. On debian systems it's /usr/share/doc/sogo/sql-update-2.1.17_to_2.3.0.sh, but the location will vary.

Cordialement,
Ian

Le 14/06/2015 11:23, Alain Abbas a écrit :
Hello
After a 2.3 upgrade  2.2.9 to 2.3 i lost my personal calendar. the datas seems in the database and if
a set a caldav sync (with galaxy) i see all my appointments.

In the log :
[ERROR] <0x0x7f50ddfb2410[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 sogoquentinp002520e295a_quick a, sogoquentinp002520e295a b WHERE ((c_component = 'vevent') AND (c_classification != 1) AND ((c_startdate IS NULL) OR (c_startdate <= 1436133599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate >= 1433109600)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <PostgreSQL72Exception: 0x7f50ddfc7360> NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=<0x0x7f50dd993de0[PostgreSQL72Channel]: connection=<0x0x7f50dd7ce4d0[PGConnection]:  connection=0x0x7f50dd7cc490>>): ERREUR:  la colonne a.c_description n'existe pas
LIGNE 1 : ..._priority,a.c_cycleinfo,a.c_iscycle,a.c_nextalarm,a.c_descri...

Seems the column c_description is missing
somebody had the same problem?


--
Alain Abbas
11 rue Robert Schumann
54500 Vandoeuvre
Tel : +333 83 18 02 70
skype: alain.abbas

Reply via email to