Error when trying to log in to Plesk UI: Base table or view not found: 1146 Table ‘psa.smarthosts’ doesn’t exist

Symptoms

• The following error can be seen upon trying to log in to Plesk UI.

  external error
  Error: ERROR: PleskExceptionDatabase: DB query failed:
  "DESCRIBE `Smarthosts`"

  Error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'psa.smarthosts' doesn't exist, query was: DESCRIBE `Smarthosts` (Mysql.php:68)

• The Plesk 'psa' system database has been recovered from a Plesk daily dump, but the issue is not resolved.

Cause

Database table psa.Smarthosts is missing.

Resolution

Recreate the database:

1. Connect to the server via SSH or RDP

2. Create a backup of the psa database.

3. In the command prompt, run plesk db:

   # plesk db

   plesk db

4. Run the command below to recreate the table:

   CREATE TABLE `smarthosts` (
   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   `ownerId` int(10) unsigned NOT NULL,
   `host` varchar(255) NOT NULL,
   `port` smallint(5) unsigned NOT NULL DEFAULT 0,
   `username` varchar(255) NOT NULL,
   `password` varchar(255) NOT NULL,
   `encryption` enum('on','off','tls','ssl') DEFAULT NULL,
   PRIMARY KEY (`id`),
   KEY `ownerId` (`ownerId`)
   ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;