[calendar_plus] - PostgreSQL issues

[GoogleCodeExporter]

Token: 36ad175e8fce3d09a20a1375ff831682 (Don't modify this token!)
Version: 4.0.26 (02-01-2015)
PHP: 5.3.3
RCMAIL: 1.0.4
Database: pgsql
SERVER: nginx/1.6.2
----
I.  Issue Description:

Can't add remote calendar.

II. Steps to reproduce the Issue:
1. Update calendar 19.0.28
2. Again (!, because old calendar_plus not working and show blank page) buy 
calendar_plus 4.0.26

By this topic 
https://forum.myroundcube.com/topic/187-new-calendar-plugin-is-not-working
reinstall all database tables of calendar/attachment/todo etc.

Postgresql log:

ERROR:  column "e.calendar_id" must appear in the GROUP BY clause or be used in 
an aggregate function at character 8
STATEMENT:  SELECT e.*, (SELECT COUNT(attachment_id) FROM vevent_attachments 
                   WHERE event_id = e.event_id) AS _attachments
                 FROM vevent AS e
                 WHERE e.calendar_id IN ('1')
                 AND ((e.start >= '2014-12-29 00:00:00' AND e.end <= '2015-01-05 00:00:00') OR recurrence <> '' OR exdate IS NOT NULL) AND del <> '1'

                 GROUP BY e.event_id
                 ORDER BY uid, exception, exdate ASC

Original issue reported on code.google.com by LiveL...@gmail.com on 4 Jan 2015 at 12:17

Attachments:

• Capture.PNG

[GoogleCodeExporter]

We have fixed several issues in PostgreSQL database queries related to missing 
identifier quotes but we are not able to duplicate this specific error log 
entry. Please update calendar and report if issue persists.

Original comment by roland.l...@gmail.com on 5 Jan 2015 at 6:16

• Changed state: Reproducing

[GoogleCodeExporter]

Original comment by roland.l...@gmail.com on 5 Jan 2015 at 6:17

• Changed title: [calendar_plus] - PostgreSQL issues

[GoogleCodeExporter]

Problem persist:

ERROR:  column "e.calendar_id" must appear in the GROUP BY clause or be used in 
an aggregate function at character 8
STATEMENT:  SELECT e.*, (SELECT COUNT(attachment_id) FROM vevent_attachments 
                   WHERE event_id = e.event_id) AS _attachments
                 FROM vevent AS e
                 WHERE e.calendar_id IN ('1')
                 AND ((e.start >= '2015-01-05 00:00:00' AND e.end <= '2015-01-12 00:00:00') OR recurrence <> '' OR exdate IS NOT NULL) AND del <> '1'

                 GROUP BY e.event_id
                 ORDER BY uid, exception, exdate ASC

How I can add CalDAV calendar ?!

Original comment by LiveL...@gmail.com on 5 Jan 2015 at 6:38

[GoogleCodeExporter]

We are not able to duplicate this issue. If you are willing to grant us access 
to your system remotely then contact us (http://myroundcube.com#contact). 
Otherwise use MySQL. Period.

Original comment by roland.l...@gmail.com on 5 Jan 2015 at 6:41

[GoogleCodeExporter]

Great

Original comment by LiveL...@gmail.com on 5 Jan 2015 at 6:47

[GoogleCodeExporter]

OK. We need access to filesystem in order to upload debug code and we need 
access to PostgreSQL Web administration interface. Use our contact form (see 
above) and let us know the details. Thanks.

Original comment by roland.l...@gmail.com on 5 Jan 2015 at 6:53

[GoogleCodeExporter]

I disable calendar/calendar_plus/tasklist and I will not use plugins for 
roundcube anymore. Stability and process of plugins upgrade not working now. 
Good luck.

Original comment by LiveL...@gmail.com on 5 Jan 2015 at 7:02

[GoogleCodeExporter]

You are not very patient. Good luck and farewell!

Original comment by roland.l...@gmail.com on 5 Jan 2015 at 7:05

• Changed state: WontFix

[GoogleCodeExporter]

We have investigated the issue again and the only difference we can imagine is 
the PostgreSQL version. We use 9.3.

Original comment by roland.l...@gmail.com on 5 Jan 2015 at 8:26

[GoogleCodeExporter]

And one final statement in regards to your screenshot. Remote calendar 
resources are added from calendar "Plus icon" on left bottom corner and NOT 
from calendar -> settings.

Original comment by roland.l...@gmail.com on 5 Jan 2015 at 8:27

[GoogleCodeExporter]

"Plus icon" been shows only "Local calendar"

Original comment by LiveL...@gmail.com on 5 Jan 2015 at 10:33

[GoogleCodeExporter]

Configure the drivers. This is not a support forum, it is a bug tracker. Please 
use https://forum.myroundcube.com for support requests.

// backend type (database, caldav, ical)
$config['calendar_driver'] = array('database', 'caldav', 'ical');
$config['calendar_driver_default'] = 'database';

Original comment by roland.l...@gmail.com on 5 Jan 2015 at 2:32