Horde malfunction after upgrade

[RutgerH]

Hi all,

We recently upgraded from plesk 9.3 to 9.5 .
After the upgrade the horde calendar is giving the error; ErrorDB Error: no such field and the calendar is empty.

We found the KB article for this issue on a Linux platform; http://kb.odin.com/en/8520

Is this also a issue known for Windows ? Or does someone can tell me how to fix the SQLite tables ?

The exact error that is displayed in de horde log file;

Jun 07 12:46:23 HORDE [error] [kronolith] DB Error: no such field: 1 ** SELECT event_id, event_uid, event_description, event_location, event_private, event_status, event_attendees, event_keywords, event_title, event_category, event_recurcount, event_recurtype, event_recurenddate, event_recurinterval, event_recurdays, event_start, event_end, event_alarm, event_modified, event_exceptions, event_creator_id FROM kronolith_events WHERE calendar_id = 'NAME@DOMAIN.TLD' AND ((event_end >= '2010-05-31 00:00:00' AND event_start <= '2010-07-07 00:00:00') OR (event_recurenddate >= '2010-05-31 00:00:00' AND event_start <= '2010-07-07 00:00:00' AND event_recurtype <> 0)) [nativecode=no such column: event_private] [pid 5952 on line 323 of "D:\vhosts\webmail\horde\kronolith\lib\Driver\sql.php"]


Thanks!

 

[RutgerH]

A parallels engineer fixed this issue;

There were missed the following columns in kronolith_events table of horde database:
event_private INT DEFAULT 0 NOT NULL,
event_recurcount INT,

 

[GlobalServe]

What is the fix for windows?

 

[RutgerH]

This is a Windows related issue.

So the following columns were missing in thekronolith_events table of horde database:

event_private INT DEFAULT 0 NOT NULL,
event_recurcount INT,