Symptoms
When logging into the Webmail Horde interface, the following error is returned in the browser.
A fatal error has occurred
SQLSTATE[HY000]: General error: 1 no such table: horde_prefs
Details have been logged for the administrator.
Description
When the cPanel accounts Horde SQLite database is corrupted or missing tables, the above error will be produced.
Workaround
This error can be address by recreating the accounts Horde SQLite database. To perform this task, follow the below steps.
In the below examples you would replace instances of $cpuser with the account's username.
Move the corrupted/partial SQLite database out of the way.
sudo -u $cpuser mv -v /home/$cpuser/.cphorde/horde.sqlite{,.$( date +%Y%m%d )}
Recreate the now moved Horde SQLite database.
/usr/local/cpanel/bin/update_horde_config --user=$cpuser