Hi Joost,
Ralf,
I managed to get a little bit further with this by using the android built-in
mail client and reducing the amount of subscribed mail folders.
Reading Emails is currently working.
However, I did notice an incorrect SQL-statement for the calendar. (And
possibly also the other items.):
17/08/2016 08:39:24 [ 9770] [DEBUG] [joost]
calendar_zpush::GetMessageList(‘1001000003E9’,0)
17/08/2016 08:39:24 [ 9770] [WARN] [joost]
/var/www/localhost/htdocs/egw/api/src/Db/ADOdb/drivers/adodb-
postgres7.inc.php:257 pg_query(): Query failed: ERROR: syntax error at or
near "DISTINCT"
LINE 1: SELECT DISTINCT DISTINCT egw_cal_repeats.recur_type,range_en…
^ (2)
17/08/2016 08:39:24 [ 9770] [ERROR] [joost] GetMessageList() Error happend in
calendar Invalid SQL: SELECT DISTINCT DISTINCT
egw_cal_repeats.recur_type,range_end AS
recur_enddate,egw_cal_repeats.recur_interval,egw_cal_repeats.recur_data,CAST(egw_cal.cal_id
AS varchar),range_start AS cal_start,range_end AS
cal_end,egw_cal_user.cal_recur_date FROM (SELECT * FROM egw_cal WHERE
cal_deleted IS NULL AND (range_end IS NULL OR range_end>-8640000)) egw_cal
JOIN egw_cal_user ON egw_cal.cal_id=egw_cal_user.cal_id LEFT JOIN
egw_cal_repeats ON egw_cal.cal_id=egw_cal_repeats.cal_id LEFT JOIN
egw_cal_user rejected_by_user ON egw_cal.cal_id=rejected_by_user.cal_id AND
rejected_by_user.cal_user_type=‘u’ AND rejected_by_user.cal_user_id=‘1001’ AND
rejected_by_user.cal_recur_date=0 WHERE cal_recurrence=0 AND cal_deleted IS
NULL AND egw_cal_user.cal_status NOT IN (‘R’,‘X’) AND (-8640000 < range_end OR
range_end IS NULL) AND egw_cal_user.cal_recur_date=0 AND
(rejected_by_user.cal_status IS NULL OR rejected_by_user.cal_status NOT IN
(‘R’,‘X’)) AND egw_cal_user.cal_user_type=‘u’ AND egw_cal_user.cal_user_id IN
(‘1001’,’-1003’,’-1006’,’-1007’,’-1008’,’-1018’,’-1019’)
ERROR: syntax error at or near "DISTINCT"
LINE 1: SELECT DISTINCT DISTINCT egw_cal_repeats.recur_type,range_en…
(Note the “DISTINCT” being added twice.
I am currently using version “16.1.20160715” with the patch you provided
earlier. If the above is already fixed in a newer version, please let me know
and I will update the test environment.
Updating your test-enviroment to the latest maintenance / bugfixing
release make always sense!
I found and fixed a code path which can lead to the above SQL error and
a quick check with MySQL/MariaDB shows that they ignore double DISTINCT.
So please update your test-environment first, then apply the following
fix (not yet in 16.1 branch!):
https://github.com/EGroupware/egroupware/commit/26dbe74328935a7aa77bccf230189aa703fc51c4
And report here if it fixes your problem so I can merge it to 16.1 and
it will be part of next maintenance release.
Ralf
–
Ralf Becker
Director Software Development
Stylite AG
Isaac-Fulda-Allee 9 | Tel. +49 6131 32702-0
D-55124 Mainz | Fax. +49 6131 32702-70
Email: rb@stylite.de
www.stylite.de | www.egroupware.org
Managing Directors: Andre Keller | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer
VAT DE214280951 | Registered HRB 46224 Mainz Germany
