Thread: RoundCube Calendar (jQuery Calendar)

There is an error when i try to run mysql :

Code:

#1005 - Can't create table 'roundcubemail.events' (Errcode: 150)

phpmyadmin say that the problem is on line 24

Hi.
This morning I was trying your calendar plugin for roundcube.
I'm using roundcube 0.3.
Basically I've installed it as you said and I've run the SQL file.
In the webpage there is the Calendar, and if I click on it I can add an event
But, after added it, I can not see it on the calendar...
I had a look to the database and in the table events there are all my
events... so it's look like the plugin is able to write in the
database, but it's not retreiving data from the database.
Am I wrong in something or it's a problem of the plugin?

Thanks

There is a bug in the code if your RC does not run in a root folder of an URL. See the fix posted by "lacri". Also I recommend to use Roundcube 0.3.1 or current SVN.

here is a little optimization to set task

addressbook task is missing and some other task in my case

with this change is task set correct to all excluding login and logout.
replace on line 16 in calendar.php

PHP Code:

public $task = 'mail|settings'; 


with

PHP Code:

// all task excluding 'login' and 'logout'
public $task = '?(?!login|logout).*'; 


no one else have an error when trying to import mysql.sql ?

@bagu
You are not alone; I have experienced a similar problem with the mysql.sql file. My errcode differs from yours. Mine is 121 I believe.

I have yet to find a solution. (MySQL skill level = LOW)
Will post back if I discover a solution outside the forum.

But help from forum members will be greatly appreciated.

regards

This is a very good plugin , Thank your sharing ,

Can addon Public function ?

Originally Posted by bagu

no one else have an error when trying to import mysql.sql ?

This is a MySQL bug: MySQL Bugs: #46293: Conditional comments not working in FOREIGN KEY definition

A temporary fix:

Remove from mysql.sql

Code:

    /*!40008
      ON DELETE CASCADE
      ON UPDATE CASCADE */

Originally Posted by haocheng

This is a very good plugin , Thank your sharing ,

Can addon Public function ?

Thanks,

I don't understand "Can addon Public function ?". Please explain.