El problema que os comento me ha pasado con Horde (webmail por defecto en Plesk) por actualizar Plesk de la versión 9.3.0 a 9.5.1.
El problema estaba bien claro, al intentar acceder a la libreta de direcciones que Horde guarda, Horde daba el siguiente error:
DBError: field
y el log de Horde daba el siguiente error:
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"]
Vale pues despues de tantos errores aqui os digo la solución que mas o menos daban en los foros de parallels y que yo le aplique al dichoso error.
El error es debido a que Plesk al actualizar a la versión 9.5.1 instala la versión de psa-turba 2.3.3 que es la que crea el complemento de la libreta de direcciones en Horde, pues desinstalamos ese rpm que Plesk instalo:
rpm -e –nodeps psa-turba-2.3.3
Ahora nos vamos a bajar el anterior paquete rpm de la versión de psa-turba que es el 2.1.7 y posteriormente lo instalamos y listo.
wget http://autoinstall.plesk.com/PSA_9.3.0/dist-rpm-CentOS-5-x86_64/opt/horde/psa-turba-2.1.7-cos5.build93091230.06.noarch.rpm
rpm -i psa-turba-2.1.7-cos5.build93091230.06.noarch.rpm
Y listo¡¡¡ ya tenemos la libreta de direcciones que guarda Horde y no hemos perdido ningún contacto porque no hemos tocado la base de datos ni las tablas que usa Horde.
