Hello all Ok , i didn t see that there are an update script. thanks at all :)
Le Dimanche 14 Juin 2015 14:16 CEST, Markus Schönhaber<[email protected]> a écrit: Am 14.06.2015 um 11:23 schrieb Alain Abbas: > 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=<0x0x7f50dd7ce 4d0[PGCon nection]: 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? You probably didn't run the appropriate script to update the DB structure as the upgrade instructions say: | Upgrading to v2.3.0 | | Run the shell script sql-update-2.2.17_to_2.3.0.sh or sql-update-2.2.17_to_2.3.0-mysql.sh (if | you use MySQL). | | This will grow the "participant states" field of calendar quick tables | to a larger size and add the the "c_description" column to calendar | quick tables. | | Moreover, if you are using a multi-domain configuration, make sure the | keys for your domains match the email domains you have defined. -- Regards mks -- [email protected] https://inverse.ca/sogo/lists -- Alain Abbas 11 rue Robert Schumann 54500 Vandoeuvre Tel : +333 83 18 02 70 skype: alain.abbas -- [email protected] https://inverse.ca/sogo/lists
