jQuery Fullcalendar plugin (forked by rosali)

[dziobak]

this is strange. everything works for me...

Edit:
If you want to write on someone else calendar you need to change view to his/her calendar in right-bottom corner (there must be enable access by adding a calendar feed).

[rosali]

If you have problems to save feeds (like Ruediger) most likely it is due to PHP cURL module.

It checks if a cURL connection from webserver to the feed url returns a valid output (valid is a json encoded array or a xml page). If the test fails the feed url is not saved. So what happens if you insert the feedurl in a serparate browser tab or window?

[bagu]

Rosali, when trying your version, i get an error on create table :
Errcode: 150

So i modify the sql like this waiting a solution :

Code Select Expand

CREATE TABLE `events` (
  `event_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `uid` text,
  `recurrence_id` text,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `start` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `end` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `expires` datetime NOT NULL DEFAULT '9999-12-31 23:59:59',  
  `recurring` int(8) NOT NULL DEFAULT '0',
  `occurrences` int(11) DEFAULT '0',
  `byday` text,
  `summary` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `location` varchar(255) NOT NULL DEFAULT '',
  `categories` varchar(255) NOT NULL DEFAULT '',
  `all_day` tinyint(1) NOT NULL DEFAULT '0',
  `group` text,
  `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `del` int(1) NOT NULL DEFAULT '0',
 PRIMARY KEY (`event_id`)
)  ENGINE=INNODB   CHARACTER SET utf8 COLLATE utf8_general_ci
An other question : how can i setup a google calendar interaction for only one user (read and write) ?

[rosali]

@ Granada:

Do you use recent release from myroundcube.googlecode.com?

calendar.php - myroundcube - Project Hosting on Google Code

Line 1066 is empty, so your PHP Warning can't throw an error there.

@ bagu:
Please point out your modifcations.

[bagu]

The modification is i remove :

Code Select Expand

CONSTRAINT `user_id_fk_events` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
I use mysql 5.1.47 on windows xp pro + apache 2.2.15 and php 5.2.13 and roundcube 0.4beta (i don't know the svn version)

[rosali]

You can use it with your modification. But events table will not be linked to users table. This means if you erase a user, events linked to that user will not be removed from events table. I would upgrade to svn trunk including database modifications.

[bagu]

I change your code only because i receive en error...
If you have a solution to avoid the error, you're welcome because your plugin is really appreciate in my office

[rosali]

IMO, you receive this error because your Roundcube database is not up to date or it is not InnoDB which means it does not support foreign keys ...

InnoDB - Wikipedia, the free encyclopedia

[bagu]

That's it !

Some of my tables are in myisam.
Thanks a lot.

Everything work fine after innodb convertion

[Granada]

@Rosali:

I used the version from the current trunk 3649. The files in there differ a bit from the current svn-tree, which I checked out just a few minutes ago.
Saving calendar feeds still does not work, the mentioned PHP-errors are still present, but now in lines 1060 and 1067:

Code Select Expand

[28-May-2010 08:28:56] PHP Warning:  array_combine() [<a href='function.array-combine'>function.array-combine</a>]: Both parameters should have an equal number of elemen
ts in /usr/local/htdocs/roundcube-0.4beta/plugins/calendar/calendar.php on line 1060
[28-May-2010 08:28:56] PHP Warning:  Invalid argument supplied for foreach() in /usr/local/htdocs/roundcube-0.4beta/plugins/calendar/calendar.php on line 1067

I also rechecked the structure of the events table - it's completely sane and as it should be.

Edit: don't know if it matters: system is Solaris SunOS 5.10 sparc, Apache 2.0.63, PHP 5.2.6, MySQL 5.0.84.

Regards
Ruediger

[rosali]

I see the problem now. Can you confirm that you can save feed URLs if you don't comment out:

// event feeds (can be deleted by user)
$rcmail_config['calendarfeeds'] = array(
  'http://www.google.com/calendar/feeds/[email protected]/public/basic' => 'Google',
);

// public calendar (can't be deleted by user)
$rcmail_config['public_calendarfeeds'] = array(
  'http://www.google.com/calendar/feeds/[email protected]/public/basic' => 'Public', 
);

[Granada]

Argh! Now I get another error, need to upgrade PHP (libcurl is missing ...).

Regards
Ruediger

[rosali]

This thread holds post moved from http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6161-roundcube-calendar-jquery-calendar.html.

The original thread was rather crowdy. Free different plugins were discussed:

(*) jQuery Weekcalendar plugin (deprecated)
(*) jQuery Fullcalendar plugin (developed by Lazlo)
(*) jQuery Fullcalendar myroundcube plugin (based on Lazlo initial version and forked by rosali)

[bagu]

In same time, php 5.2.6 is quite old and buggy

[Granada]

Recompiled PHP with libcurl enabled and now RC says everything was fine ("Erfolgreich gespeichert" .i.e. in german), but it still does not save any changes made to the calendar feeds. Neither can I add any feed nor can I delete the preset google-feed.

PHP 5.2.6 might be quite old, but an upgrade is not possible right now.

Regards
Ruediger