Resolved Plesk Onyx 17.8.11 Update #22 with Error 500 Plesk Exception Database

[Rot]

Server Error
500
Plesk\Exception\Database
DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rnameType' in 'field list', query was: select `id`, `name`, `displayName`, `email`, `status`, `syncRecords`, `syncSoa`, `type`, `ttl`, `ttl_unit`, `refresh`, `refresh_unit`, `retry`, `retry_unit`, `expire`, `expire_unit`, `minimum`, `minimum_unit`, `serial`, `serial_format`, `external_id`, `rnameType` from `dns_zone` where `id`=2

Type Plesk\Exception\Database
Message DB query failed: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'rnameType' in 'field list', query was: select `id`, `name`, `displayName`, `email`, `status`, `syncRecords`, `syncSoa`, `type`, `ttl`, `ttl_unit`, `refresh`, `refresh_unit`, `retry`, `retry_unit`, `expire`, `expire_unit`, `minimum`, `minimum_unit`, `serial`, `serial_format`, `external_id`, `rnameType` from `dns_zone` where `id`=2
File Mysql.php
Line 53

 

[m3lezZ]

In this order:
You could first try

# plesk repair db -y

Then, if that did not solve the issue,

# plesk repair installation

If that still did not solve the issue:

# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components

 

[Rot]

The error ocurre when to selected a subscription or domain for display your info.

 

[Rot]

Hi @m3lezZ this is the solution:

# plesk repair db -y

Checking the Plesk database using the native database server tools .. [OK]

Checking the structure of the Plesk database

Column rnameType is absent in the table dns_zone .................. [ERROR]
Creating a database dump ........................................ [OK]
A dump of the database was created before an attempt to repair the database: /var/lib/psa/dumps/mysql.preresolve.20180924-102708.dump.gz
Repairing table 'dns_zone' ...................................... [FIXED]

Checking the consistency of the Plesk database ...................... [OK]

Error messages: 1; Warnings: 0; Errors resolved: 1