Thread: Roundcube calendar plugin not working

Hi people ,

I'm trying to delete an event from calendar but it's not possible.

Error Service currently not available


Should I change something to this ?

what version of calendar, RC??

look in <RC_root>/error and post here eventually errors

I've just installed Calendar plugin, installed postgresql DB 'events' and
'events_user_id' index. And while adding a new event the following error occur:

MDB2 Error: syntax error (-2): prepare: [Error message: Unable to create prepared statement handle]\n[Last executed query: DEALLOCATE PREPARE mdb2_statement_pgsql_26eaed0e7398ad4cf1b5555ad8ded ce946448dd31]\n[Native message: ERROR: syntax error at or near "end"\nLINE 2: (user_id, start, end, summary, description, locatio...\n ^]\n, referer: https://mailg.kipt.kharkov.ua/?_task...lugin.calendar

From PGSQL:

STATEMENT: INSERT INTO events
(user_id, start, end, summary, description, location, categories, all_day, recurring, rr, expires, occurrences, byday, bymonth, bymonthday, recurrence_id, uid, timestamp)
VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $1
WARNING: nonstandard use of \\ in a string literal at character 30
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
WARNING: nonstandard use of \\ in a string literal at character 165
HINT: Use the escape string syntax for backslashes, e.g., E'\\'.

What should i do?

Thanx in advance!

'end' column name must be quoted using rcube_mdb2::quote_identifier()

And what should I do?

@ alec:

Could you please explain how the queries have to be modified?

Currently f.e.:

PHP Code:

      $query = $this->rcmail->db->query(
        "UPDATE " . get_table_name('events') . " 
         SET start=?, end=?, all_day=?, timestamp=?, notified=?
         WHERE event_id=?
         AND user_id=?",
        $start,
        $end,
        $allDay,
        date('Y-m-d H:i:s', time()),
        0,        
        $id,
        $this->rcmail->user->ID
      ); 


Or would it be better to rename the 'end' table column?

Code:

SET start=?, ".$this->rcmail->db->quote_delimiter('end')."=?, all_day=?, timestamp=?, notified=?

also, to be sure that other columns in different databases are working ok, you should probably use quote_identifier on all columns. I think this will be simpler and prefered than column name change.

After adding this code rcube_mdb2::quote_identifier('end') to plugins/calendar/program/backend/database.php:

$query = $this->rcmail->db->query(
"INSERT INTO " . get_table_name('events') . "
(user_id, start,". rcube_mdb2::quote_identifier('end').", summary, description, location, categories, all
_day, recurring, rr, expires, occurrences, byday, bymonth, bymonthday, recurrence_id, uid, timestamp)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",...

I got this error:

PHP Fatal error: Call to undefined method Database::db_connect() in /usr/local/etc/httpd/webmail/program/include/rcube_mdb2.php on line 456,

Check new release.