Unable to access to Horde webmail: Base table or view not found

Refers to:

  • Plesk for Windows
  • Plesk for Linux

Created:

2016-11-16 13:02:23 UTC

Modified:

2017-01-18 08:44:53 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to access to Horde webmail: Base table or view not found

Symptoms

After Plesk upgrade it is not possible to access Horde webmail. The following error appears:

Base table or view not found

The Horde log /var/log/psa-horde/psa-horde.log contains:

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'

or

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"]

The autoinstaller3.log contains:

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

Cause

The Horde database has an inconsistent state. It is possible that it was not upgraded for some reason.

Resolution

  1. Create a Horde database backup:

    MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -u admin horde > horde.dump
  2. For Plesk 11.5 only, it is possible to use the upgrade script upgrade_horde_db_11-5.txt to 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:

  3. Linux

    1. Go to http://autoinstall.plesk.com/PSA_VERSION/ and choose your system and architecture.

    2. Open the /opt/horde/ directory and download the packages.

    3. 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
  4. Windows

    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.
Have more questions? Submit a request
Please sign in to leave a comment.