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

 

[bigbear67]

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

 

[Martin Dias]

@bigbear67 that looks like your database server got corrupted, you can try this to fix it:

Plesk is not accessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory

Applicable to: Plesk for Linux Symptoms The following error is shown in Plesk: PLESK_INFO: ERROR: PleskMainDBExceptionMySQL query failed: Incorrect information in file: './psa/misc.frm' PLESK...

support.plesk.com