Roundcube 0.8.4 - Calendar plugin error to add new event

[fernandamendes]

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!

[alec]

2013-03-04 11:40:11 BRT roundcubemail roundcube ERROR:  syntax error at or near "end" at character 73

I created a ticket for you https://issues.kolab.org/show_bug.cgi?id=1675. Postgres is not our reference database. Also we don't use Roundcube 0.8. Better to use 0.9.

[fernandamendes]

Alec,

what's the reference database?

[alec]

Because Kolab uses mysql only for now, we use it too, but of course we'll not drop postgres support. We'll fix any non-mysql issues if we (or someone else) find them.

[fernandamendes]

Alec,

I have flexibility to change the database so I installed mysql and everything works fine! Thank you!