Am Sonntag, 30. Oktober 2011 schrieb Christian Naumer:
> Am 30.10.2011 09:53, schrieb Christian Naumer:
> > There are some others as well for
> > a.c_deleted
> > b.c_component
> >
> > but there are only c_component fields in the table and no fields
> > with deleted in there. But this is the same in the working
> > system on Centos6
>
> I have to correct this the c_deleted field is not in the
> quick-table but in the "normal" table. So all fields are there it
> just doesn't find them...
I have similar problems after update. There is no entry in my calendar
view. I checked the SQL statements in the error log file.
SELECT
b.c_name,a.c_content,a.c_creationdate,a.c_lastmodified,a.c_version,b.c_component,b.c_title,b.c_location,b.c_orgmail,b.c_status,b.c_category,b.c_classification,b.c_isallday,b.c_isopaque,b.c_participants,b.c_partmails,b.c_partstates,b.c_sequence,b.c_priority,b.c_cycleinfo,b.c_iscycle,b.c_nextalarm,b.c_uid,b.c_startdate,b.c_enddate
FROM sogo0017042270b_quick a, sogo0017042270b b WHERE ((c_component =
'vevent') AND ((c_startdate IS NULL) OR (c_startdate <= 1320620399))
AND ((c_enddate IS NULL) OR (c_enddate >= 1316988000)) AND (c_iscycle
= 0)) AND a.c_name = b.c_name AND (c_deleted != 1 OR c_deleted IS
NULL)
And if I change the table names ('b' for the _quick table and 'a' for
the normal one) it went through smoothly.
Besides this sogod tries to load libgnustep-base.so.1.23 and
libgnustep-base.so.1.20. The command 'ldd /usr/sbin/sogod | grep base'
reports:
libgnustep-base.so.1.23 => /usr/lib/libgnustep-base.so.1.23
(0x047ae000)
libgnustep-base.so.1.20 => not found
libgnustep-base.so.1.20 => not found
This is CentOS 5.7 and SOGo is from package sogo-1.3.9-2.el5. Database
is MySQL.
Martin
--
[email protected]
https://inverse.ca/sogo/lists