Thread: Roundcube calendar plugin not working

Looks like you did not not create 'events' database table correctly. What is in Roundcube's error log?

I dont see any errors logged. I have enabled debug logging level to 8, I see only 3 files under /roundcubemail/logs folder. console, userlogin, and sendmail. These logs are not showing any errors related to the issue. Is there any other logging I need to increase ? (sorry this is very basic question)

Also, I did create events table under roundcubemail database using mysql.sql script. I can see events table listed under roundcubemail database. Does it require any permission to be added to this database or table after this?

Are you able/willing to give me a test account, phpmyadmin access and read/write/delete FTP access to roundcube folder? PM'me! This problem was reported by another user as well, but has been never solved. I need to reproduce the issue to track it down.

Hello Rosali,

We were able to resolve the issue by adding following code to roundcybemail-0.3.1/program/include/rcube_shared.inc


if (!function_exists('json_encode'))
{
function json_encode($a=false)
{
if (is_null($a)) return 'null';
if ($a === false) return 'false';
if ($a === true) return 'true';
if (is_scalar($a))
{
if (is_float($a))
{
// Always use "." for floats.
return floatval(str_replace(",", ".", strval($a)));
}

if (is_string($a))
{
static $jsonReplaces = array(array("\\", "/", "\n", "\t", "\r", "\b", "\f", '"'), array('\\\\', '\\/', '\\n', '\\t', '\\r', '\\b', '\\f', '\"'));
return '"' . str_replace($jsonReplaces[0], $jsonReplaces[1], $a) . '"';
}
else
return $a;
}
$isList = true;
for ($i = 0, reset($a); $i < count($a); $i++, next($a))
{
if (key($a) !== $i)
{
$isList = false;
break;
}
}
$result = array();
if ($isList)
{
foreach ($a as $v) $result[] = json_encode($v);
return '[' . join(',', $result) . ']';
}
else
{
foreach ($a as $k => $v) $result[] = json_encode($k).':'.json_encode($v);
return '{' . join(',', $result) . '}';
}
}
}

I am able to repro this issue and it resolves with this code change. Hope this will be helpful for someone

Hi,

Just installed Roundcube and working fine. Attempted to install the Roundcube Calendar plugin:

RoundCube Calendar

I imported the .sql file and see the "events" table but do not see any Calenaer Button under the menu nor can I pull up
/plugins/calenadar/calendar.php.

Any help would be greatly appreciated.

Thanks,
-Todd

Did you add the calendar to the $rcmail_config['plugins'] in the <RC root>/config/main.inc.php

the calendar may not work with RC 0.2, because of jquery. Am I correct?

Hey guys, I'm also getting the "server error (OK)" message when I try to add events. It also displays when I browse to the calendar.

I've made sure that the 'events' table exists (I used PHPMyAdmin and copy-pasted the contents of the SQL file in there) and tried the mode that pinemail11 posted. Still no dice

My log shows this at the bottom:

Code:

[09-Jun-2010 15:54:11 -0700]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_3055a37261af92c267005b94743a05546006f9f31 FROM 'DELETE FROM events\r\n         WHERE user_id=?\r\n         AND del=?']
[Native code: 1054]
[Native message: Unknown column 'del' in 'where clause']
 in /nfs/c06/h04/mnt/95491/domains/zandadev.com/html/roundcube/program/include/rcube_mdb2.php on line 272 (POST /roundcube/?_task=dummy&_action=plugin.calendar_purge?_task=&_action=)
[09-Jun-2010 15:54:12] MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_38e7b9010444d91ca7db9000380ab8fa6b14c230b FROM 'SELECT * FROM events \r\n         WHERE user_id=? AND recurrence_id<>0']
[Native code: 1054]
[Native message: Unknown column 'recurrence_id' in 'where clause']

[09-Jun-2010 15:54:12 -0700]: DB Error: _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_38e7b9010444d91ca7db9000380ab8fa6b14c230b FROM 'SELECT * FROM events \r\n         WHERE user_id=? AND recurrence_id<>0']
[Native code: 1054]
[Native message: Unknown column 'recurrence_id' in 'where clause']
 in /nfs/c06/h04/mnt/95491/domains/zandadev.com/html/roundcube/program/include/rcube_mdb2.php on line 272 (GET /roundcube/?_task=dummy&_action=plugin.getEvents&_=1276210340633&start=1275796800&end=1276401600)

Any ideas? Please let me know what other information I should provide.

Thanks in advance!