Roundcube Community Forum

Third Party Contributions => API Based Plugins => Topic started by: dblazeka on March 26, 2014, 04:36:29 AM

Title: Kolab Calendar DB error
Post by: dblazeka on March 26, 2014, 04:36:29 AM

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]

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?

Title: Re: Kolab Calendar DB error
Post by: alec on March 26, 2014, 06:37:57 AM

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

Title: Re: Kolab Calendar DB error
Post by: dblazeka on March 26, 2014, 07:15:54 AM

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