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 Expand


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