- Plesk Obsidian for Linux
- Plesk for Linux
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]  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
Horde's database is missing or corrupted, but due to a bug #PPPM-12017, the database is not recreated during Horde reinstallation.
While a permanent fix is not available, the following workaround can be applied:
Connect to the server via SSH
Back up the
# cp -rp /var/lib/mysql/horde /root/
# plesk db "drop database horde"
# rm -rf /var/lib/mysql/horde
Remove Horde webmail component:
# plesk installer remove --components horde
Back up the
# 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.dbfile by running the command below:
# sed -i '/^horde/d' /var/lib/plesk/components-configuration-state.db
# plesk installer add --components horde