Author Topic: Kolab Calendar DB error  (Read 3657 times)

Offline dblazeka

  • Jr. Member
  • **
  • Posts: 11
Kolab Calendar DB error
« 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?

Offline alec

  • Hero Member
  • *****
  • Posts: 1,363
Re: Kolab Calendar DB error
« Reply #1 on: March 26, 2014, 06:37:57 AM »

Offline dblazeka

  • Jr. Member
  • **
  • Posts: 11
Re: Kolab Calendar DB error
« Reply #2 on: March 26, 2014, 07:15:54 AM »
Yes. It's PostgreSQL. It worked. Thank you very much