Applicable to:
- Plesk Obsidian
Symptoms
-
The following error appeared on the attempt to add a new database or create a new database user in Domains > example.com > Databases:
PLESK_ERROR: Type Db_Table_Exception
Message Unable to find row with id in DatabaseServers table.
File Abstract.php
Line 117 -
The following error can be found in
/var/log/plesk/panel.logwith debug enabled:CONFIG_TEXT: DEBUG [dbquery] [81] SQL: SELECT `DatabaseServers`.* FROM `DatabaseServers` WHERE (((`DatabaseServers`.`id` = 0)))
ERR [panel] Db_Table_Exception: Unable to find row with id in DatabaseServers table.
file: C:\Program Files (x86)\Plesk\admin\plib\Db\Table\Abstract.php
line: 117
code: 0
trace: #0 C:\Program Files (x86)\Plesk\admin\plib\Smb\Form\Final\Database\Abstract.php(69): Db_Table_Abstract->getOne(NULL null)
Cause
Product issue:
- #PPP-45315 "Creating a database or database user via Plesk UI under a subscription based on a service plan with Default Database Server set to “None” no longer results in the “Db_Table_Exception” error."
Fixed in:- Plesk Obsidian 19 November 2019
Resolution
Workaround
If update is not possible for some reason you may try the following
Until fix will be available use the following workaround:
- Login to Plesk via RDP;
- Download fixed file;
- Backup file
%plesk_dir%\admin\plib\Smb\Form\Final\Database\Abstract.php ; - Replace it with the downloaded file.
Comments
2 comments
Hi I have installed the latest updates. But the problem was not resolved. This error occurs when I want to create a new database.
Hello @Murat,
The fix will be included in version 18.0.21, which is expected in November.
Thank you fo notice, the article will be reviewed.
Please sign in to leave a comment.