Hi Team,
I have roundcubemail-0.8.4 with postgres 9.1.8 database. I just installed calendar plugin from plugins-kolab-0.8 and when I try to add a new event the following error message appears on Web interface: "Failed to save changes".
Roundcube error log:
-----------------------------------------------
[04-Mar-2013 11:48:21 -0300]: DB Error: prepare: [Error message: Unable to create prepared statement handle]
[Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_377eb9d1615c0ef668713253cd8fe58b99439d58c]
[Native message: ERROR: syntax error at or near "end"
LINE 2: ... (calendar_id, created, changed, uid, start, end, all_d...
^]
in /srv/www/htdocs/roundcubemail/program/include/rcube_mdb2.php on line 296 (POST /?_task=calendar&_action=event?_task=&_action=)
[04-Mar-2013 14:48:21 UTC] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]
[Last executed query: SELECT currval('event_ids')]
[Native message: ERROR: currval of sequence "event_ids" is not yet defined in this session]
-------------------------------------------------------
Postgresql log:
-------------------------------------------------------
2013-03-04 11:40:11 BRT roundcubemail roundcube ERROR: syntax error at or near "end" at character 73
2013-03-04 11:40:11 BRT roundcubemail roundcube STATEMENT: INSERT INTO events
(calendar_id, created, changed, uid, start, end, all_day, recurrence, title, description, location, categories, free_busy, priority, sensitivity, attendees, alarms, notifyat)
VALUES ('1', now(), now(), '41229C6FE1902936D674EDE2FC7E6ABF-1FF1303B18C82892', '2013-03-04 12:00:00', '2013-03-04 13:00:00', 0, '', 'teste', 'teste', 'teste', '', 1, 0, 0, '', '', NULL)
2013-03-04 11:40:11 BRT roundcubemail roundcube ERROR: currval of sequence "event_ids" is not yet defined in this session
2013-03-04 11:40:11 BRT roundcubemail roundcube STATEMENT: SELECT currval('event_ids')
-------------------------------------------------------
Could someone please help me resolve this?
Thank you!