Hi, I'm running sogo on Ubuntu. The update scripts there are in /usr/share/doc/sogo/. Essentially I ran everyone in there ending with -mysqpl.sh, since I'm using a mysql database. To get the newest script working (2.1.17 to 2.3.0), I had to set the proper URLs in the sogo.conf file first.
Cheers, Stefan On 16/06/15 18:52, Stefan Frick 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
