1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Horde malfunction after upgrade

Discussion in 'Plesk 9.x for Windows Issue, Fixes, How-To' started by RutgerH, Jun 7, 2010.

  1. RutgerH

    RutgerH New Pleskian

    19
    85%
    Joined:
    Nov 27, 2009
    Messages:
    17
    Likes Received:
    0
    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!
     
  2. RutgerH

    RutgerH New Pleskian

    19
    85%
    Joined:
    Nov 27, 2009
    Messages:
    17
    Likes Received:
    0
    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,
     
  3. GlobalServe

    GlobalServe Basic Pleskian

    24
    23%
    Joined:
    Aug 15, 2005
    Messages:
    89
    Likes Received:
    0
    What is the fix for windows?
     
  4. RutgerH

    RutgerH New Pleskian

    19
    85%
    Joined:
    Nov 27, 2009
    Messages:
    17
    Likes Received:
    0
    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,
     
Loading...