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!
Quote from: fernandamendes on March 04, 2013, 10:03:33 AM
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.
Alec,
what's the reference database?
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.
Alec,
I have flexibility to change the database so I installed mysql and everything works fine! Thank you!