• The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

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

Rot

New Pleskian
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
 
In this order:
You could first try
Code:
# plesk repair db -y

Then, if that did not solve the issue,
Code:
# plesk repair installation

If that still did not solve the issue:
Code:
# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components
 
The error ocurre when to selected a subscription or domain for display your info.
 
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
 
i'm sorry but i have this résponse:
plesk repair db -y
[2024-09-14 10:06:06.406] 670942:66e5600e63124 ERR [panel] Cannot load settings: DB query failed: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'psa.misc' doesn't exist in engine, query was: select param, val from misc
[2024-09-14 10:06:06.448] 670942:66e5600e63124 ERR [panel] Cannot save cli call statistic DB query failed: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'psa.CliCallsStat' doesn't exist in engine, query was: INSERT CliCallsStat (`util`, `command`, `lastExecutionDateTime`) VALUES :)util, :command, now()) ON DUPLICATE KEY UPDATE `count` = `count` + 1, `lastExecutionDateTime` = now()

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

Checking the structure of the Plesk database
DB query failed: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'psa.accounts' doesn't exist in engine, query was: DESC accounts
The database structure is corrupted. You can try to repair it with "plesk repair installation" and "plesk repair db".

exit status 1
 
Back
Top