[SOGo] Fresh install centos 5.7
Can't insert events in calendar neither wih web interface nor whith Tunderbird 3.1 Below log. Already check library versions. Can anyone help? Nov 16 08:46:14 sogod [2659]: [ERROR] 0x0x89c4a4c[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_uid,a.c_startdate,a.c_enddate FROM sogou100249ce07e8_quick a, sogou100249ce07e8 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate = 132182)) AND ((c_enddate IS NULL) OR (c_enddate = 1321225200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x88e275c NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x88d8ce4[PostgreSQL72Channel]: connection=0x0x88db6b4[PGConnection]: connection=0x0x87cd5a8): ERROR: column a.c_component does not exist at character 75 sope49-appserver.i386 4.9-20111029_1664.el5.1 installed sope49-cards.i386 1.3.9-2.el5 installed sope49-core.i386 4.9-20111029_1664.el5.1 installed sope49-gdl1.i386 4.9-20111029_1664.el5.1 installed sope49-gdl1-contentstore.i386 1.3.9-2.el5 installed sope49-gdl1-postgresql.i386 4.9-20111029_1664.el5.1 installed sope49-ldap.i386 4.9-20111029_1664.el5.1 installed sope49-mime.i386 4.9-20111029_1664.el5.1 installed sope49-sbjson.i386 2.3.1-20111029_1664.el5.1installed sope49-xml.i386 4.9-20111029_1664.el5.1 installed -- users@sogo.nu https://inverse.ca/sogo/lists
Re: [SOGo] Fresh install centos 5.7
Solved. Lack of permission for user who access to postgresql. bySauro Cerri - Messaggio originale - Da: cerrisa...@yahoo.it cerrisa...@yahoo.it A: users@sogo.nu Cc: Inviato: Mercoledì 16 Novembre 2011 10:14 Oggetto: [SOGo] Fresh install centos 5.7 Can't insert events in calendar neither wih web interface nor whith Tunderbird 3.1 Below log. Already check library versions. Can anyone help? Nov 16 08:46:14 sogod [2659]: [ERROR] 0x0x89c4a4c[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_uid,a.c_startdate,a.c_enddate FROM sogou100249ce07e8_quick a, sogou100249ce07e8 b WHERE ((c_component = 'vevent') AND ((c_startdate IS NULL) OR (c_startdate = 132182)) AND ((c_enddate IS NULL) OR (c_enddate = 1321225200)) AND (c_iscycle = 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': PostgreSQL72Exception: 0x88e275c NAME:PostgreSQL72FatalError REASON:fatal pgsql error (channel=0x0x88d8ce4[PostgreSQL72Channel]: connection=0x0x88db6b4[PGConnection]: connection=0x0x87cd5a8): ERROR: column a.c_component does not exist at character 75 sope49-appserver.i386 4.9-20111029_1664.el5.1 installed sope49-cards.i386 1.3.9-2.el5 installed sope49-core.i386 4.9-20111029_1664.el5.1 installed sope49-gdl1.i386 4.9-20111029_1664.el5.1 installed sope49-gdl1-contentstore.i386 1.3.9-2.el5 installed sope49-gdl1-postgresql.i386 4.9-20111029_1664.el5.1 installed sope49-ldap.i386 4.9-20111029_1664.el5.1 installed sope49-mime.i386 4.9-20111029_1664.el5.1 installed sope49-sbjson.i386 2.3.1-20111029_1664.el5.1 installed sope49-xml.i386 4.9-20111029_1664.el5.1 installed -- users@sogo.nu https://inverse.ca/sogo/lists -- users@sogo.nu https://inverse.ca/sogo/lists
