[pkg-horde] Bug#755187: php-horde-kronolith: sync with syncevolution fails with SQL syntax error

[Ville Nummela]

Package: php-horde-kronolith
Version: 4.2.0-1
Severity: normal

After upgrading php-horde-kronolith from 4.1.5-1 to 4.2.0~beta2-1, I'm 
no longer able to synchronize calendar with my phone using syncevolution 
client. New events created on my phone end up in kronolith nicely, but 
events created in kronolith will not end up in my phone. 

The horde5.log has lots of lines like this:
014-07-18T18:15:05+03:00 ERR: HORDE [kronolith] SQL QUERY FAILED: 
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL 
syntax; check the manual that corresponds to your MySQL server version for the 
 right syntax to use near ' , , , , , , , , , , , , , , , , , , , , , , , , , , 
 , , , , , , , , , , , , , )' at line 1
          SELECT event_id, event_uid, calendar_id, event_description,
                 event_location, event_private, event_status, 
                 event_attendees,
                 event_title, event_recurcount, event_url, 
                 event_timezone,
                 event_recurtype, 
                 event_recurenddate, 
                 event_recurinterval,
                 event_recurdays, 
                 event_start, 
                 event_end, 
                 event_allday, 
                 event_alarm,
                 event_alarm_methods, event_modified, event_exceptions,
                 event_creator_id, event_resources, event_baseid,
                 event_exceptionoriginaldate FROM kronolith_events WHERE event_uid =
                 '20111002151119.88304193jgdku0ao at www.nummela.org' AND calendar_id IN
                 (, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
                 , , , , , ) [pid 8877 on line 204 of "/usr/share/php/Horde/Db/Adapter/Pdo/Base.php"]
                               
I believe there is one such line for each of my events.

-- System Information:
Debian Release: 7.6
  APT prefers stable
  APT policy: (400, 'stable'), (350, 'testing')
Architecture: i386 (i686)

Kernel: Linux 3.2.0-4-686-pae (SMP w/1 CPU core)
Locale: LANG=fi_FI.UTF-8, LC_CTYPE=fi_FI.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages php-horde-kronolith depends on:
ii  php-date                 1.4.7-1
ii  php-horde                5.2.0~beta2+debian0-1
ii  php-horde-auth           2.1.5-1
ii  php-horde-autoloader     2.1.0-1
ii  php-horde-content        2.0.4-1
ii  php-horde-core           2.12.0~beta3+debian0-1
ii  php-horde-data           2.1.0-1
ii  php-horde-date           2.0.11-1
ii  php-horde-date-parser    2.0.2-2
ii  php-horde-dav            1.0.4-1
ii  php-horde-exception      2.0.4-1
ii  php-horde-form           2.0.8-1
ii  php-horde-group          2.0.4-1
ii  php-horde-history        2.3.1-1
ii  php-horde-http           2.1.1-1
ii  php-horde-icalendar      2.0.9-1
ii  php-horde-image          2.1.0-1
ii  php-horde-lock           2.1.1-1
ii  php-horde-logintasks     2.0.3-1
ii  php-horde-mail           2.3.0-1
ii  php-horde-mime           2.4.2-1
ii  php-horde-nls            2.0.4-1
ii  php-horde-notification   2.0.1-3
ii  php-horde-perms          2.1.2-1
ii  php-horde-serialize      2.0.2-2
ii  php-horde-share          2.0.5-1
ii  php-horde-support        2.1.1-1
ii  php-horde-text-filter    2.2.1-2
ii  php-horde-timezone       1.0.6-1
ii  php-horde-url            2.2.3-1
ii  php-horde-util           2.4.0-1
ii  php-horde-view           2.0.4-1
ii  php-pear                 5.4.4-14+deb7u12
ii  php5-cli                 5.4.4-14+deb7u12
ii  php5-common [php5-json]  5.4.4-14+deb7u12

Versions of packages php-horde-kronolith recommends:
pn  php-date-holidays      <none>
ii  php-horde-activesync   2.16.9-1
ii  php-horde-db           2.1.3-1
ii  php-horde-nag          4.2.0~beta2-1
pn  php-horde-openxchange  <none>
ii  php-horde-test         2.3.0-1
ii  php-horde-timeobjects  2.1.0-1

php-horde-kronolith suggests no packages.

-- no debconf information