Unable to access Horde webmail or rename a domain in Plesk: Table 'horde.table_name' doesn't exist

Symptoms

• It is not possible to access Horde webmail:

  PLESK_INFO: A fatal error has occurred
  SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.horde_prefs' doesn't exist
  Details have been logged for the administrator.

• It is not possible to remove/rename an email account in Plesk:

  PLESK_ERROR: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.imp_sentmail' doesn't exist, query was: DELETE FROM horde.imp_sentmail WHERE (sentmail_who = 'john_doe@example.com')

  OR

  PLESK_ERROR: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.ingo_sharesng' doesn't exist, query was: DELETE FROM horde.imp_sentmail WHERE (sentmail_who = 'john_doe@example.com')

• It is not possible to rename a domain in Plesk:

  PLESK_ERROR: Error: External exception. SQLSTATE[42S02]: Base table or view not found: 1146
  Table 'horde.kronolith_events' doesn't exist,
  query was: UPDATE `horde`.`kronolith_events` SET `calendar_id` = CONCAT(SUBSTRING(`calendar_id`, 1, LOCATE("@", `calendar_id`)), 'example.net') WHERE (SUBSTRING(`calendar_id`, LOCATE("@", `calendar_id`)) = '@example.com')

• Re-installation of Horde webmail may fail with:

  CONFIG_TEXT: Re-installation of Horde or Roundcube using Plesk installer returns the following error:
  ====================
  Fatal Error:
  SQLSTATE[HY000]: General error: 1005 Can't create table 'horde.imp_schema_info' (errno: 121)
  In /usr/share/psa-pear/pear/php/Horde/Db/Adapter/Pdo/Base.php on line 231

Cause

The database of Horde webmail is missing or corrupted.

Resolution

1. Connect to the Plesk server via SSH.

2. For security reasons, create a copy of the /var/lib/mysql/horde directory:

   # cp -r /var/lib/mysql/horde /root/

3. Empty the /var/lib/mysql/horde directory:

   # rm -rf /var/lib/mysql/horde

4. Drop the 'horde' database:

   # plesk db "drop database horde"

5. Switch to the directory with daily dumps:

   # cd /var/lib/psa/dumps

6. Find the most recent dump that contains the 'horde' database:

   # zgrep "Current Database:" mysql.daily* | grep horde
   mysql.daily.dump.0.gz:-- Current Database: `horde`
   mysql.daily.dump.1.gz:-- Current Database: `horde`
   mysql.daily.dump.2.gz:-- Current Database: `horde`

   • where mysql.daily.dump.0.gz is the most recent daily dump.

7. Restore the 'horde' database from the most recent daily dump. In this example, the 'horde' database is restored from mysql.daily.dump.0.gz:

   # zcat mysql.daily.dump.0.gz | sed -n '/-- Current Database: `horde`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin

8. Try to access Horde.

   If the issue persists, restore the 'horde' database from a pre-upgrade dump. In this example, we are restoring the 'horde' database from a pre-upgrade dump created before an upgrade from Plesk 12.5:

   8.1. List pre-upgrade dumps:

   # ls -l mysql.preupgrade*
   -rw------- 1 root root 212341 Feb 1 05:18 mysql.preupgrade.12.5.30-12.5.30.20190214-051821.dump.gz
   -rw------- 1 root root 213230 Feb 1 13:50 mysql.preupgrade.12.5.30-17.8.11.20190214-135000.dump.gz

   8.2. Restore the 'horde' database from a pre-upgrade dump:

   # zcat mysql.preupgrade.12.5.30-12.5.30.20190214-051821.dump.gz | sed -n '/-- Current Database: `horde`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin

   8.3. Upgrade MySQL databases:

   # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin -T --debug-check mysql

   Note: If all daily and pre-upgrade dumps do not have a valid Horde backup, reinstall Horde webmail via Plesk Installer.

Related Articles

• How to back up/restore Plesk system databases