• Please be aware: Kaspersky Anti-Virus has been deprecated
    With the upgrade to Plesk Obsidian 18.0.64, "Kaspersky Anti-Virus for Servers" will be automatically removed from the servers it is installed on. We recommend that you migrate to Sophos Anti-Virus for Servers.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.
  • We’re working on enhancing the Monitoring feature in Plesk, and we could really use your expertise! If you’re open to sharing your experiences with server and website monitoring or providing feedback, we’d love to have a one-hour online meeting with you.

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