Symptoms
-
It is not possible to access Horde webmail or open specific menus in webmail with one of the following error messages:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.horde_prefs' doesn't exist
Server error when querying database.
A fatal error has occurred Could not instantiate PDO. PDOException: SQLSTATE[HY000] [1049] Unknown database 'horde'
-
In Plesk, it is not possible to remove/rename an email account or rename a domain with the error message:
DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.TABLE_NAME' doesn't exist, query was:
Cause
The database of Horde webmail is missing or corrupted.
Resolution
Note: If Horde webmail is not required on the server and another webmail is being used server-wide (Roundcube/MailEnable), remove the Horde component from the server.
-
Connect to the Plesk server via SSH.
-
For security reasons, create a copy of the
/var/lib/mysql/hordedirectory:# cp -r /var/lib/mysql/horde /root/
-
Empty the
/var/lib/mysql/hordedirectory:# rm -rf /var/lib/mysql/horde
-
Drop the 'horde' database:
# plesk db "drop database horde"
-
If you get the message below, ignore it and move to step 4:
CONFIG_TEXT: ERROR 1008 (HY000) at line 1: Can't drop database 'horde'; database doesn't exist
-
-
Switch to the directory with daily dumps:
# cd /var/lib/psa/dumps
-
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.gzis the most recent daily dump.
-
-
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
-
Connect to the Plesk server via RDP.
-
Switch to the directory with daily dumps:
C:> cd %plesk_dir%MysqlBackup
-
List all available Plesk daily dumps sorted by date (newest first):
C:> dir /O:-D
Directory of C:Program Files (x86)PleskMySQLBackup
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 -
Restore the Horde database:
C:> "%plesk_dir%Mysqlbinmysql.exe" -uadmin -P3306 -p horde < horde-20181018020721.sql
Note: MySQL admin user password is required for this operation. If the password is unknown, go to Tools & Settings > Database Servers > click
next to MySQL/MariaDB to enter phpMyAdmin. In phpMyAdmin, click horde > Import > Browse to select the horde-....sqlfile from step 4 > then click Go to import the database.