Skip to content
  • Solutions
    By Role
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    • For Developers
    • For Content Managers
    • For Agencies
    • For IT Admins
    • For Web Hosters
    By Infrastructure
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Overview
    • AWS
    • Microsoft Azure
    • Alibaba Cloud
    • Google Cloud Platform
    • Vultr
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
    • Digital Ocean
    • Linode
    • Upcloud
    • Oracle
    • OVH
  • Product
    • Plesk Features
    • Plesk Editions
    • What’s new
    • Pricing
    • Roadmap
    • Lifecycle Policy
    • Extensions Catalogue
  • Pricing
  • Extensions
    Featured Extensions
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    • SocialBee
    • WP Toolkit
    • Sitejet Builder for Plesk
    • SEO Toolkit
    • Joomla! Toolkit
    • Premium Email
    • Email Security
    Bundles and packs:
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack
    • Business and Collaboration Edition
    • WP pack
    • Hosting pack
    • Power pack
    • Language pack

    See all Extensions

  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
  • Pricing
  • Solutions
    • By Role
      • For Developers
      • For Content Managers
      • For Agencies
      • For IT Admins
      • For Web Hosters
    • By Infrastructure
      • Overview
      • Plesk on Amazon Web Services (AWS & Lightsail)
      • Microsoft Azure
      • Alibaba Cloud
      • Google Cloud Platform
      • Vultr
      • DigitalOcean
      • Linode
      • UpCloud
      • Oracle
      • OVH
  • Products
  • Pricing
  • Extensions
    • Featured Extensions
      • SocialBee
      • WP Toolkit
      • Sitejet Builder for Plesk
      • SEO Toolkit
      • Joomla! Toolkit
      • Premium Email
      • Email Security
    • Bundles and packs:
      • Business and Collaboration Edition
      • WP pack
      • Hosting pack
      • Power pack
      • Language pack
      • See all Extensions
  • For Partners
    • Plesk Contributor Program
    • Plesk Partner Program
    • Affiliate Program
    • Plesk University
  • Help Center
    • Documentation
    • Professional Services
    • Support
    • Contact Us
    • Wiki
    • Forum
  • Plesk 360 login
  • Free Trial
Plesk 360 login
Free Trial

Knowledge Base

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

 
databasedbemailhordehorde webmail

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:

  • 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:

  1. Connect to the server via SSH

  2. Back up the /var/lib/mysql/horde directory:

    # cp -rp /var/lib/mysql/horde /root/

  3. Drop the horde database:

    # plesk db "drop database horde"

  4. Empty the /var/lib/mysql/horde directory:

    # rm -rf /var/lib/mysql/horde

  5. Remove Horde webmail component:

    # plesk installer remove --components horde

  6. 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

  7. 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

  8. Install Horde:

    # plesk installer add --components horde

Tweet
Share
Share
Email
0 Shares
Read the full article
Related Posts

Plesk with Centralized Database and Network File System

Read More »

Advanced Techniques for Building an Email List

Read More »

6 Things to Keep in Mind When Choosing an Ideal Server for Big Data Requirements

Read More »
Knowledge Base

Plesk shows: example.com_webmail.conf: SSLCACertificateFile: file ‘/usr/local/psa/var/certificates/certxxxXXX’ does not exist or is empty

Read More »

Plesk and websites are inaccessible after updating Plesk to Obsidian 18.0.43 on RHEL 8-based OS: DB query failed: SQLSTATE[HY000] [2002] No such file or directory

Read More »

Mail accounts cannot log into Plesk web interface if password is encrypted

Read More »

Excessive SRS header is displayed in From field in mail clients for some forwarded emails

Read More »

Hosting Wiki

  • DBMS Interface
  • DB2
  • Server Redundancy
  • DBMS
  • Horde
  • QMAIL
  • Sendmail
  • Linux Containers
  • Bare Metal Server
  • MySQL
  • Oracle VM Server
  • Server Virtualization Software
  • Windows Server
  • Linux
  • IBM DB2
  • ODBC
  • MongoDB
  • DBA
  • SQL
  • Plesk
  • SQL database
  • NoSQL Database
  • Web Server
  • DNS Server
  • SSH
  • Email Autoresponder
  • Mailing Lists
  • Email Alias
  • Email Virus Protection
  • Email Forwarding
  • Webmail
X-twitter Linkedin Youtube Reddit Github
  • Product
  • Login
  • Pricing
  • Editions
  • For Partners
  • Partner Program
  • Contributor Program
  • Affiliate Program
  • Plesk University
  • Company
  • Blog
  • Careers
  • Events
  • About Plesk
  • Our Brand
  • Resources
  • User and Admin guides
  • Help Center
  • Migrate to Plesk
  • Contact Us
  • Hosting Wiki
  • Forum
  • Legal
  • Legal
  • Privacy Policy
  • Imprint

© 2025 WebPros International GmbH

Part of the WebPros®  Family