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

Nikita Zubovich

Updated June 07, 2023 07:59

kb: bug kb: fixed Plesk Obsidian for Linux

Applicable to:

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

Product issue:

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

Please consider updating your server:

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