Horde databases in Plesk are not recreated after reinstallation: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'horde.TABLE_NAME' doesn't exist

Aleksandar Stoev

Updated April 09, 2026 13:16

kb: bug kb: fixed Plesk Obsidian for Linux

Applicable to:

Plesk Obsidian for Linux
Plesk for Linux

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.
Reinstalling Horde as per the article Unable to access Horde webmail or rename a domain in Plesk: Table 'horde.table_name' doesn't exist does not help

Cause

Product issue:

#PPPM-12017 "Horde works correctly after reinstallation."
Fixed in:
- Plesk Obsidian 18.0.53 06 June 2023 (Linux)

Resolution

Note: Horde has been deprecated in Plesk Obsidian 18.0.64 (September 2024) and removed in Plesk Obsidian 18.0.69 (April 2025). The recommended action is to switch to another webmail software supported in Plesk.

Please consider updating your server:

How to install Plesk updates

Workaround

If update is not possible for some reason, you may try the following

workaround

While a permanent fix is not available, the following workaround can be applied:

Connect to the server via SSH
Back up the /var/lib/mysql/horde directory:

# cp -rp /var/lib/mysql/horde /root/
Drop the horde database:

# plesk db "drop database horde"
Empty the /var/lib/mysql/horde directory:

# rm -rf /var/lib/mysql/horde
Remove Horde webmail component:

# plesk installer remove --components horde
Back up the /var/lib/plesk/components-configuration-state.db:

# cp -rp /var/lib/plesk/components-configuration-state.db /root/components-configuration-state.db.bkp
Remove the timestamp indicating the last Horde update from /var/lib/plesk/components-configuration-state.db file by running the command below:

# sed -i '/^horde/d' /var/lib/plesk/components-configuration-state.db
Install Horde:

# plesk installer add --components horde