Articles in this section

See more

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

Avatar
Kuzma Ivanov
Updated
Follow

Applicable to:

  • Plesk for Linux

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

 

 

For Plesk on Linux

 

  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.

 

For Plesk on Windows Server

 

  1. Connect to the server via RDP.

  2. Start a command prompt as an Administrator.

  3. Switch to the directory with daily dumps:

    C:\> cd %plesk_dir%Mysql\Backup

  4. List all available Plesk daily dumps sorted by date (newest first):

    C:\> dir /O:-D
    \
    Directory of C:\Program Files (x86)\Plesk\MySQL\Backup
    \
    10/18/2018 02:07 AM 106,128 horde-20181018020721.sql
    10/18/2018 02:07 AM 122,124 config-20181018020721.reg
    10/18/2018 02:07 AM 28,707 apsc-20181018020721.sql
    10/18/2018 02:07 AM 389,032 psa-20181018020721.sql

  5. Restore the Horde database:

    C:\> "%plesk_dir%\Mysql\bin\mysql.exe" -uadmin -P3306 -p horde < horde-20181018020721.sql

    Note: MySQL admin password is required for this operation.
    If the password is not known, go to Tools & Settings > Database Servers > localhost > PhpMyAdmin > horde > Import and import the required backup file.

 

 

Related Articles

Comments

2 comments

Sort by Date Votes

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles