Domains list is empty: Inconsistency in the table ‘dom_param’ for the column dom_id: No rows in the table ‘domains’

Symptoms

• The list of domains at Plesk > Domains is empty. The following error might be shown:

  PLESK_ERROR:external error ;-P
  TypeError: Cannot read property 'escapeHTML' of null

• When changing plan to a subscription the following error is shown:

  Error code: 2204. Error message: Unable to update hosting preferences. ProtDirUser_IIS::update() failed: Update Protected Directory #1 user failed: URL '/plesk-stat' is not protected In IIS7NativeProvider module Exception type: System.Exception at ProtectedUrls.get(ProtectedUrls* , unique_ptr >* , basic_string,std::allocator >* path) at updateProtectedUrlUser(example.com, /plesk-stat, johndoe, )(WebServerManager::updateProtectedUrlUser line 792) at execute console command --update-protected-url-user(vconsoleapp::start line 122) at execute "C:Program Files (x86)ParallelsPleskadminbin64websrvmng" --update-protected-url-user "--vhost-name=example.com" "--path=/plesk-stat" "--login=johndoe" "--new-password=*"(vconsoleapp::run line 139) (Error code 1)

Cause

Database inconsistency. Orphaned database registries.

Resolution

1. Connect to the server via RDP or SSH

2. Make a backup of Plesk database: How to backup/restore a Plesk database dump.

3. Execute the following command and remove the orphaned registries when it's prompted:

   C:> plesk repair db