Hi, we have SOGo 1.2.0 running good on Debian Lenny with PostgreSQL.
We are trying SOGo 1.2.2 but Calendars Tasks aren't show.
SOGo logs show:
<0x086210F0[SOGoAppointmentFolder]:297-4B9F9880-1-65B9D600>
(-[SOGoAppointmentFolder
fetchFields:from:to:title:component:additionalFilters:in
cludeProtectedInformation:]): fetch failed!
127.0.0.1 - - [19/Jul/2010:11:10:06 GMT] "POST
/SOGo/so/pruebascomparex/Calendar/eventslist?asc=true&sort=start&day=&filterpopup=view_today
H
TTP/1.1" 200 2/0 0.060 - - 0
<0x0x856cee8[GCSFolder]> -[GCSFolder
fetchFields:fetchSpecification:ignoreDeleted:]: cannot execute quick-fetch SQL
'SELECT b.c_name,b.c_cont
ent,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 sogopruebasc0012f17844c_quick a,
sogopruebasc0012f17844c b WHERE (c_component = 'vtodo') AND a.c_name =
b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)': <PostgreSQL72Exception:
0x9de7680> NAME:PostgreSQL72FatalError REASON:fatal pgsql error
(channel=<0x0x8a99c38[PostgreSQL72Channel]:
connection=<0x0x8980518[PGConnection]: connection=0x0x8c801f0>>): ERROR: no
existe la columna a
.c_category
LINE 1: ...ent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_catego...
^
<0x08C9BC98[SOGoAppointmentFolder]:personal> (-[SOGoAppointmentFolder
fetchFields:from:to:title:component:additionalFilters:includeProtectedI
nformation:]): fetch failed!
<0x0x8537718[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 sogopruebasc00551cbd7c8_quick a, sogopruebasc00551cbd7c8 b WHERE
(c_component = 'vtodo') AND a.c_name = b.c_name AND (c_deleted != 1 OR
c_deleted IS NULL)': <PostgreSQL72Exception: 0x9e5c510>
NAME:PostgreSQL72FatalError REASON:fatal pgsql error
(channel=<0x0x8a99c38[PostgreSQL72Channel]:
connection=<0x0x8980518[PGConnection]: connection=0x0x8c801f0>>): ERROR: no
existe la columna a.c_category
LINE 1: ...ent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_catego...
^
<0x0887BE28[SOGoWebAppointmentFolder]:7A8E-4B754B80-43-3B51A0C0>
(-[SOGoAppointmentFolder
fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]):
fetch failed!
<0x0x8a21dd8[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 sogopruebasc00155c55a94_quick a, sogopruebasc00155c55a94 b WHERE
(c_component = 'vtodo') AND a.c_name = b.c_name AND (c_deleted != 1 OR
c_deleted IS NULL)': <PostgreSQL72Exception: 0x90a1340>
NAME:PostgreSQL72FatalError REASON:fatal pgsql error
(channel=<0x0x8a99c38[PostgreSQL72Channel]:
connection=<0x0x8980518[PGConnection]: connection=0x0x8c801f0>>): ERROR: no
existe la columna a.c_category
LINE 1: ...ent,a.c_title,a.c_location,a.c_orgmail,a.c_status,a.c_catego...
We had to create that columns manually or apply some kind of change into our
database?
Regards
Joaquín Manuel Llano Montero
________________________________________
COMPAREX PC-WARE Group
Ingeniero de Sistemas
C/ Severo Ochoa 20
06800 Mérida (Badajoz) España
phone: +34 924 37 35 73 / +34 924 38 36 00
mobile: +34 615 84 80 19
fax: +34 924 37 45 18
email: [email protected] <mailto:[email protected]>
web: www.comparex.es <http://www.comparex.es>
COMPAREX PC-WARE Group | c/Severo Ochoa 20
06800 Mérida , Badajoz | España
phone: +34 924 37 35 73 | mobile: +34 615 84 80 19 | fax: +34 924 37 45 18
email: [email protected] <mailto:[email protected]> | web:
www.comparex.es <http://www.comparex.es>
-- De conformidad con lo establecido en la L.O.P.D., COMPAREX garantiza la
adopción de las medidas necesarias para asegurar el tratamiento confidencial de
los datos de carácter personal. Así mismo le informamos de la posibilidad de
ejercer los derechos de acceso, rectificación, cancelación y oposición.
According to the established in the Spanish law of data protection (L.O.P.D.),
COMPAREX guarantees the adoption of the necessary measures to assure the
confidential processing of the personal data. In the same way we inform you of
the possibility of exercising the rights of access, modification, cancellation
and opposition.
--
[email protected]
https://inverse.ca/sogo/lists
