Author Topic: RoundCube Calendar (jQuery Calendar)  (Read 76329 times)

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
RoundCube Calendar (jQuery Calendar)
« Reply #15 on: February 09, 2010, 05:11:55 AM »
@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?
« Last Edit: February 09, 2010, 05:24:09 AM by rosali »
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline Lazlo

  • Full Member
  • ***
  • Posts: 50
RoundCube Calendar (jQuery Calendar)
« Reply #16 on: February 09, 2010, 05:17:08 AM »
@rosali
I've seen the changes you made in the previous version. I will port them to 0.2 BETA.

Offline lacri

  • Full Member
  • ***
  • Posts: 179
    • http://www.php-lexikon.de
RoundCube Calendar (jQuery Calendar)
« Reply #17 on: February 09, 2010, 05:47:27 AM »
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

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
RoundCube Calendar (jQuery Calendar)
« Reply #18 on: February 09, 2010, 05:53:49 AM »
Ahh ok ...

Then I was right with my assumption:
Quote

A difference between my VPS and my home server is that RC does not run in a root folder there.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline lacri

  • Full Member
  • ***
  • Posts: 179
    • http://www.php-lexikon.de
RoundCube Calendar (jQuery Calendar)
« Reply #19 on: February 09, 2010, 06:32:50 AM »
to change color of weekend
add to fullcalendar.css


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

Offline Lazlo

  • Full Member
  • ***
  • Posts: 50
RoundCube Calendar (jQuery Calendar)
« Reply #20 on: February 09, 2010, 01:42:10 PM »
Quote from: lacri;25365
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.

Offline bagu

  • Full Member
  • ***
  • Posts: 109
    • Bagu.biz
RoundCube Calendar (jQuery Calendar)
« Reply #21 on: February 09, 2010, 10:32:56 PM »
There is an error when i try to run mysql :

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

phpmyadmin say that the problem is on line 24

Offline voltron81

  • Jr. Member
  • **
  • Posts: 42
RoundCube Calendar (jQuery Calendar)
« Reply #22 on: February 10, 2010, 06:39:47 AM »
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

Offline rosali

  • Hero Member
  • *****
  • Posts: 2,533
RoundCube Calendar (jQuery Calendar)
« Reply #23 on: February 10, 2010, 07:29:31 AM »
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.
Regards,
Rosali
__________________
MyRoundcube Project (commercial)

Offline lacri

  • Full Member
  • ***
  • Posts: 179
    • http://www.php-lexikon.de
set public $task
« Reply #24 on: February 10, 2010, 08:50:28 AM »
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).*';

Offline bagu

  • Full Member
  • ***
  • Posts: 109
    • Bagu.biz
RoundCube Calendar (jQuery Calendar)
« Reply #25 on: February 10, 2010, 09:08:17 AM »
no one else have an error when trying to import mysql.sql ?

Offline Scarabaeus

  • Jr. Member
  • **
  • Posts: 13
RoundCube Calendar (jQuery Calendar)
« Reply #26 on: February 10, 2010, 10:10:15 AM »
@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
hMailServer 5.3.3 - Build 1879 | ClamAV 0.96.5 (tBB) | SpamAssassin 3.2.3.5
AfterLogic Webmail Pro 6.3.10 | RoundCube 0.7.1
WampServer 2.0i - [ Apache 2.2.11 | MySQL 5.1.36 | PHP 5.3.0 ]

Offline haocheng

  • Newbie
  • *
  • Posts: 5
RoundCube Calendar (jQuery Calendar)
« Reply #27 on: February 10, 2010, 10:47:41 AM »
This is a very good plugin , Thank your sharing ,

Can addon Public function ?

Offline Lazlo

  • Full Member
  • ***
  • Posts: 50
RoundCube Calendar (jQuery Calendar)
« Reply #28 on: February 10, 2010, 11:39:47 AM »
Quote from: bagu;25409
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]

    /*!40008
      ON DELETE CASCADE
      ON UPDATE CASCADE */
« Last Edit: February 10, 2010, 11:47:20 AM by Lazlo »

Offline Lazlo

  • Full Member
  • ***
  • Posts: 50
RoundCube Calendar (jQuery Calendar)
« Reply #29 on: February 10, 2010, 11:40:57 AM »
Quote from: haocheng;25414
This is a very good plugin , Thank your sharing ,

Can addon Public function ?


Thanks,

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