Stefan: I'm having problems with the calendar as well, What SQL update script are you referring to?
On Tue, Jun 16, 2015 at 1:52 PM, Stefan Frick <[email protected]> wrote: > Hi everyone, > > I managed to resolve it by running the sql update script! > > Thanks, Stefan > > On 16/06/15 17:55, Stefan Frick wrote: > > Hi, since I updated sogo yesterday the calendar and tasks are not > > showing up anymore. I can still see my calendars on the left, > > however no events on the right! Address Book still works. > > > > Pressing the reload button causes sogo to write an error message > > in the log: Jun 16 17:20:32 sogod [6167]: [ERROR] > > <0x0x7f7dc076fef0[WOWatchDog]> No child available to handle > > incoming request! Jun 16 17:20:32 sogod [6170]: 137.222.92.18 > > "POST /SOGo/so/stefan/Calendar/alarmslist?browserTime=1434471633 > > HTTP/1.1" 200 2/0 0.012 - - 0Jun 16 17:20:32 sogod [6172]: [ERROR] > > <0x0x7f7dc0e2ece0[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 sogostefan00155a35510_quick a, sogostefan00155a35510 b WHERE > > ((c_component = 'vtodo') AND ((c_startdate IS NULL) OR (c_startdate > > <= 1434495599)) AND ((c_enddate IS NULL) OR (c_enddate >= > > 1434409200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc0e5c1e0> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6167]: > > [ERROR] <0x0x7f7dc076fef0[WOWatchDog]> No child available to handle > > incoming request! Jun 16 17:20:32 sogod [6172]: [ERROR] > > <0x0x7f7dc0e2ece0[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 sogostefan00155a35510_quick a, sogostefan00155a35510 b WHERE > > ((c_component = 'vtodo') AND ((c_startdate IS NULL) OR (c_startdate > > <= 1434495599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate > > >= 1434409200)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc087cd60> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6172]: > > [ERROR] <0xC0E19F40[SOGoAppointmentFolder]:personal> > > (-[SOGoAppointmentFolder > > > fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): > > > > > fetch failed! > > Jun 16 17:20:32 sogod [6172]: [ERROR] > > <0x0x7f7dc0e06ce0[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 sogostefan00572f92d17_quick a, sogostefan00572f92d17 b WHERE > > ((c_component = 'vtodo') AND ((c_startdate IS NULL) OR (c_startdate > > <= 1434495599)) AND ((c_enddate IS NULL) OR (c_enddate >= > > 1434409200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc0c47ce0> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6171]: > > [ERROR] <0x0x7f7dc0ff31e0[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 sogostefan00155a35510_quick a, sogostefan00155a35510 b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1435013999)) AND ((c_enddate IS NULL) OR (c_enddate > > >= 1434409200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc103aaa0> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6172]: > > [ERROR] <0x0x7f7dc0e06ce0[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 sogostefan00572f92d17_quick a, sogostefan00572f92d17 b WHERE > > ((c_component = 'vtodo') AND ((c_startdate IS NULL) OR (c_startdate > > <= 1434495599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate > > >= 1434409200)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc0e01080> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6172]: > > [ERROR] > > <0xC0E154C0[SOGoAppointmentFolder]:2F1C-526A9B00-3F-68455C00> > > (-[SOGoAppointmentFolder > > > fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): > > > > > fetch failed! > > Jun 16 17:20:32 sogod [6171]: [ERROR] > > <0x0x7f7dc0ff31e0[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 sogostefan00155a35510_quick a, sogostefan00155a35510 b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1435013999)) AND ((c_cycleenddate IS NULL) OR > > (c_cycleenddate >= 1434409200)) AND (c_iscycle = 1)) AND a.c_name = > > b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': > > <MySQL4Exception: 0x7f7dc0dd4900> NAME:ExecutionFailed > > REASON:Unknown column 'a.c_description' in 'field list' Jun 16 > > 17:20:32 sogod [6171]: [ERROR] > > <0xC0F1F1A0[SOGoAppointmentFolder]:personal> > > (-[SOGoAppointmentFolder > > > fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): > > > > > fetch failed! > > Jun 16 17:20:32 sogod [6172]: [ERROR] > > <0x0x7f7dc0e0d340[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 sogostefan00102393d4c_quick a, sogostefan00102393d4c b WHERE > > ((c_component = 'vtodo') AND ((c_startdate IS NULL) OR (c_startdate > > <= 1434495599)) AND ((c_enddate IS NULL) OR (c_enddate >= > > 1434409200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc0c7fa80> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6172]: > > [ERROR] <0x0x7f7dc0e0d340[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 sogostefan00102393d4c_quick a, sogostefan00102393d4c b WHERE > > ((c_component = 'vtodo') AND ((c_startdate IS NULL) OR (c_startdate > > <= 1434495599)) AND ((c_cycleenddate IS NULL) OR (c_cycleenddate > > >= 1434409200)) AND (c_iscycle = 1)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc0de6430> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6172]: > > [ERROR] > > <0xC0BEDB50[SOGoAppointmentFolder]:7821-54296100-3-53063600> > > (-[SOGoAppointmentFolder > > > fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): > > > > > fetch failed! > > Jun 16 17:20:32 sogod [6171]: [ERROR] > > <0x0x7f7dc0f3e6c0[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 sogostefan00572f92d17_quick a, sogostefan00572f92d17 b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1435013999)) AND ((c_enddate IS NULL) OR (c_enddate > > >= 1434409200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc0e10f30> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6172]: > > 137.222.92.18 "POST > > > /SOGo/so/stefan/Calendar/taskslist?show-completed=0&asc=true&sort=end&filterpopup=view_today > > > > > HTTP/1.1" 200 2/0 0.067 - - 0 > > Jun 16 17:20:32 sogod [6171]: [ERROR] > > <0x0x7f7dc0f3e6c0[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 sogostefan00572f92d17_quick a, sogostefan00572f92d17 b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1435013999)) AND ((c_cycleenddate IS NULL) OR > > (c_cycleenddate >= 1434409200)) AND (c_iscycle = 1)) AND a.c_name = > > b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': > > <MySQL4Exception: 0x7f7dc10ff7a0> NAME:ExecutionFailed > > REASON:Unknown column 'a.c_description' in 'field list' Jun 16 > > 17:20:32 sogod [6171]: [ERROR] > > <0xC115F840[SOGoAppointmentFolder]:2F1C-526A9B00-3F-68455C00> > > (-[SOGoAppointmentFolder > > > fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): > > > > > fetch failed! > > Jun 16 17:20:32 sogod [6171]: [ERROR] > > <0x0x7f7dc0d2bd30[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 sogostefan00102393d4c_quick a, sogostefan00102393d4c b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1435013999)) AND ((c_enddate IS NULL) OR (c_enddate > > >= 1434409200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc10f4050> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6171]: > > [ERROR] <0x0x7f7dc0d2bd30[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 sogostefan00102393d4c_quick a, sogostefan00102393d4c b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1435013999)) AND ((c_cycleenddate IS NULL) OR > > (c_cycleenddate >= 1434409200)) AND (c_iscycle = 1)) AND a.c_name = > > b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': > > <MySQL4Exception: 0x7f7dc12fe000> NAME:ExecutionFailed > > REASON:Unknown column 'a.c_description' in 'field list' Jun 16 > > 17:20:32 sogod [6171]: [ERROR] > > <0xC0EE8CB0[SOGoAppointmentFolder]:7821-54296100-3-53063600> > > (-[SOGoAppointmentFolder > > > fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): > > > > > fetch failed! > > Jun 16 17:20:32 sogod [6171]: 137.222.92.18 "POST > > > /SOGo/so/stefan/Calendar/eventslist?asc=true&sort=start&day=20150616&filterpopup=view_next7 > > > > > HTTP/1.1" 200 2/0 0.073 - - 0 > > Jun 16 17:20:32 sogod [6170]: 137.222.92.18 "POST > > /SOGo/so/stefan/Calendar/activeTasks HTTP/1.1" 200 78/0 0.008 - - > > 0 Jun 16 17:20:32 sogod [6172]: 137.222.92.18 "POST > > /SOGo/so/stefan/Calendar/monthview?day=20150616 HTTP/1.1" 200 > > 1165/0 0.011 6488 82% 0 Jun 16 17:20:32 sogod [6172]: [ERROR] > > <0x0x7f7dc0e5d630[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 sogostefan00155a35510_quick a, sogostefan00155a35510 b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1436137199)) AND ((c_enddate IS NULL) OR (c_enddate > > >= 1433113200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc0bee280> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6172]: > > [ERROR] <0x0x7f7dc0e5d630[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 sogostefan00155a35510_quick a, sogostefan00155a35510 b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1436137199)) AND ((c_cycleenddate IS NULL) OR > > (c_cycleenddate >= 1433113200)) AND (c_iscycle = 1)) AND a.c_name = > > b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': > > <MySQL4Exception: 0x7f7dc0ab4970> NAME:ExecutionFailed > > REASON:Unknown column 'a.c_description' in 'field list' Jun 16 > > 17:20:32 sogod [6172]: [ERROR] > > <0xC077DFB0[SOGoAppointmentFolder]:personal> > > (-[SOGoAppointmentFolder > > > fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): > > > > > fetch failed! > > Jun 16 17:20:32 sogod [6172]: [ERROR] > > <0x0x7f7dc0c62120[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 sogostefan00572f92d17_quick a, sogostefan00572f92d17 b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1436137199)) AND ((c_enddate IS NULL) OR (c_enddate > > >= 1433113200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc0cd4230> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6172]: > > [ERROR] <0x0x7f7dc0c62120[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 sogostefan00572f92d17_quick a, sogostefan00572f92d17 b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1436137199)) AND ((c_cycleenddate IS NULL) OR > > (c_cycleenddate >= 1433113200)) AND (c_iscycle = 1)) AND a.c_name = > > b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': > > <MySQL4Exception: 0x7f7dc0e32780> NAME:ExecutionFailed > > REASON:Unknown column 'a.c_description' in 'field list' Jun 16 > > 17:20:32 sogod [6172]: [ERROR] > > <0xC0E244E0[SOGoAppointmentFolder]:2F1C-526A9B00-3F-68455C00> > > (-[SOGoAppointmentFolder > > > fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): > > > > > fetch failed! > > Jun 16 17:20:32 sogod [6172]: [ERROR] > > <0x0x7f7dc0c5d530[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 sogostefan00102393d4c_quick a, sogostefan00102393d4c b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1436137199)) AND ((c_enddate IS NULL) OR (c_enddate > > >= 1433113200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND > > (c_deleted != 1 OR c_deleted IS NULL)': <MySQL4Exception: > > 0x7f7dc0e0fef0> NAME:ExecutionFailed REASON:Unknown column > > 'a.c_description' in 'field list' Jun 16 17:20:32 sogod [6172]: > > [ERROR] <0x0x7f7dc0c5d530[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 sogostefan00102393d4c_quick a, sogostefan00102393d4c b WHERE > > ((c_component = 'vevent') AND ((c_startdate IS NULL) OR > > (c_startdate <= 1436137199)) AND ((c_cycleenddate IS NULL) OR > > (c_cycleenddate >= 1433113200)) AND (c_iscycle = 1)) AND a.c_name = > > b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': > > <MySQL4Exception: 0x7f7dc0e415a0> NAME:ExecutionFailed > > REASON:Unknown column 'a.c_description' in 'field list' Jun 16 > > 17:20:32 sogod [6172]: [ERROR] > > <0xC0CBBAD0[SOGoAppointmentFolder]:7821-54296100-3-53063600> > > (-[SOGoAppointmentFolder > > > fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]): > > > > > fetch failed! > > Jun 16 17:20:32 sogod [6172]: 137.222.92.18 "POST > > > /SOGo/so/stefan/Calendar/eventsblocks?sd=20150601&ed=20150705&view=monthview > > > > > HTTP/1.1" 200 288/0 0.012 - - 0 > > > > Any idea how to fix this? > > > > Thanks in advance, Stefan > > > -- > [email protected] > https://inverse.ca/sogo/lists > -- Richard "Doc" Kinne, [KQR] Astronomical Technologist American Association of Variable Star Observers ----------------- Please support the AAVSO and its mission -- Join or donate today: http://www.aavso.org/apps/donate -- [email protected] https://inverse.ca/sogo/lists
