ATTN: Development Team.
Below are few lines from psa-horde.log that I had captured before I solved my Horde nightmare by installing older version of Horde included with Plesk 9.3.0.
I suspect Plesk upgrade is not updating the Horde database with the new structure for some reason.
May 02 21:46:50 HORDE [error] [turba] DB Error: no such field: SELECT object_id, owner_id, object_type, object_members, object_uid, object_firstname, object_lastname, object_middlenames, object_nameprefix, object_namesuffix, object_alias, object_bday, object_homestreet, object_homepob, object_homecity, object_homeprovince, object_homepostalcode, object_homecountry, object_workstreet, object_workpob, object_workcity, object_workprovince, object_workpostalcode, object_workcountry, object_tz, object_email, object_homephone, object_workphone, object_cellphone, object_fax, object_pager, object_title, object_role, object_company, object_category, object_notes, object_url, object_freebusyurl, object_pgppublickey, object_smimepublickey FROM turba_objects WHERE (object_type = 'Group' AND owner_id = '
[email protected]') [nativecode=1054 ** Unknown column 'object_firstname' in 'field list'] [pid 2211 on line 173 of "/usr/share/psa-horde/turba/lib/Driver/sql.php"]
May 02 21:46:50 HORDE [error] [turba] DB Error: no such field: SELECT object_id, owner_id, object_type, object_members, object_uid, object_firstname, object_lastname, object_middlenames, object_nameprefix, object_namesuffix, object_alias, object_bday, object_homestreet, object_homepob, object_homecity, object_homeprovince, object_homepostalcode, object_homecountry, object_workstreet, object_workpob, object_workcity, object_workprovince, object_workpostalcode, object_workcountry, object_tz, object_email, object_homephone, object_workphone, object_cellphone, object_fax, object_pager, object_title, object_role, object_company, object_category, object_notes, object_url, object_freebusyurl, object_pgppublickey, object_smimepublickey FROM turba_objects WHERE (object_type = 'Group' AND owner_id = '
[email protected]') [nativecode=1054 ** Unknown column 'object_firstname' in 'field list'] [pid 2211 on line 79 of "/usr/share/psa-horde/turba/lib/base.php"]
May 02 21:48:19 HORDE [error] [kronolith] DB Error: no such field: 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 = '
[email protected]' AND event_alarm > 0 AND ((event_end >= '2010-05-02 00:00:00') OR (event_recurenddate >= '2010-05-02 00:00:00' AND event_recurtype <> 0)) [nativecode=1054 ** Unknown column 'event_private' in 'field list'] [pid 2584 on line 323 of "/usr/share/psa-horde/kronolith/lib/Driver/sql.php"]
Hope it helps.
Regards,
Faisal Alvi.