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.
-- 
[email protected]
https://inverse.ca/sogo/lists

Reply via email to