RoundCube Calendar (jQuery Calendar)

[rosali]

@Lazlo:
There is another problem we have to work out. If the Client and the webserver are not within the same timezone the events on the client are out of sync with the database. I included already a solution in previous weekcalendar: Save events in database always GMT and return to client converted by Roundcube's timezone settings.

@lacri:
Please PM'me (deutsch). I don't understand your last Post. You are saying you have the same problems as I experience on my home environment?

[Lazlo]

@rosali
I've seen the changes you made in the previous version. I will port them to 0.2 BETA.

[lacri]

i have found the bug

in calendar.js on line 34

search
events: "/?_action=plugin.getEvents",

replace with
events: "./?_action=plugin.getEvents",

a simple point with large effect

[rosali]

Ahh ok ...

Then I was right with my assumption:

A difference between my VPS and my home server is that RC does not run in a root folder there.

[lacri]

to change color of weekend
add to fullcalendar.css


.fc-sat,
.fc-sun {
    color: #CC3333;
}

[Lazlo]

i have found the bug

in calendar.js on line 34

search
events: "/?_action=plugin.getEvents",

replace with
events: "./?_action=plugin.getEvents",

a simple point with large effect

Fixed it, thanks.

[bagu]

There is an error when i try to run mysql :

Code Select Expand

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

phpmyadmin say that the problem is on line 24

[voltron81]

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

[rosali]

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.

[lacri]

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
public $task = 'mail|settings';with
// all task excluding 'login' and 'logout'
public $task = '?(?!login|logout).*';

[bagu]

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

[Scarabaeus]

@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

[haocheng]

This is a very good plugin , Thank your sharing ,

Can addon Public function ?

[Lazlo]

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 Select Expand


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

[Lazlo]

This is a very good plugin , Thank your sharing ,

Can addon Public function ?

Thanks,

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