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
Please consider updating your server:
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/hordedirectory:# cp -rp /var/lib/mysql/horde /root/
- Drop the
hordedatabase:# plesk db "drop database horde"
- Empty the
/var/lib/mysql/hordedirectory:# 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.dbfile by running the command below:# sed -i '/^horde/d' /var/lib/plesk/components-configuration-state.db
- Install Horde:
# plesk installer add --components horde
