Kolab Calendar DB error

[dblazeka]

Hi,

I am using Roundcube 1.0.0RC and Kolab Calendar 3.1.11. Each time I get to the calendar a get the following error in the log

Code Select Expand

LINE 1: SELECT e.*, (SELECT COUNT(attachment_id) FROM attachments
               ^ (SQL Query: SELECT e.*, (SELECT COUNT(attachment_id) FROM attachments
           WHERE event_id = e.event_id OR event_id = e.recurrence_id) AS _attachments
         FROM events AS e
         WHERE e.calendar_id IN ('1')
         AND e.start <= '2014-03-31 00:00:00' AND e.end >= '2014-03-24 00:00:00'
         
         GROUP BY e.event_id) in /var/www/html/roundcube/program/lib/Roundcube/rcube_db.php on line 465 (GET /roundcube/?_task=calendar&_action=load_events&source=1&start=1395615600&end=1396216800&_=1395763327597)

Any solutions?

[alec]

It is PostgreSQL, right? Try this fix: http://git.kolab.org/roundcubemail-plugins-kolab/commit/?id=7fb7ef6d0f262454e5388147ff303e4af645e291

[dblazeka]

Yes. It's PostgreSQL. It worked. Thank you very much