PHP Warning - calendar.php line 3811

[ineo]

Also after upgrading to the latest version (30-08-2012) I still get the following warning in <path>/logs/errors

[01-Sep-2012 07:31:11 UTC] PHP Warning:  Illegal string offset 'entry' in <path>/plugins/calendar/calendar.php on line 3811

Any idea how to solve this.

Grtz iNeo

[ineo]

I checked my current calendar tables with the tables that wil by created by
<path>/plugins/calendar/SQL/mysql.sql and found out that there are differences.

Is there an easy way to fixs this? Maybe that wil solve the error message.

One thing that I allready changed because it was missing, the url field in events, events_cache, events_caldav etc etc

"ALTER TABLE events ADD url TEXT;"

I did this for al tables that had url missing.

Grtz, iNeo

[Yoni]

I checked my current calendar tables with the tables that wil by created by
<path>/plugins/calendar/SQL/mysql.sql and found out that there are differences.

Is there an easy way to fixs this? Maybe that wil solve the error message.

One thing that I allready changed because it was missing, the url field in events, events_cache, events_caldav etc etc

"ALTER TABLE events ADD url TEXT;"

I did this for al tables that had url missing.

Grtz, iNeo

If you are using calendar plugin from MyRoundcube Plugins, there are "important notes" in Plugin Manager Center: http://mirror.mail4us.net/docs/calendar.html

This is a simple update and you probably missed the info provided.

[Volnhar]

Just be careful as the other update script there is not correct, it should be as below otherwise you will get errors about duplicate 'start' entry.

Code: [Select]

ALTER TABLE `events` CHANGE `start` `start` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `events` CHANGE `end` `end` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `events` CHANGE `expires` `expires` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `events_cache` CHANGE `start` `start` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `events_cache` CHANGE `end` `end` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `events_cache` CHANGE `expires` `expires` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `events_caldav` CHANGE `start` `start` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `events_caldav` CHANGE `end` `end` INT( 11 ) NOT NULL DEFAULT '0';
ALTER TABLE `events_caldav` CHANGE `expires` `expires` INT( 11 ) NOT NULL DEFAULT '0';


[ineo]

Thanks for the mysql changes.

I have run the commands and now wait and see if this solves the error message.
In the meantime I see error messages about empty group memberships and after
trying to use iCloud al my local calendar items where cleared and iCloud isn't working :S

I do have a backup from my old database but I don't know what table to restore so my
calendar items are back again.

Maybe somebody can answer the question what to restore so the calendar items are available again.

Grtz, iNeo