Problems with groupdav to access calendar entries with kontact (akonadi)

J_Roeleveld 2011-05-16 10:36:43 UTC #1

Hi All,

I am having difficulty accessing my eGroupware Calendar from Kontact using
groupdav.

It worked correctly with 1.6.003, but after upgrading to the latest version
(1.8.001.20110421) I keep getting error messages.

I have attached part of the apache-error log for a single entry. I get this
error for each entry in the calendar.
When accessing the groupdav.php url directly using firefox, I do not see these
error messages.

The SQL-statement listed in the error-log is:
SELECT egw_cal_repeats.,egw_cal.,MIN(cal_start) AS cal_start,MIN(cal_end) AS
cal_end FROM egw_cal ,egw_cal_dates LEFT JOIN egw_cal_repeats ON
egw_cal_dates.cal_id=egw_cal_repeats.cal_id WHERE
egw_cal.cal_id=egw_cal_dates.cal_id AND (egw_cal.cal_id = 69) GROUP BY
egw_cal.cal_id,egw_cal.cal_uid,egw_cal.cal_owner,egw_cal.cal_category,egw_cal.cal_modified,egw_cal.cal_priority,egw_cal.cal_public,egw_cal.cal_title,egw_cal.cal_description,egw_cal.cal_location,egw_cal.cal_reference,egw_cal.cal_modifier,egw_cal.cal_non_blocking,egw_cal.cal_special,egw_cal.cal_etag,egw_cal_repeats.cal_id,egw_cal_repeats.recur_type,egw_cal_repeats.recur_enddate,egw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,egw_cal_repeats.recur_exception

This SQL-query works after adding the following to the GROUP BY statement:
"
,egw_cal.cal_creator,egw_cal.cal_created,egw_cal.cal_recurrence,egw_cal.tz_id
"

Does anyone have any ideas?

Thanks,

Joost Roeleveld

PS. version info:
PHP = 5.3.6
Apache = 2.2.17
kdepim = 4.5.95
postgresql = 8.4.4

J_Roeleveld 2011-05-17 11:02:55 UTC #2

Topposting solution:

Downgrade PHP to 5.2.17

Hi All,

I am having difficulty accessing my eGroupware Calendar from Kontact using
groupdav.

It worked correctly with 1.6.003, but after upgrading to the latest version
(1.8.001.20110421) I keep getting error messages.

I have attached part of the apache-error log for a single entry. I get this
error for each entry in the calendar.
When accessing the groupdav.php url directly using firefox, I do not see
these error messages.

The SQL-statement listed in the error-log is:
SELECT egw_cal_repeats.,egw_cal.,MIN(cal_start) AS cal_start,MIN(cal_end)
AS cal_end FROM egw_cal ,egw_cal_dates LEFT JOIN egw_cal_repeats ON
egw_cal_dates.cal_id=egw_cal_repeats.cal_id WHERE
egw_cal.cal_id=egw_cal_dates.cal_id AND (egw_cal.cal_id = 69) GROUP BY
egw_cal.cal_id,egw_cal.cal_uid,egw_cal.cal_owner,egw_cal.cal_category,egw_ca
l.cal_modified,egw_cal.cal_priority,egw_cal.cal_public,egw_cal.cal_title,egw
cal.cal_description,egw_cal.cal_location,egw_cal.cal_reference,egw_cal.cal
modifier,egw_cal.cal_non_blocking,egw_cal.cal_special,egw_cal.cal_etag,egw_c
al_repeats.cal_id,egw_cal_repeats.recur_type,egw_cal_repeats.recur_enddate,e
gw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,egw_cal_repeats.rec
ur_exception

This SQL-query works after adding the following to the GROUP BY statement:
"
,egw_cal.cal_creator,egw_cal.cal_created,egw_cal.cal_recurrence,egw_cal.tz_i
d "

Does anyone have any ideas?

Thanks,

Joost Roeleveld

PS. version info:
PHP = 5.3.6
Apache = 2.2.17
kdepim = 4.5.95
postgresql = 8.4.4

Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

rsteinmetz70112 2011-05-19 15:26:56 UTC #3

What Every C/C++ and Fortran developer Should Know!
Read this article and learn how Intel has extended the reach of its
next-generation tools to help Windows* and Linux* C/C++ and Fortran
developers boost performance applications - including clusters.
http://p.sf.net/sfu/intel-dev2devmay

J_Roeleveld 2011-05-23 14:00:16 UTC #4

Sorry for the late reply. What Linux distribution and Version were you
using?

I am using Gentoo on both server and client.
Both were fully updated as per stable over the weekend before I found this
issue.

There appears to be a problem when using PHP 5.3. Have another (older) PHP
application that doesn’t work at all with 5.3, which I found out prior to
downgrading to 5.2.17.

–
Joost

Joost Roeleveld wrote:
Topposting solution:

Downgrade PHP to 5.2.17

Hi All,

I am having difficulty accessing my eGroupware Calendar from Kontact using
groupdav.

It worked correctly with 1.6.003, but after upgrading to the latest version
(1.8.001.20110421) I keep getting error messages.

I have attached part of the apache-error log for a single entry. I get this
error for each entry in the calendar.
When accessing the groupdav.php url directly using firefox, I do not see
these error messages.

The SQL-statement listed in the error-log is:
SELECT egw_cal_repeats.,egw_cal.,MIN(cal_start) AS cal_start,MIN(cal_end)
AS cal_end FROM egw_cal ,egw_cal_dates LEFT JOIN egw_cal_repeats ON
egw_cal_dates.cal_id=egw_cal_repeats.cal_id WHERE
egw_cal.cal_id=egw_cal_dates.cal_id AND (egw_cal.cal_id = 69) GROUP BY
egw_cal.cal_id,egw_cal.cal_uid,egw_cal.cal_owner,egw_cal.cal_category,egw_c
a
l.cal_modified,egw_cal.cal_priority,egw_cal.cal_public,egw_cal.cal_title,e
gw
cal.cal_description,egw_cal.cal_location,egw_cal.cal_reference,egw_cal.ca
l
modifier,egw_cal.cal_non_blocking,egw_cal.cal_special,egw_cal.cal_etag,egw
_c
al_repeats.cal_id,egw_cal_repeats.recur_type,egw_cal_repeats.recur_enddate
,e
gw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,egw_cal_repeats.r
ec ur_exception

This SQL-query works after adding the following to the GROUP BY statement:
"
,egw_cal.cal_creator,egw_cal.cal_created,egw_cal.cal_recurrence,egw_cal.tz_
i d "

Does anyone have any ideas?

Thanks,

Joost Roeleveld

PS. version info:
PHP = 5.3.6
Apache = 2.2.17
kdepim = 4.5.95
postgresql = 8.4.4

— Achieve unprecedented app performance and reliability
What every C/C++ and Fortran developer should know.
Learn how Intel has extended the reach of its next-generation tools
to help boost performance applications - inlcuding clusters.
http://p.sf.net/sfu/intel-dev2devmay

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users

eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users