jQuery Fullcalendar plugin (forked by rosali)

[rosali]

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

[rosali]

@ Jack!

Did you change the default dummy driver in calendar's config to use database backend?

[Jack!]

@ Jack!

Did you change the default dummy driver in calendar's config to use database backend?

Code Select Expand

$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.

[danpep]

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:

Code Select Expand

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!

[Jack!]

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:

Code Select Expand

ALTER TABLE `events` ADD `client` text;

[danpep]

Code Select Expand

ALTER TABLE `events` ADD `client` text;

Excellent! Now it works again. Thanks!

[rosali]

@ Jack: Does it work for you now?

[Jack!]

@ 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?

[rosali]

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

[Jack!]

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

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:

Code Select Expand

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


[Carrot Cruncher]

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.

[rosali]

@ 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.

[mezcal]

hi, I have the same problem like Carrot Cruncher. I can`t join calendar with recurring events.
example: ?eské svátky

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

[Carrot Cruncher]

@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.

[Jack!]

See my next message.