Horde Address Book missing after upgrade - Horde Addressbook:DBError:field

[GhOsTisp]

Hi,

last week, i upgrade my server plesk 9.3.0 to 9.5.1. After all, most works fine, but now we missing the horde address book.

i have install rpm psa-turba and all addons.


and i patch this with: cat /usr/share/psa-horde/turba/scripts/upgrades/2.2.1_to_2.3.sql2.2.1_to_2.3.sql | mysql -uadmin -p`cat /etc/psa/.psa.shadow` horde


but the problem not solved, any solution yet?? please help me¡¡¡¡

 

[GhOsTisp]

error log : Apr 20 18:05:16 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@domain.com' AND event_alarm > 0 AND ((event_end >= '2010-04-20 00:00:00') OR (event_recurenddate >= '2010-04-20 00:00:00' AND event_recurtype <> 0)) [nativecode=1054 ** Unknown column 'event_private' in 'field list'] [pid 26294 on line 323 of "/usr/share/psa-horde/kronolith/lib/Driver/sql.php"]
Apr 20 18:05:16 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@domain.com') [nativecode=1054 ** Unknown column 'object_firstname' in 'field list'] [pid 26294 on line 173 of "/usr/share/psa-horde/turba/lib/Driver/sql.php"]

 

[GhOsTisp]

here you are the solution http://blogofsysadmins.com/problema...orde-al-actualizar-a-plesk-a-la-version-9-5-1

 

[magasoft]

Database tables kronolith_events and turba were not updated by autoinstaller due probably of missing rights or a misconfigured /etc/php5/cli/php.ini (at least by me...).
I fixed it by changing temporarily cli/php.ini:
1. SAFE MODE = Off
2. include_path = ".:/usr/share/php5/PEAR:/usr/share/psa-pear"

Then run the upgrade script manually:
/usr/share/psa-horde/turba/scripts/2.1_to_2.2_sql_schema.php

For table kronolith_events simply add field "event_recurcount" as INT and "event_private" as INT DEFAULT 0 NOT NULL using phpmyadmin.