[SOGo] Re: Calendar events not showing up
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
Re: [SOGo] Re: Calendar events not showing up
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 ste...@sfrick.de 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]
Re: [SOGo] Re: Calendar events not showing up
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