Roundcube Community Forum
Third Party Contributions => API Based Plugins => Topic started by: horfic on March 07, 2010, 07:39:25 PM
-
Feature Request:
Managable categories (add, delete, rename, color choice)
-
It's in the pipeline ...
-
Feature Request:
1. In create/edit mode start/end date (round to 15 min.) of events.
2. In options to add/remove labels
3. Email notification with notification time input and activation checkbox in create/edit mode
Grate work!!
-
Is there any progress with this plugin?
Posted via Mobile Device
-
@ dzobiak:
Yes, there is some progress. I have forked the plugin and will release my version soon.
It supports recurring events, import of ics files, customizable categories,
google calendar layers and it has an option to be notified by email on any kind of event changing.
It will not have an event reminder (not yet but on the ToDo's).
I have removed the CalDAV backend because it has to be re-implemented due
to new structure of the backend class.
You can check my current developing status @ Mail4us.net Webmail :: Welcome to Mail4us.net Webmail (http://mail4us.net).
-
So your fork will not work with CalDAV servers? Doesn't seem all that helpful.
-
@roe1234:
Rosali wrote that CalDav functionality has to be re-implemented
@Rosali:
Nice work. But I have a little problem with New Event Window. I do not see anything from the middle of the calendar. I think that this is because of frames with google ads. If I display only Roundcube frame it works perfectly. So you should add scrolling to main frame.
-
@ dzobiak:
Yes, there is some progress. I have forked the plugin and will release my version soon.
It supports recurring events, import of ics files, customizable categories,
google calendar layers and it has an option to be notified by email on any kind of event changing.
I am about ready to commit an extension to the calendar plugin that detects ics attachments when an email is opened, and asks the user if they would like to add the event to their calendar. Hopefully this will not conflict with your ics import (which I imagine is more a mirror of the ics export, fully within the calendar interface). We may need to coordinate...
-
@tjm74: My ICS import already detects ics attachments and adds a footer to the displayed email just like the vcard_attachments (bundled with default Roundcube).
@zobiak: Which screen resolution? Could you post a screeny?
-
I was seeing this on wife's notebook where max resolution is 1280:800 (wide) in this week i don't have a possibility to make a screen...
IMO you should add scroll to the main frame like this:
google....|...webmail.......(scroll)|google
frame.....|...main frame...(scroll)|frame
(in firefox) when I open only main frame i see the scroll and everything is OK
-
HI Rosali,
I'm watching your changes in calendar plugin and I'm interested in adding it to my servers ;-)
When will you finish new version?
-
Hi dziobak,
the following things are still under developement:
#1 - Layers accessible by a token just like google calendar
#2 - Filter to display selected categories only.
I will have limited internet access the next few weeks. So if you PM'me your contact details I'll send you a copy of the current developement version.
-
@Rosali
I have installed the version you sent me and i have two things/suggestions.
1. IMO you are one step from making a public calendar. Is it in yours TODO? Maybe something like in globaladdressbook, where is a global user? You could also make a public-calendar admin group to insert/delete events?
2. In Calendar Feed options, (IMO) it will be better to make a token-generate buttons (one for red-only and one to read/write).
If you have another version, you can send it to me for testing.
-
My version is working in process.
IMO, we don't need a global user. It's up to the admin to setup a global user and to define a public token. Or do I misunderstand something here?
The token generator is on the TODO's ... currently I'm working on filters.
Any suggestions are appreciated.
-
I thought about, that only defined in config-file users can access a public-calendar using that icon left-bottom corner (change calendar), where he would have be written in brackets "public".
-
We can almost archieve that. F.e. if caladmin@mydomain.com is calendar admin you can create a public access url (readonly or read/write) and add it to the config.
The only thing which is missing is to make sure that this url can't be deleted by users and to have a default category for it.
Where is the need to grant access only for certain users?
-
what do you thing about this
1. create calendar user in database f.e. public_calendar@domain.com
2. Add this account to calendar config file to public calendar variable, add calendar admins to array and eventually define a public calendar category color.
3. users automatically see the public calendar without making tokens or creating feeds. users have it in read only mode, admins in full mode.
and what do you thing about permission to read/write but without deleting? it can be used to add someone else an event in calendar. when that someone else enter the calendar can accept or decline this event.
-
That's what I'm talking about. IMO we do not need admins. Just login as public_calendar@domain.com to have full access to the "public" calendar.
Sorry, I won't add more groupware functionality yet. The current concept needs a third token for that.
I will release the calendar next weekend. Perhaps someone else volunteers to improve groupware functionality.
-
I have released forked version (myroundcube - Project Hosting on Google Code (http://myroundcube.googlecode.com)).
(*) Recurring events
(*) Customizable categories
(*) Email notifications on event changes
(*) Shared calendars
(*) Google layers
(*) Event filters
(*) May be more I do not remember yet ...
-
Nice modification Rosali.
I have found a bug/problem. When creating/editing event theres a problem with expire input.
1. It shouldn't be read only - I think
2. Look in attachment - strange dates (input) when i click on any date (small calendar)
-
Hmmm ... works for me. Which browser?
-
FF 3.6.3 (on IE 8 works OK)
-
./plugins/calendar/program/js/calendar.js :: ~line 140
document.forms.form.expires.value = mydate.getFullYear() + "-" + smonth + "-" + sday + " 23:59:59";
Use 'getFullYear' instead of getYear. Thanks for the bug report!
-
Yes. Now it's OK.
Thanks Rosali.
PS
Check PW
-
Is there any way to import ics file?
-
Yes. Launch new event adding dialog and upload ics file.
-
One question more: is this functionality implemented or I have problems to run it?
@tjm74: My ICS import already detects ics attachments and adds a footer to the displayed email just like the vcard_attachments (bundled with default Roundcube).
-
It is implemented. If you have problems, please send me the ics file.
-
I have sent you an email.
-
another bug...
I have changed i config.inc.php categories to polish names with polish characters. Everything is fine until hitting save button in Options->Calendar (where are categories). The polish letters disappear, they aren't write to DB.
F.E. - 'Holidays' -> 'Święta' is written 'wita'.
-
Rosali, what do you thing about creating a new event not by one-click but double-click? is it hard to change?
-
1. Non ASCII characters in categories:
I do not find a way to allow non ascii characters because fullcalendar backend use the category value to define css styles (only ascii allowed).
2. Double click:
I don't want to do that because we would have to hack the third party fullcalendar backend. Goto fullcalendar support (FullCalendar - Support (http://arshaw.com/fullcalendar/support)) and ask there.
-
1. Maybe you could insert somewhere in the code coding to html chars (with &) before inserting to database?
2. I'll try it
-
Interested as well, github seems to be quiet as well, or so not very active.
-
See my footer for download.
-
An extra DB driver for calendar?
RC runs fine on my postgres, its using the same DB like my mailserver does (thats why I have the webmail_ -prefix) even the mailadresses according to an account are correct fetched at 1st login.
In calendear I set unlike default:
$rcmail_config['use_calendar'] = 'calendar';
$rcmail_config['db_table_events'] = 'webmail_events';
Did I miss something?
:confused:
K.
Hi Katie
Did you ever get it to work?? RC with calendar on postgresSQL ?
/Blueyed1
-
First off I would like to say thanks for all the work done on this wonderful plugin. I have successfully got the 0.2 beta plugin working with iRedMail 0.5.1 after upgrading to Roundcube mail to version 0.3.1. The biggest glitch (if it was a glitch) was having to rename/add a few fields to my mysql events table. I do see in the latest SVN that the names are now correct, I may have had a newer version mixed in by mistake with 0.2 beta.
Anyhow, I have a question, is the attachment of files in calendar entries working? So far all I get is a "Unable to import calendar file" error. My roundcube log shows the following, "roundcube: PHP Warning: Invalid argument supplied for foreach() in /var/www/roundcubemail-0.3.1/plugins/calendar/calendar.php on line 1096".
I tried to track down the offending code in calendar.php but the line 1096 is referenced in an include somewhere so I need some help tracking it down.
If the attachment feature is not available (I am assuming it isn't available since the mysql table does not reference attachments at all) is there a way to hide the upload function on the add entry form?
Cheers,
Cory
Update: I did find the offending code but i am not sure what to make of it, it is erroring on the usersSelector function:
function usersSelector($p) {
$rcmail = rcmail::get_instance();
$feeds = $rcmail->config->get('calendarfeeds');
$out = '<option value="' . $rcmail->user->data['user_id'] . '">' . $rcmail->user->data['username'] . '</option>' . "\r\n";;
foreach($feeds as $feed => $category){
$temparr = parse_url($feed);
if(!empty($temparr['query'])){
$temparr = explode("&",$temparr['query']);
if($temparr[0] == '_task=dummy' && $temparr[1] = '_action=plugin.calendar_showlayer' && count($temparr) == 4){
$temp = explode('=',$temparr[2]);
$userid = $temp[1];
$arr = $this->getUser($userid);
$out .= '<option value="' . $userid . '">' . $arr['username'] . '</option>' . "\r\n";
}
}
}
$p['content'] = $out;
return $p;
}
-
did you install the calendar from Rosali's trunk?
-
I am pretty sure I didn't install from the trunk. I will have to verify what version I did install though. But I did notice that on Rosali's demo site located at Mail4us.net Webmail :: Welcome to Mail4us.net Webmail (http://mail4us.net/) the attachment function is broken as well. Should i take that as an indicator the function is not yet working?
-
Well, I took the plunge and installed the latest SVN of the jQuery calendar LazloNL's roundcube-calendar at master - GitHub (http://github.com/LazloNL/roundcube-calendar/). All my issues with the calendar have been solved. The features I was having issues with have been removed to streamline the interface to what works for now (I am assuming this, correct me if I am wrong). All in all, it is very nice.
I am almost to the point where I feel comfortable putting this into production for a student mail platform for the college I work at. I am writing a generic Php/Mysql class so that I can pull student data from our information system and create email accounts automatically. From there I plan to create some automation tools to register students into our moodle based classes. Way beyond the scope of this forum but I thought some people might like to know how I am integrating some of these awesome tools.
Cheers! ;D
-
Maybe this weekend Rosali release new version of it so you can try it. remember that in Rosali's version the table events (in db) is changed.
-
Hello Help me please. What do I need to fix in the code to get the date format of the form dd: mm: yy. ??? Thank you.
-
FullCalendar Documentation - columnFormat (http://arshaw.com/fullcalendar/docs/text/columnFormat/)
-
Hi to everybody.
This plugin is just amazing.
I'm testing it since a coulple of months and I really like it.
I'm just a bit confuse about the new features...
I can read that the last version have this features:
(*) Recurring events
(*) Customizable categories
(*) Email notifications on event changes
(*) Shared calendars
(*) Google layers
(*) Event filters
(*) May be more I do not remember yet ...
I've installed the last version, but I can not understand how to use this features...
For example for the shared calendar, in the forum I can read that:
Just login as public_calendar@domain.com to have full access to the "public" calendar.
Do I need to create an user public_calendar@domain.com???
The other feature that is very interesting for me is the Email notifications on event changes, but even that is a kind of black box for me... there is a place where I can read something more about how to use this features?
Thanks
Michele
-
Where did you download the plugin from?
The features you mentioned are part of my forked plugin which is availabled bundled with my other plugins @ myroundcube - Project Hosting on Google Code (http://myroundcube.googlecode.com).
-
Thanks Rosali,
I'll try it now.
Do I need to upgrade the mysql database as well or is enough to move the new calendar folder in the plugin directory?
Thanks
Michele
-
You have to modify the database aswell. The final release which is scheduled for the weekend will need further database modifications.
-
Hi rosali,
thanks for the reply.
I've downloaded your last version.
I've modified the mysql database with the command:
mysqldump -u user -p roundcubemail < mysql.sql
and I've modified the file /config/config.inc.php, putting "database" as backend.
On roundcube I can see the new plugin (it's actually really nice).
I can also see the old events (the one that was on the database with the old version of the plugin), but I can not save a new event (I'm having this error message: Server error (Internal Server Error).
I guess is something wrong with mysql.
Am I wrong in something?
Thanks
Michele
-
Use phpmyadmin and check if your events table has exactly the structure as shown in mysql.sql.
I'm not sure if it is compatible with old events. Best would be to start with a new database table.
Before deleting the old one, export the events. Then check if you can create new events.
If that's ok, then finally re-import old events and check again.
__________
EDIT: What is in the errors log?
-
Hi rosali.
At the end I've cancelled the table events and created it again according with the new mysql file and it's look like working now...
How can I try now the features? For example the shared calendar and the email notification...
Anyway I will be more than happy to test your final version this weekend...
thanks
Michele
-
Check settings (Calendar feeds and Calendar).
To share a calendar the one party has to generate a token URL (read or read/write) and the other party has to add these URL to its layers.
It basically works like google calendar access URLs.
-
Mmm I'm not exatly sure to have understood what do you mean...
Anyway I'll have a look how google calendar is working, then maybe it will appear more clear... :o
Thanks
Michele
-
Hi rosali,
I've just installed your last version of the calendar plugin and it's working really good.
Just a couple of questions.
1) If i want to upload an outlook calendar file, do I need to create an event and then upload that file? If in that file there will be 100 events for 100 different days, does the system upload all of them? Because it looks like it doesn't read an outlook calendar file (strange behaviuor)
2)There is a way to connect this calendar to an exchange calendar, so that they will be automatically sync? (of course I'm talking about a local roundcube installation, so the connection between roundcube and exchange is local)
3)still I don't understand how to share a calendar between more users...
Thanks
Michele
-
#1 - Send me an Outlook upload file for testing.
#2 - Only Thunderbird / Lightning is supported ... I do not have ($$$) Exchange.
#3 - Sharing calendars is easy:
User A wants to share with User B...
User A: Settings -> Calendar Feeds -> enable Token read/write access and/or read only access
User A: Now you should see a Feed URL
User A: Pass this URL to User B (either the read/write URL or the read only URL)
User B: User B has to add this URL to Calendar Feeds (First Fieldset in Settings -> Calendar Feeds)
User B has to do the same steps to share with User A.
OK?
-
Hi Rosali,
I'm making the calendar sharing as you said, but it's look like not working...
I'm following exatly your instructions...
:eek:
Thanks
Michele
-
Give me two test accounts on your machine and PM'me login details.
If it works for it should work for you too.
-
Sharing calendars among users does not work here, too. Installed the new version of the calendar plugin over the old one and newly generated the mysql-table. Adding a calendar feed via the settings leads to some PHP-warnings in the log, but nothing critical:
[27-May-2010 15:04:28] PHP Warning: array_combine() [function.array-combine]: Both parameters should have an equal number of elements in /usr/local/htdocs/roundcube0.4beta/plugins/calendar/calendar.php on line 1059
[27-May-2010 15:04:28] PHP Warning: Invalid argument supplied for foreach() in /usr/local/htdocs/roundcube-0.4beta/plugins/calendar/calendar.php on line 1066
But it's no wonder the sharig does not work: no data is written to the user's config entry in the database and reloading the settings tab shows no entry at all.
Apart from that I'd like to have calendar sharing made in a different way: would it be possible to select users from the address book that I want to allow to view my calendar? That seems much more intuitive to me.
Regards
Ruediger
-
Could please post your calendar config file?
-
You mean ~plugins/calendar/config/config.inc.php? Mine looks like this:
// backend type (dummy, database), see README
// Note: "dummy" is only for demonstrating basic functionality.
$rcmail_config['backend'] = "database";
/* database table name */
$rcmail_config['db_table_events'] = 'events';
// default calendar view (agendaDay, agendaWeek, month)
$rcmail_config['default_view'] = "agendaWeek";
// time format (HH:mm, H:mm, h:mmt)
$rcmail_config['time_format'] = "HH:mm";
// timeslots per hour (1, 2, 3, 4, 6)
$rcmail_config['timeslots'] = 2;
// first day of the week (0-6)
$rcmail_config['first_day'] = 1;
// first hour of the calendar (0-23)
$rcmail_config['first_hour'] = 6;
// event categories (can be modified by user)
$rcmail_config['categories'] = array(
'Personal' => 'c0c0c0',
'Work' => 'ff0000',
'Family' => '00ff00',
'Holiday' => 'ff6600',
);
// public calendar categories (can't be modified by user)
$rcmail_config['public_categories'] = array(
'Public' => 'ff6600',
);
// work days (0 = Sunday)
$rcmail_config['workdays'] = array(1,2,3,4,5);
// default event duration in hours (e.g. 0.25, 0.5, 1, 2 ...)
$rcmail_config['default_duration'] = 1;
// event feeds (can be deleted by user)
$rcmail_config['calendarfeeds'] = array(
//'http://www.google.com/calendar/feeds/usa__en@holiday.calendar.google.com/public/basic' => 'Google',
);
// public calendar (can't be deleted by user)
$rcmail_config['public_calendarfeeds'] = array(
'http://www.google.com/calendar/feeds/austrian__de@holiday.calendar.google.com/public/basic' => 'Public',
);
?>
Regards
Ruediger
Edit: Who set this topic's icon to "thumbs down"? I did not - at least not intentionally! The calendar plugin is worth developing!
-
Hi Rosali,
unfortunately I'm trying this calendar plugin on a local machine that is not online (this roundcube installation is just to read local emails from local users).
So let's wait some more feedback from somebody else then...
thanks
Michele
-
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).
-
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?
-
Rosali, when trying your version, i get an error on create table :
Errcode: 150
So i modify the sql like this waiting a solution :
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) ?
-
@ Granada:
Do you use recent release from myroundcube.googlecode.com?
calendar.php - myroundcube - Project Hosting on Google Code (http://code.google.com/p/myroundcube/source/browse/trunk/plugins/calendar/calendar.php)
Line 1066 is empty, so your PHP Warning can't throw an error there.
@ bagu:
Please point out your modifcations.
-
The modification is i remove :
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)
-
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.
-
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 ;)
-
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 (http://en.wikipedia.org/wiki/InnoDB)
-
That's it !
Some of my tables are in myisam.
Thanks a lot.
Everything work fine after innodb convertion
-
@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:
[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
-
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/usa__en@holiday.calendar.google.com/public/basic' => 'Google',
);
// public calendar (can't be deleted by user)
$rcmail_config['public_calendarfeeds'] = array(
'http://www.google.com/calendar/feeds/german__de@holiday.calendar.google.com/public/basic' => 'Public',
);
-
Argh! Now I get another error, need to upgrade PHP (libcurl is missing ...). :o
Regards
Ruediger
-
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)
-
In same time, php 5.2.6 is quite old and buggy
-
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
-
Same Problem here with actual PHP.
Thomas
-
Please test if attached package solves problems when saving Feed URLs.
If you still have problems, there is a hidden test routine:
#1- Login to your account
#2- Enter URL http://.../?_task=dummy&_action=plugin.calendar_tests
Tests are very appreciated!
-
No probs with this file. :)
-
I don't know if this is relevant to anyone else's problems but I was also having trouble with the calendar plugin where it wouldn't save entries to the database. Even with the new calendar.zip it didn't work.
After some investigation I discovered that this was due to curl not being able to valid my self signed certificate, even though browsers had no problem with it (yes, I'm using a secure server for RoundCube).
I sorted the save problem by adding a new variable to config.inc.php:-
$rcmail_config['pathtosslcert'] = "/root/sslCA/cacert.pem";
(that's not the real path)
and putting this in the calendar.php:-
$local_ssl = $rcmail->config->get('pathtosslcert');
if ($local_ssl) {
curl_setopt ($ch, CURLOPT_CAINFO, $local_ssl);
}
just before the '$cr = curl_exec($ch);' in the functions saveSettings and fetchLayer.
That allowed calendar to find my certificate, save my entries and hopefully will allow it to pickup any local public feeds I create.
I would just like to mention that before your latest calendar.zip the saved entries didn't show on the calendar even though I had persuaded them to be saved in the database, but the change you made to arrayEvents in utils.php has fixed this.
All in all this is a very nice plugin, keep up the good work.
Ant
-
Thanks for the hack. I will apply it in next release.
-
Hello...
I installed the calendar plugin and I tried to fill some calendar feeds from google....
But when I press save it doesnt work, because after that, the calendar feed line is empty again.
What can I do ?
-
Try if it works on other user and post here result
-
Hello....
with another user it also doesnt work...
Sometimes it says saved and sometimes i get an Error 500 Page when i save
-
post here your error log
-
[08-Jun-2010 09:58:00] PHP Warning: array_combine() [<a href='function.array-combine'>function.array-combine</a>]: Both parameters should have an equal number of elements in /var/www/ispcp/gui/tools/roundcube/plugins/calendar/calendar.php on line 1059
[08-Jun-2010 09:58:00] PHP Warning: Invalid argument supplied for foreach() in /var/www/ispcp/gui/tools/roundcube/plugins/calendar/calendar.php on line 1066
Thank you for your help :)
-
are you using the calendar from trunk-71 and RC svn-trunk?
-
I downloaded and installed this trunk-r-3649.zip MyRoundCube Plugins Collection (RC SVN r3649) UPDATE 2010-05-26 09:30 a.m
-
Try install this version:
http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6782-jquery-fullcalendar-plugin-forked-rosali-8.html#post27757 (http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6782-jquery-fullcalendar-plugin-forked-rosali-8.html#post27757)
-
Then I get a Error 500 when I tried to save ...
And Error log:
Call to undefined function curl_init() in /var/www/ispcp/gui/tools/roundcube/plugins/calendar/calendar.php on line 1753
-
Calendar feeds require PHP cURL module. Looks like it is missing in your PHP.
A side notice: RC spell checking in HTML mode requires cURL aswell. You may have problems there too.
-
Curl an ZendOptimizer are now installed...
Now I get this Error:
[09-Jun-2010 07:35:30] PHP Warning: Invalid argument supplied for foreach() in /var/www/ispcp/gui/tools/roundcube/plugins/calendar/calendar.php on line 1279
edit: I solved the problem with a fresh install an the gdata api...
-
Is there any way to get the calendar plugin to work with SQLite? I have a very limited performance server, so that's what I use for RC right now.
-
for now it is working only on mysql. Calendar plugin is still improved, so i think that in near future it won't be working on other db then mysql.
-
Is there a doc or an explaination to make interaction (read/write) possible between calendar for only one user and his google calendar ?
-
there is no backend for google calendar yet
-
@ danpep:
I'm not familiar with SQLite. But it should work with SQLite if somebody would code a events table creation script based on the included MySQL script:
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',
`rr` varchar(1) default NULL,
`recurring` text NOT NULL,
`occurrences` int(11) DEFAULT '0',
`byday` text,
`bymonth` text,
`bymonthday` 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`),
CONSTRAINT `user_id_fk_events` FOREIGN KEY (`user_id`)
REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=INNODB CHARACTER SET utf8 COLLATE utf8_general_ci
-
Hi.
Are there any plans to add support for Outlook calender/meeting mails?
Would be great if you could respond to them and have the appointment added to your calendar in roundcube.
I dont know if you are familiar with them, but the emails look somewhat like this (not full mail, only the beginning).
BEGIN:VCALENDAR
METHOD:REQUEST
PRODID:Microsoft Exchange Server 2007
VERSION:2.0
BEGIN:VTIMEZONE
TZID:Pacific Standard Time
BEGIN:STANDARD
DTSTART:16010101T020000
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
RRULE:FREQ=YEARLY;INTERVAL=1;BYDAY=1SU;BYMONTH=11
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:16010101T020000
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
...
...
...
-
there no backend for MS Office for now.
-
Im not looking for a backend for MS Office, just that the roundcube-calendar can parse those mails and add them to the roundcube calendar and also send a reply.
And i know it is nothing like that for now, but you would not need that to accomplish what im after.
-
@ Ishra:
Send me an outlook invitation mail to myroundcube [at] mail4us.net.
-
Hello there!
I just checked out the latest version from SVN, and realised that the two files caldav.php and caldav-client.php are missing from the backend directory:
Warning: calendar::require(program/backend/caldav.php) [function.calendar-require]: failed to open stream: No such file or directory in /var/www/domain.tld/roundcubemail-0.4-beta/plugins/calendar/calendar.php on line 84
Fatal error: calendar::require() [function.require]: Failed opening required 'program/backend/caldav.php' (include_path='/var/www/domain.tld/newmail/:/var/www/domain.tld/newmail/program:/var/www/domain.tld/newmail/program/lib:/var/www/domain.tld/newmail/program/include:.:/usr/share/php:/usr/share/awl/inc') in /var/www/domain.tld/roundcubemail-0.4-beta/plugins/calendar/calendar.php on line 84
If I copy them from the latest "lazlo" version, I get the following error:
Fatal error: Declaration of CalDAV::newEvent() must be compatible with that of Backend::newEvent() in /var/www/domain.tld/roundcubemail-0.4-beta/plugins/calendar/program/backend/caldav.php on line 16
Simple question 1: Is caldav supported as a backend at the moment or not?
Simple question 2: What is missing (compared to Lazlo's version that also does not work)?
Thank you very much, Achim
-
CalDAV is not supported.
-
I have just released a new version bundled with other updated myroundcube plugins (base SVN 3803).
-
Is there any plan to make a google calendar backend soon ?
-
Forgot to mention that you have to adjust database events table.
@bagu: It is on my ToDo's ... but not within the next weeks. Maybe in autumn.
-
First of all, Rosali, thanks for putting so much effort in this nice plugin !
Dear all,
I successfully installed the calendar plugin from trunk-r-3803.zip (MyRoundCube Plugins Collection (RC SVN r3803) UPDATE 2010-07-04 01:02 p.m.) and I installed php5-cURL.
Unfortunately when i go to "settings", "Calendar Feeds" and click of the checkbox of "Confidential feed access [full access (read/write)]" or the checkbox of "Confidential feed access [read only]", Roundcube gets in some sort of loop in the sense that the screen both aforementioned items blanks, and Firefox gives a "loading page"-indictation.
The error I see in my roundcube log is:
PHP Fatal error: Call to undefined function curl_init() in ..../plugins/calendar/calendar.php on line 1157
The hidden test routine .../?_task=dummy&_action=plugin.calendar_tests returns:
jQuery Fullcalendar plugin tests
Database backend Test:
If you get an Error 500, then there is something wrong with the database backend.
On Error check Roundcube errors log.
Database access is ok.
PHP cURL Test:
If you don't see any results here, check Roundcube errors log and webserver logs.
Test Google
-> http://www.google.com/calendar/feeds/german__de@holiday.calendar.google.com/public/basic
-> return is truncated ...
Fatal error: Call to undefined function curl_init() in /htdocs/web_mail/plugins/calendar/calendar.php on line 1872
Does anyone know what i am doing wrong?
This happens regardless if I use a https or a http connection.
With kind regards,
Asim
-
It look like you didn't enable curl
look here PHP: cURL - Manual (http://us2.php.net/manual/pl/book.curl.php)
-
Hi Dziobak,
Thanks for you reply. It works now, I forgot to reload apache :( , guess it was much to late yesterday evening.
With kind regards,
Asim
-
There is an error when i try to run mysql :
#1005 - Can't create table 'roundcubemail.events' (Errcode: 150)
phpmyadmin say that the problem is on line 24
I am having this same issue did you ever get this resolved?
-
Yes, i use an innodb database now.
-
Yes i had to create it with MyISAM and then convert it to innodb and now it works...sortof. Everything loads fine with no errors but i cannot click on calendar to add events. I have tried with firefox and ie.
Any suggestions with this one?
Thanks for quick response too btw!
-
set in config file:
$rcmail_config['backend'] = "database";
-
set in config file:
$rcmail_config['backend'] = "database";
In my roundcube/plugins/calander/config/config.inc.php it says:
<?php
// backend type (dummy, database), see README
// Note: "dummy" is only for demonstrating basic functionality.
$rcmail_config['backend'] = "database";
What else could this be? I have another file config.inc.php.distro as well.
I have not changed either files as the config.inc.php already had database in it.
-
have you installed jqueryui plugin?? It is required for calendar.
-
I dont think so, All i have done was insert db and put calendar under plugins folder.
Im sorry but i did not see correct install procedures anywhere in the readme. If there is an installation help file i must have missed it.
-
Wow awesome script but for anyone new here that did not get the memo ;P
jqueryui itself is a plugin along with the rest of them and needs to be inside the plugin directory. Then you must edit roundcube/config/main.inc.php and enable your modules like this
// List of active plugins (in plugins/ directory)
$rcmail_config['plugins'] = array('password','jqueryui','calendar_switch','vcard_attach','vcard_attachments','webmail_notifier','settings',...etc
I know this is probably assumed information to you guys but I had no clue so I hope this helps someone.
I might work on a categorized notes plugin
Thanks alot people!
-
Hi, first of all thanks for this nice plugin!
What kind of external calendar formats are supported?
I have an *.ics file on a webserver, that I can access from different computers.
I use the calendar in Lightning via http://ftp://user: pass@domain.com/calendar.ics.
I tried to enter this adress in the calendar plugin, as a remote calender instead of the google example, but it did not work.
Will iCal be supported in future as an external calendar format?
Carsten
-
Hi, first of all thanks for this nice plugin!
What kind of external calendar formats are supported?
Currently only google's way (json encoded javascript array) is supported.
I have an *.ics file on a webserver, that I can access from different computers.
I use the calendar in Lightning via http://ftp://user: pass@domain.com/calendar.ics.
*.ics is supported for sync with lightning but only by http.
I tried to enter this adress in the calendar plugin, as a remote calender instead of the google example, but it did not work.
As said only json encoded arrays are supported.
Will iCal be supported in future as an external calendar format?
Carsten
May be, but not within the next months.
-
Hi, I updated the calender to trunk-r-3878. In this version I am not able to create new entries. On singleclick no event creation dialog comes up.
There are no errors in apache or roundcube log.
Do I need a new jquery version or something else?
Thanks for Help.
-
I dont think so, All i have done was insert db and put calendar under plugins folder.
Im sorry but i did not see correct install procedures anywhere in the readme. If there is an installation help file i must have missed it.
have you installed jqueryui plugin?? It is required for calendar.
-
Hi,
I'm trying to install this calendar plugin, but I have some problems.
Is it supposed to say "...?_task=dummy..." in the address fiels, when I have chosen "database" instead of dummy in the config file.
-
Yes. What are your problems?
-
Yes. What are your problems?
Well, I can't change some of the options in the preferences page. E.g. "timeslots per hour", "Default view", etc. I can only change them through the config file.
Also, is there a way to upload a "full" ical-file with many events in it? For example from webcalendar.
-
Well, I can't change some of the options in the preferences page. E.g. "timeslots per hour", "Default view", etc. I can only change them through the config file.
What version of RC and calendar plugin?
Also, is there a way to upload a "full" ical-file with many events in it? For example from webcalendar.
Yes. If You have problems, attach here the ICS file. When Rosali have time, he will remove eventual bug.
-
What version of RC and calendar plugin?
I'm using RC 0.3.1 and the latest calender plugin
Yes. If You have problems, attach here the ICS file. When Rosali have time, he will remove eventual bug.
I found out how to do it now :)
-
The latest calendar plugin is dedicated to RC 0.4 stable. If you don't want to have problems upgrade it.
-
Hi,
I try to run jQuery Calendar, but when try to have mail notification run I got this error in my logs:
PHP Fatal error: Class 'PEAR' not found in /var/www/html/roundcubemail-0.4/program/include/iniset.php on line 213
Any thoughts?
Regards,
Mike
-
There is a bug in current release 3878.2:
Issue 97 - myroundcube - calendar plugin - Project Hosting on Google Code (http://code.google.com/p/myroundcube/issues/detail?id=97)
-
Hi Rosali, I have just installed this great calendar plugin on 0.4 stable, for which many thanks. I have been looking for a cleaner, simpler replacement for webcalendar and this seems to fit the bill well.
I have encountered an issue with making a feed of my own calendar to give to my wife so she can read it. I did the bit in the calendar feeds settings then copied the url into the calendar config.php in place of the german one (that can be deleted by users) so all the family can pick up on it. All seems well apart from it not showing in the other calendars. If I open the url in a browser all I get is a pair of square brackets.
I can make this work using google calendar urls so presumably curl must be working OK. Nothing in the logs. Any ideas what the problem could be?
-
Hi Rosali, I have just installed this great calendar plugin on 0.4 stable, for which many thanks. I have been looking for a cleaner, simpler replacement for webcalendar and this seems to fit the bill well.
I have encountered an issue with making a feed of my own calendar to give to my wife so she can read it. I did the bit in the calendar feeds settings then copied the url into the calendar config.php in place of the german one (that can be deleted by users) so all the family can pick up on it. All seems well apart from it not showing in the other calendars. If I open the url in a browser all I get is a pair of square brackets.
I can make this work using google calendar urls so presumably curl must be working OK. Nothing in the logs. Any ideas what the problem could be?
I've been having the same issue. Didn't read of any other complaints like it, so thought it was just me not configuring something right. I've opened an issue (#98) on it at myroundcube - Project Hosting on Google Code (http://code.google.com/p/myroundcube/) . I had the same issue with the ICS URL feed as well, but the solution provided in Issue #97 fixed it.
-
see Issue 98 - myroundcube - Calendar "Feed URL" returns only brackets "[]" - Project Hosting on Google Code (http://code.google.com/p/myroundcube/issues/detail?id=98)
-
Editing events doesn't seem to work in Google Chrome. Clicking an existing event does nothing. Tried upgrading jquery-ui-1.8.2.custom.min.js to jquery-ui-1.8.4.custom.min.js, but that didn't help.
-
Issue 99 - myroundcube - Edit calendar events not working in Google Chrome/Safari - Project Hosting on Google Code (http://code.google.com/p/myroundcube/issues/detail?id=99)
-
I searched the thread but didn't see it, is there a plan to add the ability to drag create events like Google Calendar does? This Jquery calendar (http://github.com/robmonie/jquery-week-calendar) supports it so it should be possible to implement - demo (http://jquery-week-calendar.googlecode.com/svn/trunk/jquery.weekcalendar/full_demo/weekcalendar_full_demo.html)
-
I searched the thread but didn't see it, is there a plan to add the ability to drag create events like Google Calendar does? This Jquery calendar (http://github.com/robmonie/jquery-week-calendar) supports it so it should be possible to implement - demo (http://jquery-week-calendar.googlecode.com/svn/trunk/jquery.weekcalendar/full_demo/weekcalendar_full_demo.html)
I don't know if we think about the same but there is an option to drag/move events to other hour/day.
-
I don't know if we think about the same but there is an option to drag/move events to other hour/day.
Yes you can drag them AFTER you've created them. In Google calendar and the Jquery calendar I linked to above, you can drag the event while you are creating it to the appropriate time duration. Please see the demo.
-
Hi,
I'm a bit of a noob with all this php, mysql business but I can get by most of the time.
However, when running the calendar tests I'm getting this error:
Fatal error: Call to undefined function curl_init() in /home/web/roundcube/plugins/calendar/calendar.php on line 1901
The line it's talking about is this:
$ch = curl_init($val);
I've made sure curl is installed but after that I'm stumped.
So question 1. is this a problem and 2. if yes, how do I fix it please?
Thanks.
-
is curl enabled in php.ini?
-
Hi dziobak,
Thanks for the reply. The answer is "probably not", certainly I've not done it myself and I doubt it was done by default so that's probably the answer. I'll have to wait till tomorrow to find out though. Will post my results here.
Cheers.
-
Well I fixed it. I had to install the package php5-curl rather than straight curl.
Thanks.
-
@ @dmin:
Do you mean this new feature: FullCalendar Documentation - Dropping External Elements (http://arshaw.com/js/fullcalendar/examples/external-dragging.html)
Please describe your plans of usage.
-
Calendar plugin has been refactored. The layout is completely new.
Please notice that jquery plugin is required: Downloads - roundcube-plugins - Project Hosting on Google Code (http://code.google.com/p/roundcube-plugins/downloads/list)
Beta release is attached.
Edit: Attachment removed
-
wow rosali looks nice ... many thanks for your this great work :)
-
Looks great. Thanks.
-
Haven't even expect it will run flawlessly from the beginning, but launching RC under https not http wasn't easy for me.
I've added events table to rc database, and initialized both plugins.
After I login to my account, and going to calendar tab, loading animation on the top won't disappear, and events aren't being added to calendar.
Checked the table using phpmyadmin, and there are no datas :/
I've set in config.inc
$rcmail_config['backend'] = "database";
/* database table name */
$rcmail_config['db_table_events'] = 'events';
What should I do to make it working ?
I don't know if "dummy" variable in URI has something to do with my problem, but it's hardcoded in calendar.php file :/
https://rcube.mydomain.tld/?_task=dummy&_action=plugin.calendar
-
Anything in the error log?
What do you get here?
https://rcube.mydomain.tld/?_task=dummy&_action=plugin.calendar_tests
-
rosali -
great work as usual. i like the new layout.
scheduling events seems a little buggy to me. example: creating an all day event 0:00-23:59 starts the event the day before. trying to go back in and change the time makes the event another day longer. shortening the event graphically does appear to be working.
dragging events doesn't seem to behave properly. event does not stay in time slot where it was dropped.
maybe these are just issues for me. using latest svn with complete new install of latest calendar and jqueryui plugins. no errors in log.
keep up the good work!
--mike
-
Anything in the error log?
What do you get here?
https://rcube.mydomain.tld/?_task=dummy&_action=plugin.calendar_tests
I've looked into logs, but they didn't contain anything about problems with calendar. Test page was working fine, and there were no errors.
I know connection with dbase was working when I wrote yesterday's post, because I forgot to add events table and logged into RC, and saw that there's a problem with something (afair connection with events).
After adding events table, ajax error disappeared.
Ontopic:
jQuery Fullcalendar plugin tests
Database backend Test:
If you get an Error 500, then there is something wrong with the database backend.
On Error check Roundcube errors log.
Database access is ok.
PHP cURL Test:
If you don't see any results here, check Roundcube errors log and webserver logs.
Test Google
-> Deutsche Feiertage (http://www.google.com/calendar/feeds/german__de@holiday.calendar.google.com/public/basic)
-> return is truncated ...
s:gCal='http://schemas.google.com/gCal/2005'>Google (http://www.google).
com/calendar/feeds/german__de%40holiday.calendar.google.com/public/basic<
/id>2010-10-25T09:23:29.000Zcheme='http://schemas.google.com/g/2005#kind' term='http://
Test Roundcube
-> https://rcube.mydomain.tld:443/
-> return is truncated ...
RC log is empty. If I wait long enough (like 5 mins), and switch between daily/weekly/monthly view it sometimes shows daily events (somehow they were added but weren't shown after adding) or weekly ones. It doesn't show events in monthly view, nor current (today's) events in RC inbox window.
I suppose this is a problem with RC working on https protocol.
I'll try to make a copy of RC and test calendar w/o ssl connection when I find some time.
But even if it is a matter of ssl, I won't drop secured connection.
-
Looks good for me. Only bug I noticed is when creating events I click-hold and drag the duration I want expecting it to pop-up when I let go but it does not. I have to actually click, but it doesn't remember the duration I dragged. This is in Google Chrome.
-
Ok, I've moved my RC 4.2 instance and launched everything under http protocol, w/o subdomains (http://domain/rcube)
jq calendar doesn't work at all (at least it connects to db) - doesn't add events, nor show them.
As it goes about ajax "loading" div, it lasts for about 5 mins, then shows "request timed out" error and disappears.
I don't know if it has anything to do with google's calendar feeds, but I assume it doesn't.
I was curious if RoundCube Calendar 0.2 BETA 2 is working.
Checked it right away, and it works almost perfect (even under ssl). Adds events, and shows them immediately. The problem is with monthly view, as in this view events arent being shown. I'd be fine with this version, but the most important thing for me is an email remainder based on cron in jquery version.
ps. I was using mysql "event" tables created from attached to every calendar plugin sql scripts.
-
I'm quite sure there is something wrong with your database table. Did you create it from scratch when installing my calendar plugin version? As a proof of concept you can test my version @ Mail4us.net Webmail :: Welcome to Mail4us.net Webmail (http://mail4us.net).
-
I'm quite sure there is something wrong with your database table. Did you create it from scratch when installing my calendar plugin version?
I wish mine jqcalendar instance was working so fine as yours :/
As it goes about database, I upgraded RC 4.1 to 4.2 using patch provided on this forum (I don't think dbase structure was changed for v4.2)
Then created table 'events' from within phpmyadmin using mysql.sql file's content.
After you mentioned it may be a problem with database, could mail server and my hosting provider's standalone RC instance have something to do with it ? Afaik there's a dovecot mail server, and webhosting provides its own RC instance. I wanted to use latest v4 version along with couple additional plugins. I don't use caching in database I've created for my own RC instance. But it would be weird when everything works smooth on my own, and test accounts, but calendar refuses to work as supposed.
I could provide you a test email account to see for yourself how does it look.
-
I would need a test account, access to phpmyadmin and ftp access to Roundcube root folder. PM'me details.
-
Hello
I've prepared access for you
rcube panel: https://poczta.jodla.ayz.pl
username: test@jodla.ayz.pl
pass: t3$t
ftp.jodla.ayz.pl
user/pass: test/t3$t
phpma: https://s47.vdl.pl/phpmyadmin/
user/pass: joszu_roundcube / TT6IvX6e
Just looked inside the base, and I see that events are being added immediately. Thus still no idea why they don't want to show up in calendar :/
As I've already said, I didn't do anything extraordinary during installation.
Despite scalar error (still waiting for fix) 1 error showed up in log:
[25-Oct-2010 22:36:34 +0200]: PHP Error: Deprecated hook name. user_preferences -> preferences_list in /home/joszu/domains/jodla.ayz.pl/private_html/rcube/program/include/rcube_plugin_api.php on line 200 (GET /?_task=dummy&_action=plugin.calendar)
Maybe this can shred some light onto problem ?
If you need any additional information, just ask.
best regards
J
-
First I thank the developer of this plugin. We started using the RoundCube little while before we used the squerrmail and discouragement with the interface was very large. Only with the RoundCube were already very satisfied, but after the "discovery" of plugins will implement the interface left us really excited.
But we have a problem. I installed the plugin Calendar
@ Version 2.0 - 18.10.2010 and everything worked perfectly in browsers like Mozilla Firefox, Chrome.
But in Internet Explorer 8 grid of date (day / month) is not displayed: (
had already tested two other versions and worked in both browsers. Must be some detail, because the example of Mail4us.net is normally displayed in Internet Explorer.
Take this opportunity to apologize for the English, I'm from Brazil and I'm using the google translator:)
-==-
-
Attached is a new beta release.
For those who have problems:
If I should help you, then you have to trust me:
I need:
#1 IMAP test account
#2 Access to phpmyadmin
#3 FTP Access to Roundcube Root folder.
PM or mail me (myroundcube at mail4us dot net) details.
Notice: Remove old ./plugins/calendar folder and clear browser cache before installing the plugin.
Edit: Attachment removed
-
Hello Rosali
Thanks in advance for your attention. I installed the new version (I deleted the old directory and also deleted the events table and ran the script again mysql.sql), Mozilla and Chrome Ok, it works perfectly, not just Internet Explorer 8 shows the days / times of the grid
How it works well in other browsers do not believe that is a configuration error, but if necessary I create an account and install this FTP server. Nor do I believe that is a limitation of your plugin, as I mentioned in mail4us it works in IE.
Here are the screens
Thank you.
Chrome
http://img35.imageshack.us/img35/4079/chromen.jpg
Iexplorer 8
http://img840.imageshack.us/img840/342/iexplorer.jpg
error iexplorer
http://img837.imageshack.us/img837/7207/errodn.jpg
-
I think I see the problem. Do you really use IE8? I don't think so.
Nethertheless, check attached beta.
Edit: Attachment removed. Download from myroundcube - Project Hosting on Google Code (http://myroundcube.googlecode.com).
-
I think I see the problem. Do you really use IE8? I don't think so.
Yes we use the Internet Explorer 8, I did windows update to see if there was any fix again. I also tested on some machines. Bizarro :( (Only one question; I need recreate the database or can I use the same as the last version you posted?
I greatly appreciate, I will test the new version.
(http://img526.imageshack.us/img526/1039/iexplorer8b.jpg)
-
Yessssssssssssssssss !
Alright!! It worked perfectly! Perfect, customized to get the holidays in Brazil, it was perfect. As we say here was "show of ball." (show de bola!)
Congratulations! Thank you so much!
-
Well, my IE8 does not complain about:
$('#calendar').fullCalendar({
header: {
left: '',
center: '',
right: '',
},
... but yours does ...
$('#calendar').fullCalendar({
header: {
left: '',
center: '',
right: ''
},
Do you see the comma after right: '' ? ? ?
That's IE7 -- behavior, so I asked if you really use IE8 ... M$
-
Maybe its a problem with IE8 compatibility mode.
-
I think that Internet Explorer does not have the compatibility mode by default anyway I will check how the in pc at work. What I saw (at home) is that IE8's "signals" when the page is compatibiliade mode. Here when I switch between IE8 compatibility mode between normal mode and the only difference that I see that it is in compatibility REDUCES the calendar within the page and adds a scroll bar.
Brazilian Greetings
oMoiza
-
I confirm that calendar doesn't show up in IE8.
I attach a screenie with IE version. It doesn't work in normal mode, nor compatibility view mode.
Maybe older (is there a newer?) version of jquery library wouldn't make problems with rendering calendar panel ?
I've got an additional request to you Rosali.
I assume that reminder based on cron jobs sends e-mail when every event occurs (as well as a reminder to event). Would it be possible to add a checkbox in new event window, to set an option if I want to get an email about this event or not.
Having a dropdown list of emails, to choose which one should get a reminder (if checked "I want to be informed about this event") would be great.
I don't know if reminder feature is your own idea or fullcalendar plugin creator, but I haven't seen in FC documentation any notice about event remeinders, cron jobs, nor emails, thus I'm asking firstly you.
ps. I've sent a request for additional events window. We will see if within next half year such feature is going to be added ;)
pps. I'd like to thank Rosali for solving my problems with jqcalendar :)
-
Rosali, I can confirm, that this problem is on compatibility mode in IE8.
P.S.
You can release new version this weekend, I didn't catch new bugs...
-
Bugs/issues regarding compatibility mode in IE8 should be fixed.
Recent version is available @ myroundcube - Project Hosting on Google Code (http://myroundcube.googlecode.com).
-
scheduling events seems a little buggy to me. example: creating an all day event 0:00-23:59 starts the event the day before. trying to go back in and change the time makes the event another day longer. shortening the event graphically does appear to be working.
dragging events doesn't seem to behave properly. event does not stay in time slot where it was dropped.
maybe these are just issues for me. using latest svn with complete new install of latest calendar and jqueryui plugins. no errors in log.
rosali -
any thoughts on the bugs quoted above? i have updated to your most recent version as of today and these problems still persist (incorrect graphical display of events and incorrect drag and drop behavior).
-
I don't have such problem.
-
For those who have problems:
If I should help you, then you have to trust me:
I need:
#1 IMAP test account
#2 Access to phpmyadmin
#3 FTP Access to Roundcube Root folder.
PM or mail me (myroundcube at mail4us dot net) details.
I can't reproduce the issue. Please give me access to your box.
-
There is a new beta release:
Downloads - myroundcube - Project Hosting on Google Code (http://code.google.com/p/myroundcube/downloads/list)
(*) Refactoring JS (replace DOM by Jquery)
(*) Minimize Ajax requests
(*) Improvements on allday events
-
i have made a dutch translation (see attachment) but at the small datepicker the days are still in english. (see attached image)
-
Thanks for the translation.
Copy ./plugins/jqueryui/config.inc.php.dist to config.inc.php. Jquery datepicker should be translated then too.
-
Thanks for the translation.
Copy ./plugins/jqueryui/config.inc.php.dist to config.inc.php. Jquery datepicker should be translated then too.
Thats it!
THANKS!!!
-
Many thanks for this tip rosali :)
a little notice
i have add in reminders.php a samll check for
cron so cron is only allowed from localhost for
more security.
// only from localhost
if ($_SERVER['REMOTE_ADDR'] !== '127.0.0.1') {
die(header("Location: /"));
}
-
When in "Expires" of event i make last date 10th (example) in calendar view last day shown 11th. Why it is?
-
@lacri:
To secure it is a good idea. But I'm not sure if I should do it by detecting IP.
Some people use external services to request crons.
@Dronch:
Please wait for final release. I know there are timezone issues.
-
I've got some annoyances with the latest calender plugins (including the newest beta and all november 2010 plugins) while using Firefox 3.1.6 (IE8 seems not to have this problem). If I'm adding a new event and go to the schedule tab, the hours and minutes are aligned against the left side of the screen. Thus making it very hard to change the hours and minutes for the event. The added pictures make probably more clear what I mean. Is there anything I can do to change this behaviour?
-
No, you can't change this behavior. I will replace current timepicker by Adding a Timepicker to jQuery UI Datepicker (http://trentrichardson.com/examples/timepicker/)
-
New calendar plugin has been released.
Notice: There are database changes in calendar plugin and you have to re-configure the plugin. For database changes there is a built-in maintainance routine which can be called when logged in as calendar administrator (see 'key' image in calendar toolbar). Make sure to have a backup of you database table. Alternatively create database table from scratch if it is no problem for you to loose old events.
-
Thanks. It's working like a charm now :)
-
Rosali, do you remember when I asked you if it would be possible to add a window with incoming events, not only having today's events window ?
Fullcalendar's dev added this functionality yesterday
Issue 692 - fullcalendar - view with arbitrary number of horizontal days (and looks like week view) - Project Hosting on Google Code (http://code.google.com/p/fullcalendar/issues/detail?id=692)
Any chances you will handle this feature in your plugin ?
-
I see they merged another ticket with yours. It is not implemented. In addition it will be worse to have a horizontal view. Please add comment and ask for an option to display it vertically.
-
I see they merged another ticket with yours. It is not implemented. In addition it will be worse to have a horizontal view. Please add comment and ask for an option to display it vertically.
The guy from another ticket request a horizontal view, although Adam answered month ago:
having a view where the next N days are shown is currently now possible through a simple config option.
I just completely forgot to mention that, although I didn't follow calendar's development line.
-
Issue 775 - fullcalendar - New Basic View basicNDays - Project Hosting on Google Code (http://code.google.com/p/fullcalendar/issues/detail?id=775&colspec=ID)
-
Issue 775 - fullcalendar - New Basic View basicNDays - Project Hosting on Google Code (http://code.google.com/p/fullcalendar/issues/detail?id=775&colspec=ID)
i am modifying this feature request to include arbitrary # of columns AND rows (rows = weeks) of days.
pretty much, a completely configurable "basic" view.
Issue 692 - fullcalendar - arbitrary # of rows/cols in a basic-view - Project Hosting on Google Code (http://code.google.com/p/fullcalendar/issues/detail?id=692)
btw. Rosali, is there any chance to have something like: export google calendar to a file, upload the file to f.e. fcplugin directory, and let it display events taken from the file, instead of connecting all the time to g.calendar ?
-
Yes, just put an ics file anywhere accessible by the web and add the URL to Calendar Feeds.
F.e.:
http://mail.mydomain.tld/plugins/calendar/google.ics
-
Hi,
I have tried to figure this out by myself, but I couldn't do it...
Does this calendar plugin have support for Goggle Calendar. And how is the support? Read only? Or full supported?
-
Look into Calendar Feeds (Settings). It is read only.
-
Thank you. Are there any plans to implement read and write support to Google Calendar?
Or do you know about another plugin that has this feature?
-
Why? If you click on a google event, it should open google calendar and you can edit it there.
-
Oh, I didn't know that. That changes things a bit, even though it would be more smooth to edit and create events in roundcube... :-)
Thanks for clearing that up!
-
Hi,
I`m trying this great plugin. There is one strange thing.
A new user can not add events. The new event window doesn`t show.
If I join e.g. google calendar I can add new event. Then I unlink the google calendar and I can still add events. When I delete the last event and google calendar is not joined I can not add events again. The new event window is not showing.
roundcube 0.5-RC, myroundcube 4367 .
in config file:
$rcmail_config['calendarfeeds'] = array();
$rcmail_config['public_calendarfeeds'] = array();
Have I missed something?
thanks in advance
Filip
-
This is a bug. The GUI isn't initialized when there are no events to render. It is already fixed but not released yet. Next release is scheduled for this weekend.
-
Bugfix release is online.
-
Has someone been able to create recurring events with the current calendar plugin released today? Having said that I have the same problem with the version before this one.
Steps to reproduce:
- Go to calendar
- Pick a date and a time (or all-day)
- Fill in the General tab (fill in whatever you like)
- Go to tab Schedule
- Change "Recur event every", try week, month, year (whatever you prefer)
- Try to change "Expires" date. I can't change it. Whatever I choose, it won't let me save it.
I even have deleted my 'events' table and recreated it again with the sql file in the calendar sql folder. It doesn't help. I've no problems with single events so far. Only recurring events are causing problems.
-
URGENT !!!
Bug alert for calendar plugin:
Details and fix: Issue 136 - myroundcube - Calendar plugin (package r4408 and earlier): URGENT bugfix - Project Hosting on Google Code (http://code.google.com/p/myroundcube/issues/detail?id=136)
-
@ Jack!
Did you change the default dummy driver in calendar's config to use database backend?
-
@ Jack!
Did you change the default dummy driver in calendar's config to use database backend?
$rcmail_config['backend'] = "database";
Yes I did. Otherwise I couldn't fill in (i.e. save into the database) non-recurring events without any problem. I narrowed the issue somewhat down a bit. I can save recurring events if I not only change year/month/week/day but also change or reconfirm the datenumber. That's at least something. However once a recurring event is saved I can't change it anymore. The only way to change a recurring event is to delete it and recreate it. A non-recurring (i.e. happening once) event doesn't have this problem. I can change every field in it after it is created.
-
Hi,
I recently upgraded the Calendar and jQuery plugins (and also RC to 0.5). I ran the DB upgrade tool, and my old calendar events are showing up. I can't create any new events, though. When I try to save a new event, I get "Internal Server Error". When I check the logs, I get:
MDB2 Error: no such field (-19): _doQuery: [Error message: Could not execute statement]
[Last executed query: PREPARE mdb2_statement_mysql_34404fbdeea90c065569e9e7f208acdb84dcd0415 FROM 'INSERT INTO `events`\r\n (`user_id`, `start`, `end`, `summary`, `description`, `location`, `categories`, `all_day`, `recurring`, `rr`, `expires`, `occurrences`, `byday`, `bymonth`, `bymonthday`, `recurrence_id`, `uid`, `client`, `timestamp`)\r\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)']
[Native code: 1054]
[Native message: Unknown column 'client' in 'field list']
I'm afraid I don't know much about MySQL, so I would appreciate any help. Thanks!
-
Hi,
I recently upgraded the Calendar and jQuery plugins (and also RC to 0.5). I ran the DB upgrade tool, and my old calendar events are showing up. I can't create any new events, though. When I try to save a new event, I get "Internal Server Error". When I check the logs, I get:
I'm afraid I don't know much about MySQL, so I would appreciate any help. Thanks!
I faced the some problem. Apparently the field 'client' is missing if you upgrade from an older plugin version and it's not corrected by the calendar plugin database check. If you create the 'events' table from scratch (see file in plugins SQL folder) you don't have this problem. The solution in your case is to add manually the 'client' field to the 'events' table from the roundcubemail database. For example:
ALTER TABLE `events` ADD `client` text;
-
ALTER TABLE `events` ADD `client` text;
Excellent! Now it works again. Thanks!
-
@ Jack: Does it work for you now?
-
@ Jack: Does it work for you now?
The issue described by danpep has nothing to do with my cannot-change-or-easily-add-recurring-events problem. Also I don't have any errors in the log file. So unfortunately the answer is no :( How easy is it to add recurring events in your own setup? Can you change recurring events in your own setup?
-
It works for me perfectly. Check yourself at my demo site (use demo account - see link on top of the page - or register your own).
Is there a chance to get remote access to your host (IMAP test account, FTP to Roundcube folder and maybe PHPMyAdmin).
http://mail4us.net
-
It works for me perfectly. Check yourself at my demo site (use demo account - see link on top of the page - or register your own).
Mail4us.net Webmail :: Welcome to Mail4us.net Webmail (http://mail4us.net)
I checked your demo site. Guess what: same problem exists! Steps to reproduce:
- Click somewhere in the calendar screen to add an event (choose any date you like)
- General tab: Summary field: add some text
- Schedule tab: Recur event every: Year
- Schedule tab: Expires: year: 2020 (whatever you like), day: 15 (whatever you like)
- Click on Save
Now the recurring event is added to the database. Try to change the recurring event you just added. For example, try to change the expiry year. You can't save your changes to the database because nothing is happening if you click on the save button......
I've used FF and IE. Issue persists. IE shows the following errors:
Message: Object doesn't support this property or method
Line: 679
Char: 13
Code: 0
URI: http://mail4us.net/plugins/calendar/program/js/calendar.callbacks.js?s=1294389285
Message: Object doesn't support this property or method
Line: 633
Char: 9
Code: 0
URI: http://mail4us.net/plugins/calendar/program/js/calendar.callbacks.js?s=1294389285
-
hi. are there any limitations on the calendar formats that can be used as feeds ? i have one installation of roundcube 0.4.2 using the calendar plugin from trunk-r-3973 and this correctly shows four different feeds i have added. on a roundcube 0.5 installation using the calendar plugin from trunk-r-4408 only two of the same four feeds appear to work. one of the feeds just doesn't seem to show anything and the other (my private google calendar) not only doesn't show anything but also stops any of the other feeds showing anything. i'm not seeing any errors in the log. cheers.
-
@ Jack!:
Try attached calendar.callbacks.js
@ Carrot Cruncher:
No, there are no such (intended) limitations. May I ask you to PM'me your feed Urls for testing.
-
hi, I have the same problem like Carrot Cruncher. I can`t join calendar with recurring events.
example: ?eské svátky (http://www.google.com/calendar/feeds/jnv1189bt6iik6en4590n25fa4@group.calendar.google.com/public/basic)
There is no PHP errors in logs. I have been exploring the code for a while to find out the problem.
You don`t use gcal.js but only function getJSON() in calendar.php do you?
I think the lines 1566, 1567 and end of 1568 in calendar.php are useless.
The next lines do the same action.
Regards
Filip
-
@rosali : i've sent you a pm (tried a couple of times), although i'm not sure if they have been sent as nothing shows in my sent folder.
@mezcal : i agree. i've done some testing and the problem with my private calendar is when i add repeating events.i cleared down all my events and then added single events, these showed up fine, as soon as i add a repeating event none of my calendars will show in roundcube.
-
See my next message.
-
@ Jack!:
Try attached calendar.callbacks.js
At least I can save the recurring event now while using the new calendar.callbacks.js. However something strange happens if you recall a recurring event. I've tested this on my own Roundcube installation and on Mail4us.net Webmail :: Welcome to Mail4us.net Webmail (http://mail4us.net). Both sites show exactly the same results.
Steps to reproduce:
- Choose a date and click on all-day field (I've chosen 17 January 2011)
- General tab: Summary field: add some random text
- Schedule tab: Recur event every: Year
- Schedule tab: Expires: year: 2015 (that's what I've chosen), day: 17
- Click on Save
Now the recurring event is saved to the database. Click again on the recurring event you've just added. Magically the expiry date has changed to 18 January 2015 instead of the filled in 17 January 2015.
Use the same just added event and do the following:
- Schedule tab: Change the expiry date to 2020-01-17 (was 18 January 2015 and should be 17 January 2015)
- Click on Save
Now the recurring event is saved to the database. Click again on the recurring event you've just added. The expiry date is still all right. i.e. 2020-01-17. Magically the start time is set to 23:00 (instead of staying at 0:00) and the end time is set to 22:59 (instead of staying at 23:59). So this event is now spread over 3 days (!) instead of one. The sad news is, no matter what I do I can't correct the start and end time anymore for this event.
As far I can see this only happens if the recurring event is annual (birthdays for instance).
-
@ Jack! and Carrot Cruncher
Please check version attached to issue ticket:
Issues - myroundcube - Project Hosting on Google Code (http://code.google.com/p/myroundcube/issues/list?cursor=138&updated=138&ts=1295450945)
-
@ Jack! and Carrot Cruncher
Please check version attached to issue ticket:
Issues - myroundcube - Project Hosting on Google Code (http://code.google.com/p/myroundcube/issues/list?cursor=138&updated=138&ts=1295450945)
@Rosali: The expiry date doesn't magically change anymore with a recall of recurring annual events (see message #208 (http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/6782-jquery-fullcalendar-plugin-forked-rosali.html#post32500) of this thread). However there's still one issue left. If you change an annual recurring event that already has been saved to the database, for example change the category (or anything you want), the start and end time automatically change too if you click on save to the database. The start time is always set to 23:00 hrs and the end time is always set to 22:59 hrs while I only tried to change the category in my example. Thus the event is spread over 2 days. I also tested this on your own site (http://mail4us.net). Same error result.
-
Hi,
I'm trying to upgrade my plugins to the latest version but the jqueryui plugin is causing RC to display the error "Inter Server Error". It then fails to load any emails and the calendar page doesn't generate properly.
I'm running the recently installed bug fix release of the calendar plugin and have added the client column to the events table.
Nothing is leaping out at me in any log files as to what the problem is.
Can anyone assist?
Thanks.
-
@ Jack!
I guess I found the bug. It is in calendar.callbacks.js around line 733:
if(endtime > starttime && (starttime != event.start || endtime != event.end)){
rcmail.http_post('plugin.resizeEvent', '_event_id='+event.id+
'&_start='+starttime+
'&_end='+endtime+
'&_allDay='+event.allDay+
'&_userid='+event.userid+
'&_ct='+event.token+
'&_gmtoffset='+gmtoffset);
See '&_allDay='+event.allDay+ and add it. I missed to submit allDay property which is responsible not to adjust client timezone for all day events.
@ RandomUsername
INTERNAL SERVER ERRORS normally are logged in /logs/errors
-
@ RandomUsername
INTERNAL SERVER ERRORS normally are logged in /logs/errors
Thanks, but I actually fixed it by upgrading my roundcube installation to 0.5.
However, the problem I now have is that the calendar plugin isn't showing recurring events from my Google calendar feed. Any ideas about that? Thanks.
[EDIT]Might be related, RC just spat this at me:
calendar.invalidresponse: ./?_task=dummy&_action=plugin.calendar_getJSON&_url=http%3A//www.google.com/calendar/feeds/xxxxxxxxxxxxxx%2540googlemail.com/private-d5ff15e28c9961a43a5ac770bd61c71e/basic
-
Google has changed the json return for recurring events. Now they return a property returning an event entry in ical format. I'm working on it.
-
@ Jack!
I guess I found the bug. It is in calendar.callbacks.js around line 733:
See '&_allDay='+event.allDay+ and add it. I missed to submit allDay property which is responsible not to adjust client timezone for all day events.
Excellent. I can confirm this bug is gone now. Good work.
-
I have downloaded the latest trunk revision of the calendar. I installed the mysql and config'ed the calendar and jqueryui. I added them to the plugins in the order of: jqueryui, calendar. However, Roundcube then only display a blank white page. I have tried to log errors and nothing comes up. Any help would be greatly appreciated. I am excited about this calendar. Thanks!
-
I have downloaded the latest trunk revision of the calendar. I installed the mysql and config'ed the calendar and jqueryui. I added them to the plugins in the order of: jqueryui, calendar. However, Roundcube then only display a blank white page. I have tried to log errors and nothing comes up. Any help would be greatly appreciated. I am excited about this calendar. Thanks!
Hi,
I had the same problem today , I changed
$rcmail_config['cron_log'] = true;
to
$rcmail_config['cron_log'] = false;
in /plugin/calendar/config/config.inc.php
That seemed to work.
I have not tracked the underlaying problem yet though.
Maybe a bug report would be in order ?
Hope that helpes,
Minze
-
Thanks for the help. However, this option does not work for my server. It still just displays a blank page.
-
Enable logging in PHP and check webserver error log if there is nothing in the roundcube logs.
-
Hi, forum
1.- Where can I found the translation strig for "All-day" inside the .ICS attached to reminders?
I have searched inside all text files in all plugins, without success.
2.- As i haven't found info about where to sent translations, I have sent some new translations to "myroundcube at mail4us dot net"
Is this correct?
WIll them be added to plugins?
Thank you very much
-
Thanks for the translations! I'll add them to next release.
-
Thank you!
What about the string I cannot find?
It's "All-day" inside the .ICS attached to reminders
I cannot find it, but it's translated to other languages...
-
It is in calendar localization:
$labels['all-day'] = 'all-day';
-
OK
Then it seems the problem is that every first letter in the phrase is capitalized.
all-day is being transformed in "All-day", and that's ok
But spanish translation, "todo el día" is being transformated in "Todo El Día".
Using capitals inside a phrase is incorrect in spanish.
Could it be corrected so only first letter is capitalized?
Thank you!
-
New to roundcube and its working great, trying my first plugin and the learning pains are getting to these old bones, here is what i done, let me know what else i need to do, and any help is greatly appricated ! any and all helpful comments welcome.
install calendar and jqueryui plungins in the plugin directory
renamed the default conf files to config.inc.php for both
not sure i should change anything or what in the config.inc.phg files ?
added plugins to main config file, see below
// List of active plugins (in plugins/ directory)
$rcmail_config['plugins'] = array('password');
$rcmail_config['plugins'] = array('jqueryui', 'archive');
$rcmail_config['plugins'] = array('calendar', 'archive');
when in roudcube and click the calendar icon i'am getting
jqueryui plugin is not installed. Get it here
i have looked at everything (i think) but like i said these old bones is getting tired..
-
Your plugins array is declared incorrectly. For your plugins listed above, it should be as follows:
$rcmail_config['plugins'] = array('password', 'jqueryui', 'archive', 'calendar');
-
Your plugins array is declared incorrectly. For your plugins listed above, it should be as follows:
$rcmail_config['plugins'] = array('password', 'jqueryui', 'archive', 'calendar');
now i'am getting soemwhere, i know this may sound a little silly, but what password is this asking for, maybe if i could be pointed to where the info you gave me could be found i would not post here until i knew what i was posting about . :)
thanks
chuck
-
well at least i now can see the calendar, but the same one for whoever logs in , there are a number of events already in this month etc., cant delete , and when i add and save it doesn't show up.. i know this just needs tweaking but simple instructions have eluded me if they exist, help or more comments more than welcome.... :)
chuck
-
I enabled PHP logging and came up with this error:
PHP Fatal error: Call to undefined method rcube_template::include_css() in {roundcubedirectory}/program/include/rcube_plugin_api.php on line 406
Thanks for any help.
-
Which Roundcube version do you use? It looks like you are using an outdated version.
-
I actually use 0.5 stable on a CentOS 5 server with Plesk
-
Hi, I am using a PostgreSQL backend for Roundcube, and when I upgrade to the latest version of the calendar plugin, I get these errors in my apache error log (when opening the Calendar page):
[Wed Feb 09 16:32:08 2011] [error] [client X] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]\n[Last executed query: SELECT currval('events')]\n[Native message: ERROR: "events" is not a sequence]\n, referer:
[Wed Feb 09 16:32:08 2011] [error] [client X] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]\n[Last executed query: SELECT currval('events')]\n[Native message: ERROR: "events" is not a sequence]\n, referer:
[Wed Feb 09 16:32:08 2011] [error] [client X] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]\n[Last executed query: SELECT currval('events')]\n[Native message: ERROR: "events" is not a sequence]\n, referer:
[Wed Feb 09 16:32:08 2011] [error] [client X] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]\n[Last executed query: SELECT currval('events')]\n[Native message: ERROR: "events" is not a sequence]\n, referer:
If I add this to my roundcube db.inc.php:
$rcmail_config['db_sequence_events'] = 'events_event_id_seq';
The error changes to this:
[Wed Feb 09 16:56:27 2011] [error] [client x] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]\n[Last executed query: SELECT currval('events_event_id_seq')]\n[Native message: ERROR: currval of sequence "events_event_id_seq" is not yet defined in this session]\n, referer:
[Wed Feb 09 16:56:27 2011] [error] [client x] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]\n[Last executed query: SELECT currval('events_event_id_seq')]\n[Native message: ERROR: currval of sequence "events_event_id_seq" is not yet defined in this session]\n, referer:
[Wed Feb 09 16:56:27 2011] [error] [client x] MDB2 Error: unknown error (-1): _doQuery: [Error message: Could not execute statement]\n[Last executed query: SELECT currval('events_event_id_seq')]\n[Native message: ERROR: currval of sequence "events_event_id_seq" is not yet defined in this session]\n, referer:
I am going to use the old version I was using for now, but it appears that the new "stable" version of the calendar is currently broke with a postgres backend.
-
Did you create and configure the new 'events_cache' table?
-
Yes, I created it and added the extra "client" field to my events table. I even tried (on a backup) dropping the events and events_cache tables and re-adding them with the provided SQL script.
The error messages do not appear to be related to events_cache, they all appear to be related exclusively to the events table.
-
Unfortunately I don't have PostgreSQL. Is there a chance to get remote access to your server?
-
Unfortunately I don't have PostgreSQL. Is there a chance to get remote access to your server?
Unfortunately there no way I can give external access to our email server. I could certainly help set up PostgreSQL somewhere, and do testing of possible fixes.
-
I found the problem. Wait for next release.
-
Would it be possible to have a functionality like the one in:
http://arshaw.com/js/fullcalendar/demos/selectable.html
Selecting a range of days or hours and creating a new event?
Regards,
Panagiotis
-
It should not be too hard to implement it. I'll put it on my Todo's.
-
Hi, the new version fixes the problems I was having, it seems to be working much better. I was getting some errors in the logs like this when trying to add events:
[Fri Feb 18 10:38:32 2011] [error] [client XXX.XXX.XXX.XXX] PHP Fatal error: Call to a member function get() on a non-object in htdocs/roundcubemail-0.5.1/plugins/calendar/program/backend/database.php on line 74, referer: https://webmail/roundcube/?_task=dummy&_action=plugin.calendar
and like this when loading the ICS from Thunderbird
[Fri Feb 18 11:14:07 2011] [error] [client XXX.XXX.XXX.XXX] PHP Notice: Use of undefined constant RCMAIL_VERSION - assumed 'RCMAIL_VERSION' in htdocs/roundcubemail-0.5.1/config/main.inc.php on line 261
I managed to fix both the errors with trivial one-line changes, here is a patch:
diff -ubr calendar.orig/program/backend/database.php calendar/program/backend/database.php
--- calendar.orig/program/backend/database.php 2011-02-18 11:19:11.499822158 -0500
+++ calendar/program/backend/database.php 2011-02-18 11:19:34.958960153 -0500
@@ -71,7 +71,7 @@
$user = $account['username'];
}
if(!strstr($user,'@'))
- $user = $user . '@' . $rcmail->config->get('mail_domain');
+ $user = $user . '@' . $rcmail->config->mail_domain;
$this->username = $user;
}
$uid = $id . "@" . $user;
diff -ubr /root/calendar/program/tbclient.php calendar/program/tbclient.php
--- calendar.orig/program/tbclient.php 2011-02-18 11:19:11.519821424 -0500
+++ calendar/program/tbclient.php 2011-02-18 11:19:34.978959419 -0500
@@ -19,6 +19,8 @@
//dummy
}
+define('RCMAIL_VERSION', 'dummy');
+
include '../../../config/main.inc.php';
function rcube_https_check($port=null, $use_https=true) {
-
Thanks! But the patch is wrong.
It must be:
+ $user = $user . '@' . $this->rcmail->config->get('mail_domain');
-
Thanks for the correction, I have fixed the code on my server.
This may be a browser issue, but the calendar doesn't work in the latest chromium beta (10.0.648.114) , when you try to load the calendar the screen is greyed out and stays that way indefinitely.
-
Works for me with latest chromium beta (11.0.672.2).
-
but the calendar doesn't work in the latest chromium beta (10.0.648.114) , when you try to load the calendar the screen is greyed out and stays that way indefinitely.
same.... the calendar screen is greyed out, tested by Safari 5 for Mac, Firefox 3.6 for Mac, etc. (rc0.5.1+jqueryui plugin 1.8.6+Jquery Calendar plugin 2.8).
The browser's javascript error log was:
arr[0].getTime is not a function in [path to roundcube]/plugins/calendar/program/js/calendar.jsonfeeds.js
'arr' must be an array of date objects but was null indeed. Perhaps function 'DstDetect()' in timezone.js is not working properly. Any idea?
-
Hi tenya, yeah I have the same issue with it - I originally installed the Debian release for squeeze however it was out of date (v0.3) so installed v0.5 and still have the same issues with the calendar. jqueryui is the first plugin loaded followed by calendar. I'm using the bundle plugin pack. IE shows a different error to FF:
Message: Object doesn't support this property or method
Line: 11
Char: 4
Code: 0
URI: http://webmail.blah.com/plugins/calendar/program/js/calendar.jsonfeeds.js?s=1298886708
I've totally trashed and re-installed RC without success. It definitely seems like the dates aren't getting passed to the array?
-
Could you please help to debug it?
calendar.jsonfeeds.js:
options = options || {};
return function(start, end, callback) {
alert(typeof start)
var arr = DstDetect(start);
alert(typeof arr[0]);
What do the 'alerts' report?
-
rosali, many thanks for your help. The 1st alert (typeof start) returned 'object', but the script was terminated before reaching at the second alert (typeof arr[0]) because "var arr = DstDetect(start);" induced the following error:
dtDstStart is not defined in [path to calendar plugin]/program/js/timezone.js
I briefly checked function `DstDetect()' in timezone.js, and found condition 'if((dtDstDetect.getTimezoneOffset() * (-1)) == intOffset && dtDstStartHold != '')' in line 48 was not satisfied, which resulted in null dtDstStart and dtDstEnd.
Indeed if I move the following two lines:
50: dtDstStart = new Date(dtDstStartHold);
51: dtDstEnd = new Date(dtDstDetect);
out of the "if" block in line 48 (dtDstStart and dtDstEnd are certainly set to Date objects), it worked without any error.
So please re-check whether the condition in line 48 of timezone.js is correct or not.
Thanks in advance.
-
Could you please post in which timezone you are?
-
rosali, I'm in Japan (TZ=JST-9), and "new Date().getTimezoneOffset();" and function "TimezoneDetect(mydate)" in timezone.js returned -540 and 540, respectively.
Cheers, Tenya
-
I'm able to reproduce the issue. Could you please tell when daylight saving time starts/end in Tokio?
-
I see, there is no daylight saving time in Tokyo ... I missed this situation!
Attached is a quick fix for calendar.jsonfeeds.js.
-
I'm able to reproduce the issue. Could you please tell when daylight saving time starts/end in Tokio?
Thanks, but now we do not have DST in Japan. It would be great if you could add some options regarding DST settings (auto or neglect) in the preference.
Daylight saving time around the world - Wikipedia, the free encyclopedia (http://en.wikipedia.org/wiki/Daylight_saving_time_around_the_world)
Cheers, Tenya
-
Attached is a quick fix for calendar.jsonfeeds.js.
Many thanks for your quick action! I've just replaced the file, and it worked perfectly!
Will attach a Japanese localization (ja_JP.inc) for this plugin, which is just a token of my gratitude.
Best, Tenya
-
Hi Rosali,
I'd imagine I'd be having a similar issue with the calendar and daylight savings? My timezone is set to Australia/Brisbane and we have no DST as well
Edit: Rosali you're a genius! I applied the change you made for Tenya and it fixed the issue for me too :)
Cheers
-
Hi!
I'm new with roundcube and jquery calendar and I'd like to remove the username or alias in the top bar of the calendar.
In my calendar appears: [username] (Filter: all events) and I'd like to remove that text.
Can you help me? :)
-
Hi!
I'm new with roundcube and jquery calendar and I'd like to remove the username or alias in the top bar of the calendar.
In my calendar appears: [username] (Filter: all events) and I'd like to remove that text.
Can you help me? :)
-
Hello Rosali:
I like the way your calendar plugin looks: great job! I also just found a web client for CalDAV servers (DAViCal Web Client - DAViCal Wiki (http://wiki.davical.org/w/DAViCal_Web_Client)) that would be a perfect complement to your work.
Do you plan to support CalDAV on the backend to offer something like Google Calendars: a single backend (CalDAV) that can be viewed in iCal, Lightning, iPhone, and Roundcube (through your plugin)?
Thanks, Achim
-
good morning! :)
I have a new question... and forget the last I made... hahahaha
I'd like to know how to keep notes of the calendar in table events not in events_cache...
thank u so much!
-
Sorry, I don't understand your request. Please try to be more precise.
-
Sorry! I'm Spanish and my English isn't so good :(
My boss has told me to look jquery calendar's code to guess why some events of the calendar are kept in table events and others in table events_cache... because he wants to keep all the events of the calendar in table events...
I hope you've understand me now... :confused:
-
'events_cache' is for external layers, f.e. if you define a google calendar as additional feed.
It does not make sense to store events from external sources in the regular 'events' table.
-
OK :) Thank u for your answer!
But I'd like to know what do I have to change in the code to keep the events of my google calendar in table event, not in events_cache... could I? or is it impossible?
Thank u again!
-
That's not possible and it does not make sense to store external events permanently.
-
ok :) thank u!
I'll tell him... cause I was getting crazy hahahaha
-
rosali,
is it possible to store the events on a google calendar not locally?
I already use google for my calendar, so maintaing one calendar would be handy.
-
I've told to my boss and he has explained me that what they want (him and the company) is to make a general calendar (for example made in Google Calendars) with the official events of the company for all the users and so, he doesn't want to have in events_cache one occurrence x each employee
for example,
20th may is the anniversary of the company and they write this event in Google calendar, in events_cache would appear more than 200 (we are more than 200 employees) occurrences... and they want one common occurrence for all the employees...
-
This is a really nice plugin, works perfectly
A user made me a request :
is it possible to implement a field to search the calendar ?
-
I've put it to my ToDo's. I don't promise that this feature is coming soon.
-
I noticed if you try browsing directly to the calendar when you are logged out ( http://localhost/?_task=dummy&_action=plugin.calendar ) it gives you an htaccess login popup instead of taking you to the roundcube login screen. Is there a way you can update it to take you to the roundcube login and then redirect to calendar once logged in?
-
No,
Calendar RSS feeds and webmail_notifier plugin need this HTTP authentication request.
-
Hi ! Thanks for this plugin.
I have a little issue with the calendar loading forever with :.
* calendar = version 2.9 - 06.03.2011
* jqueryui = version 1.8.2
Firebug say to me than at line 578 :
$.datepicker is undefined
(?)($=function())
jquery.timepicker.js?s=1302164313()
$.datepicker._base_selectDate = $.datepicker._selectDate;
This is probably related to this specific jqueryui version.
Upgrade to jqueryui 1.8.6 version solve the problem.
Anyway, maybe a jqueryui plugin version check alert would be convenient. Or just a version requirement in the readme file.
-
No,
Calendar RSS feeds and webmail_notifier plugin need this HTTP authentication request.
But it can't redirect to the login page when not logged in? We have our user's who like to bookmark the calendar and being greeted with an htaccess popup is doesn't look very smooth compared to the roundcube login page.
-
calendar.php:
Look for:
function authenticate($args)
{
$rcmail = rcmail::get_instance();
if(!$rcmail->user->data['user_id'] && $rcmail->action == 'plugin.calendar'){
$this->http_auth();
exit;
}
return $args;
}
and modify it for your needs. I won't change it. F.e. Event Reminders contain links to the event. It is better to be prompted with http authentication popup and then access the event directly as to see the login screen and then the mailbox.
-
function authenticate($args)
{
$rcmail = rcmail::get_instance();
if(!$rcmail->user->data['user_id'] && $rcmail->action == 'plugin.calendar'){
if(count($_GET) == 2)
$rcmail->output->redirect();
else
$this->http_auth();
exit;
}
return $args;
}
This would do the trick. But the result is, that users see the mailboxlist after login when trying to access the calendar link in not authenticated state.
So what is better?
-
Thank you Rosali, that does work. For us, it's probably better to have it go to the login screen and get mail instead of the htaccess popup window. Why can't it redirect back to the calendar after logging in though? None of the other tasks have an issue.
For instance if you go to http://whatever/?_task=settings when you are not logged in, you get the login page and redirect back. Is it not possible ?_task=dummy&_action=plugin.calendar can do the same?
-
Ok, I didn't know that. Try yourself:
function authenticate($args)
{
$rcmail = rcmail::get_instance();
if(!$rcmail->user->data['user_id'] && $rcmail->action == 'plugin.calendar'){
if(count($_GET) == 2)
$rcmail->output->redirect($_GET);
else
$this->http_auth();
exit;
}
return $args;
}
-
Ok, I didn't know that. Try yourself:
function authenticate($args)
{
$rcmail = rcmail::get_instance();
if(!$rcmail->user->data['user_id'] && $rcmail->action == 'plugin.calendar'){
if(count($_GET) == 2)
$rcmail->output->redirect($_GET);
else
$this->http_auth();
exit;
}
return $args;
}
That causes a loop:
This webpage has a redirect loop
The webpage at http://whatever/?_action=plugin.calendar&_task=dummy has resulted in too many redirects.
-
I've told to my boss and he has explained me that what they want (him and the company) is to make a general calendar (for example made in Google Calendars) with the official events of the company for all the users and so, he doesn't want to have in events_cache one occurrence x each employee
for example,
20th may is the anniversary of the company and they write this event in Google calendar, in events_cache would appear more than 200 (we are more than 200 employees) occurrences... and they want one common occurrence for all the employees...
I public the question again because I still haven't fixed it...:(
-
There no simple fix. Currently the user is the top level object. There is no group functionality. I appreciate any patches. So go ahead and code the stuff.
-
Hi Rosali!
I hope this photo will help you to understand my problem:
http://img18.imageshack.us/img18/7986/calendariow.jpg (http://img18.imageshack.us/img18/7986/calendariow.jpg)
As you see, there are 2 users' ID, both have added the same calendar, a google calendar with all Spanish events, this one:
Días Festivos de España (http://www.google.com/calendar/feeds/es.spain%23holiday%40group.v.calendar.google.com/public/basic)
But when both are connected to roundcube, in table events_cache appear the events duplicated (and they are the same!), this is an example, but in our company we are nearly 300 employees and they don't want eventsx300...
Are there any way to fix it? :confused:
-
I understand your problem. But as said the user is the top level object. Therefore the entries have to be duplicated. I would not worry about that, because the cache is truncated on log out and additionally on login for the case if a user does not logout properly by just closing the window.
-
Thank u Rosali!
Excuse me but I didn't know the first answer was for my problem :)
I'll tell my boss! Thank u so much!
-
This is a really nice plugin, works perfectly
A user made me a request :
is it possible to implement a field to search the calendar ?
Hello!
Very good Plugin.
Are there any plans in this regard?
-
Currently I'm working on CalDAV backend. That's more imporant. Remember me in a month or so.
-
Hi,
the calendar works fine.
I managed to share calendars between users:
For example:
$rcmail_config['public_calendarfeeds'] = array(
'http://url_to_ics/calendar.ics' => 'Test1',
'http://url_to_roundcube/?_task=dummy&_action=plugin.calendar_showlayer&_userid=15&_ct=c623766e09ee2f78a8997f782bf784cb&readonly=1' => 'Test2',
)
or by adding a calendar-feed.
The problem is that a user only sees the first 20 characters of an entry. Is there a way to see the full description of an entry?:confused:
-
Where? Do you mean in the settings section?
-
I have attached a screenshot.
There are two ics files.
The user is not abel to see the whole entry (only the first 20 characters).
Own calendar entries are also displayed incomplete. But if the user clicks on the entry the full entry will be displayed.
-
I have opened a ticket.
Issue 187 - myroundcube - Calendar Summary is truncated - RoundCube Plugins - Google Project Hosting (http://code.google.com/p/myroundcube/issues/detail?id=187)
-
Fixed in current release.
-
fantastic work. Thanks a million :):)
-
Unfortunately, there are new problems...
Now the calendar only works in firefox. In other browsers, the calendar does not load.
IE8-Errormessage:
Details zum Fehler auf der Webseite
Benutzer-Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C)
Zeitstempel: Thu, 5 May 2011 16:09:03 UTC
Meldung: Bezeichner erwartet
Zeile: 132
Zeichen: 24
Code: 0
URI: http://path_to_roundcube/plugins/calendar/program/js/calendar.callbacks.js?s=1304598453
Meldung: 'calendar_callbacks' ist undefiniert
Zeile: 86
Zeichen: 9
Code: 0
URI: http://path_to_roundcube/plugins/calendar/program/js/calendar.js?s=1304598453
Also calendar feeds can not be added.
-
http://www.roundcubeforum.net/7-third-party-contributions/46-api-based-plugins/8010-myroundcube-plugins-bundle-2.html
Should be fixed now. I have updated to jQuery qTips v2 beta. Cross-browser compatibility issues should be fixed now.
-
Thank you very much!
-
Hi Rosali!
First of all, I hope my Spanish translation will be useful :) I'll look forward to translate more.
I want to ask you I you'd recommend me updating jquery calendar to jquery fullcalendar? because is it different, right?
Thank u so much!!
-
This is a really nice plugin, works perfectly
A user made me a request :
is it possible to implement a field to search the calendar ?
I would like to remind you!
Would be a great feature... O0
I don't know how to call an enhancement (Issues - myroundcube - RoundCube Plugins - Google Project Hosting (http://code.google.com/p/myroundcube/issues/list)) :confused:
-
Yes, I still have this on my ToDo's.
I have recently implemented CalDAV. There were and are still issues with shared calendars. It is not the time for new features yet.
I know, I've ask you to remember me about the search feature. But step by step.
Currently there are the following priorities:
(*) go to vacations
(*) finsish CalDAV backend
(*) overwrite categories when switching to a shared calendar
(*) introduce reminders on a per event level
(*) other stuff ...
-
no problem!
(*) go to vacations
O0
-
Hello,
I know that webdav did not work at a point in time. But it seems changed over time. I have setup a davical server, but it seems that even if I provide credentials events are not show. Does someone have a webdav besides google calendae working???
Greetings
movies
-
Works for me. Send me via PM test credentials for you DAVical.
-
Hi,
I want to display my google calendar. I made the settings in the calendar setting tab, select caldav, entered user and pass and the ical adress of my google calendar.
But no events are shown....
Do I have to change something in the config file?
Can anybody help?
Thx
Stefan
-
I can't get the roundcube calendar plugin working with CalDAV on a Davical server.
I'm using the plugin from roundcube-0.5.2-bundle-v2.8.
I don't see events appear in the calendar, and when saving a new event I get the message "an error ocurred while saving"
I could not find error logs about the issue, what could be wrong?
-
I resolved my issue. Remote clients were working ok on Davical, but roundcube installed on the same server wasn't due to a local routing issue.
-
hello, really nice plugin, I love the jquery UI!
Seems that rosali is doing a great job here.
I'm trying to setup RC as a calDAV client, but it won't work.
I've installed SabreDav and it's working in Evolution (Ubuntu) with these settings:
URL: caldav://travian-online.de/calendarserver.php/calendars/admin/default/
user: admin
pw: admin
I've tried almost every possible combination of Server/URL in RC. But feel free to try it on your own.
(it also doesn't work in my mail4us.net account)
error log says "get_resource_type() expects parameter 1 to be resource, boolean given in /var/www/roundcube/plugins/calendar/program/backend/caldav/caldav-client.php on line 191"
Is there a chance, you can help me make it work?
If not: Has some else experience with a good working CalDAV / roundcube combination?
I'm willing to change to CaliDav, if that's better.
Thanks, johannes
-
This bug has been fixed meanwhile but not officially released:
Issue 203 - myroundcube - calendar: search feature - RoundCube Plugins - Google Project Hosting (http://code.google.com/p/myroundcube/issues/detail?id=203)
-
Hi,
I want to display my google calendar. I made the settings in the calendar setting tab, select caldav, entered user and pass and the ical adress of my google calendar.
But no events are shown....
Do I have to change something in the config file?
Can anybody help?
Thx
Stefan
Here are my settings (2-way sync with gmail calendar):
Username: blabla@gmail.com
Password: myPasswordForgmailAccount
CalDavServer ssl://www.google.com:443
URL: https://www.google.com/calendar/dav/blabla@gmail.com/events
Maybe you forgot the '@gmail.com" at username? Or didn't replace youraccount@gmail.com in the URL?
-
I would like to remind you!
Would be a great feature... O0
I don't know how to call an enhancement (Issues - myroundcube - RoundCube Plugins - Google Project Hosting (http://code.google.com/p/myroundcube/issues/list)) :confused:
GREAT O0
Is it possible to see the date of an entry in the search results?
Reason: There are 6 meetings with the same name (e.g. TEST), same summary,... If I search for this entry (TEST), I can see 6 results. But there is no possibility to differentiate between those results.
-
This is already implemented. Test the snapshot as mentioned on the front screen of myroundcube - RoundCube Plugins - Google Project Hosting (http://myroundcube.googlecode.com)
Notice: You'll see the start time as tooltip on mouse over.
Please post comments regarding the search feature here:
http://code.google.com/p/myroundcube/issues/detail?id=203
Usability question:
Currently it triggers the search request on keyup event. So search requests are fired if the search string's length is longer than 2 chars when the content of the search field change. From the point of view of an user this very comfortable, but it is rather resource consuming on the backend.
Should I make it to be configurable to fire search requests only on ENTER?
-
I installed today the calendar-plugin for roundcube. First many thanks to rosali for the good work.
One question regarding CalDav-Calendars: Is it possible to add more than one calendar within the plugin (read and write, feeds are not enough)? If no, is it planned to be implemented in the near future?
Pezzi
-
No, it is not possible. It is planned for the end of this year, maybe earlier.
-
Hi,
I've just installed the calendar plugin for the first time from v1.1 of the 0.5.3 plugin bundle (very nice, thanks!) so possibly there is a reason for this behaviour I'm not aware of, but when editing existing tasks it appears that it is not possible to update the start and end date/time. In order to allow the start/end details for the task to be updated I had to make the following modifications to program/backend/database.php:
# diff /tmp/myrc/trunk/plugins/calendar/program/backend/database.php ./
171c171
< SET ".$this->q('summary')."=?, ".$this->q('description')."=?, ".$this->q('location')."=?, ".$this->q('categories')."=?, ".$this->q('rr')."=?, ".$this->q('recurring')."=?, ".$this->q('expires')."=?, ".$this->q('occurrences')."=?, ".$this->q('byday')."=?, ".$this->q('bymonth')."=?, ".$this->q('bymonthday')."=?, ".$this->q('timestamp')."=?, ".$this->q('notified')."=?
---
> SET ".$this->q('start')."=?, ".$this->q('end')."=?, ".$this->q('summary')."=?, ".$this->q('description')."=?, ".$this->q('location')."=?, ".$this->q('categories')."=?, ".$this->q('rr')."=?, ".$this->q('recurring')."=?, ".$this->q('expires')."=?, ".$this->q('occurrences')."=?, ".$this->q('byday')."=?, ".$this->q('bymonth')."=?, ".$this->q('bymonthday')."=?, ".$this->q('timestamp')."=?, ".$this->q('notified')."=?
173a174,175
> $start,
> $end,
after which things work as I expected them to. Although I'm not using it it looks like the program/backend/caldav.php file would need a similar update to enable editing start and end dates as well.
-
In prior releases editing start/end was triggered by an additional AJAX call to resize events. I removed this redundant call and forgot to update the query accordingly .... grrrrr .... thank you!
-
I like to use public calendars (ics-files). At the moment the files are saved in [url_to_rc/plugins/calendar/ics/file.ics].
So everyone has the posibility to download the files.
Is it possible to store the files in an secure folder (eg. .htaccess)?
-
Yes, it is possible. Create a web-accessible folder outside Roundcube root and secure this folder by .htaccess to accept only requests from your server IP or localhost. All layers are fetched by cURL requests.
-
I'm looking for just the calendar plugin. All I seem to be able to find is a 'bundle' with a lot of plugins. Can you point me to where I can download the plugin? Thanks.
-
Download the bundle and just pick 'jqueryui' and 'calendar' plugin. Where is the problem?
-
Hi Rosali,
first, thanks for the great plugin(s). I had two issues, though, when installing the calendar, which I would like to share with you:
When the curl option CURLOPT_FOLLOWLOCATION is set in line 711 of program/class.http.php, I got a fatal error, because on my server open_basedir is set (and cannot be changed by me). As a workaround I commented out this line and do not seem to have any negative side effects. So maybe it could be configurable whether redirects are followed.
When trying to access my Google Calendar via CalDAV, I had the problem that the password was lost somewhere on the way.
I was able to trace the issue to program/backend/caldav.php. In line 41 the password is being decrypted, while (in my installation) it is plain already. So I changed
'pass' => $this->rcmail->decrypt($this->rcmail->config->get('caldav_password',$this->rcmail->encrypt('pass'))),
to
'pass' => $this->rcmail->config->get('caldav_password','pass'),
and now the Google Calendar events are loaded. Is this a bug it your code, or a corrupted installation on my side?
Regards
Ulrich
-
Thanks for reporting/debugging this. Could you please open a ticket myroundcube - RoundCube Plugins - Google Project Hosting (http://myroundcube.googlecode.com). Tickets are my prefered way to make sure not to forget things!
-
Ok, done for the password issue. The other one I cannot reproduce at the moment, so it seems to be configuration specific. I will open a ticket as soon as it occurs again.
-
When I run the test as stated in the calendar plugin's README file I get a PHP error:
PHP Error in /usr/local/disks/data1/www-root/mail/rundkub/program/include/rcube_template.php (402): Error loading template for calendar.redirect
and the page says: "SERVICE CURRENTLY NOT AVAILABLE!
Error loading template for calendar.redirect"
Does anyone have any idea of what might be wrong?
Cheers,
Freddy
-
Which skin are you using? The should be a file redirect in the templates subfolder of the skin.
-
Hi Rosalie,
Thanks for maintaining all those plugins. I seem to have the same error as some posts above, i have no encryption and my calendar does not get populated from the caldav server (radicale). However if i create a post it does put it into the caldav calendar file. I don't find any errors in the log. Any ideas??
-
Tried to find the line mentioned earlier, but this seems a little different:
changing
$pass = $this->rcmail->config->get('caldav_password',$this->rcmail->encrypt('pass'));
in
$pass = $this->rcmail->config->get('caldav_password','pass');
Doesn't seem to work. The strange part is that my events still get posted to my caldav calendar, not retrieved. must be something easy i'm overlooking.
-
I also tried to set it up in your demo account, but got the same result, it doesn't seem to be able to retrieve any items, yet it seems to connect (place items in there).
-
There will be a new release tomorrow to fix this issue.
Just follow: Issue 283 - myroundcube - calendar: event deletion fails on davical - RoundCube Plugins - Google Project Hosting (http://code.google.com/p/myroundcube/issues/detail?id=283)
-
Please test new release.
-
This time it works, i upgraded to the latest callendar, but also to the latest version of the caldav server. I found out it was not the cause of the calendar plugin, but it was the version of the radicale caldav server, now everything works. thanks a lot!
-
OK ... Do you have more details for me? I have dozens of similiar requests that Calendar Plugin stopped working. What is exactly the point which leeds to issues with Radical CalDAV? You can contact me directly (myroundcube at mail4us dot net).
-
I'm not sure what the problem was, I got nothing in the log, the strange thing is that it did place items on the caldav server, but could not retrieve anything.
Anyway, I went from Radicale 0.4 to the most recent (0.6.3) and then it just started working. I don't think it has to do you with your upgrade.
Thanks a lot, I've been using it now for a few day and works excellently. I did remove the calendar feeds though, as it seemed to keep resolving the default mydomain.tld address, even though I had removed it in the settings, removed all the feeds from there.
After deleting the line from the config file it was really removed.
-
Hi,
Thanks for implementing the CalDAV backend. Althought I've been waiting for it for long time, I just happened to try it now.
I'm having some difficulties, and questions. Should it be of importance, I'm using the latest version of myroundcube, on roundcube 7.1. My DAV server is DaviCAL, on the same host, a debian squeeze.
1) First, I guess I have the same problems of syncing as some other people. When setting up my account by hand, I can create events in the roundcube calendar, which are correctly sent to the davical server (this was checked using an other caldav client). However, the roundcube calendar never see the events that are on the server (ie : the roundcube calendar stays empty almost all the time). There is no errors in the apache logs. Roundcube indicates "calendar has been replicated successfully", even though it displays an empty calendar.
Potential clue : my apache's access.log does show the event creation :
davical.my.domain:443 192.168.0.13 - myaccount [02/Mar/2012:18:35:50 +0100] "PUT /caldav.php/myaccount/agenda/20120302T183550Z-MqW0Squ.ics HTTP/1.1" 201 2146 "-" "DAViCalClient"
However, it does not show anything when refreshing the calendar. I think the roundcube request should be logged. (using other clients, the requests are indeed logged). Maybe roundcube never send the request ?
2) I'm not sure about the "default_caldav_backend". Is it supposed to pre-create an agenda account for new users ? If so, it's not working for me. In my preferences/calendar, the default provider is the webmail.
3) I've seen it should be possible to configure several caldav calendars ("max_caldavs"). How can I do that ?
Should it be relevant, I join my config.inc.php. I've only changed my domain name to "my.domain".
Thanks !
-
Enable caldav_debug in calendar config and report log entries.
-
Doh, as nothing was showing up in the log, I realised roundcube global logging wasn't activated (silly me...). Turns out config.inc.php got wrong rights, and wasn't read at all. Giving the appropriate rights, problem 1) and 2) are now solved.
Thanks for your help, and sorry for being dumb.:-[
While you're here, may I re-ask about point 3 ? (multiple calendars)
-
You can associate CalDAVs to a category. To do that goto calendar settings in preferences section.
-
Ok, working great, thanks a lot !