After Plesk upgrade it is not possible to access Horde webmail. The following error appears:
Base table or view not found
The Horde log
HORDE [horde] SQL QUERY FAILED: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.rampage_types' doesn't exist SELECT type_id, type_name FROM `rampage_types` WHERE type_name IN ('calendar','event') [pid 54636 on line 815 of "/usr/share/psa-pear/pear/php/Horde/Db/Adapter/Base.php"] Base table or view not found: 1051 Unknown table 'horde_vfs_seq' Base table or view not found: 1051 Unknown table 'horde_muvfs_seq' Base table or view not found: 1051 Unknown table 'kronolith_shares_seq' Base table or view not found: 1051 Unknown table 'kronolith_resources_seq'
HORDE [horde] SQLSTATE[42S22]: Column not found: 1054 Unknown column 'attribute_color' in 'field list' [pid 21827 on line 1601 of "/usr/share/psa-pear/pear/php/Horde/Registry.php"]
Trying to upgrade Horde webmail configuration... Unable to upgrade 'horde' to the latest version, since its configuration is in broken state. Run bootstrapper repair to fix. Some problems are found during upgrade Horde webmail configuration(see log file: /tmp/plesk_11.5.30_installation.log) tac: write error ERROR while trying to act on PEAR packages - description directory is not specified or does not exist
Running the bootstrapper with the "repair" key shows the following error:
ERROR: PEAR packages - description directory is not specified or does not exist
The Horde database has an inconsistent state. It is possible that it was not upgraded for some reason.
Create a Horde database backup:
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin horde > horde.dump
For Plesk 11.5 only, it is possible to use the upgrade script
upgrade_horde_db_11-5.txtto upgrade the Horde database manually:
MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa` horde < /root/upgrade_horde_db_11-5.txt
For other Plesk versions, or if Horde files were not upgraded using the script on Plesk 11.5, reinstall the Horde packages from http://autoinstall.plesk.com:
Go to http://autoinstall.plesk.com/PSA_VERSION/ and choose your system and architecture.
/opt/horde/directory and download the packages.
Reinstall the Horde packages on the server using the command
rpm -Uvh package --force. For example:
rpm -Uvh psa-horde-verion-osversion.build120180812.16.noarch.rpm --force
In the case of a corrupted Horde installation, reinstall the component using Plesk Installer at Tools & Settings > Updates and Upgrades. Remove the Horde component, then reinstall it.