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
|