Hi,
I get a database error when I add tasks or appointments :
Jul 22 17:02:40 sogod: SOGo watchdog [17765]: [ERROR]
0x04737AE0[SOGoAppointmentFolder]:personal (-[SOGoAppointmentFolder
fetchFields:from:to:title:component:additionalFilters:includeProtectedInformation:]):
fetch failed!
Jul 22 17:02:40 sogod: SOGo watchdog [17765]: [ERROR] 0x0x4f42800[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,b.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 sogoutil100319d82f0a_quick a, sogoutil100319d82f0a b WHERE (c_component =
'vtodo') AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS NULL)':
PostgreSQL72Exception: 0x52c51b0 NAME:PostgreSQL72FatalError REASON:fatal
pgsql error (channel=0x0x46d32c0[PostgreSQL72Channel]:
connection=0x0x4ef3b90[PGConnection]: connection=0x0x56f1930): ERROR:
column b.c_category does not exist
I'm using a Debian Lenny Postgresql 8.3.11 package.
The sql-update-1.2.2_to_1.3.0.sh script didn't do the trick despite the fact
the columns were correctly added.
Thanks.
--
users@sogo.nu
https://inverse.ca/sogo/lists