Articles in this section

See more

Error on attempt to create new database or user: Unable to find row with id in DatabaseServers table

Avatar
George Alibegashvili
Updated
Follow
kb: fixed kb: bug ABT: Group A

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.log with 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:

Resolution

Please consider updating your server:

Workaround

If update is not possible for some reason you may try the following

workaround

Until fix will be available use the following workaround:

  1. Login to Plesk via RDP;
  2. Download fixed file;
  3. Backup file %plesk_dir%\admin\plib\Smb\Form\Final\Database\Abstract.php ;
  4. Replace it with the downloaded file.

Comments

2 comments

Sort by Date Votes
  • Avatar
    Murat Bayrak

    Hi I have installed the latest updates. But the problem was not resolved. This error occurs when I want to create a new database.

    Type Db_Table_Exception
    Message Unable to find row with id in DatabaseServers table.
    File Abstract.php
    Line 117
    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    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.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles