Cannot access domain in Plesk: Client: unable to select: no such row in the table – Plesk Help Center

Plesk for Linux kb: technical

Applicable to:

Cannot access domain in Domains > example.com which belongs to reseller's customer in Plesk with the error:

PLESK_ERROR: Client: unable to select: no such row in the table
Unable to login to domain control panel using Manage in Customer Panel link. Browser shows error:

CONFIG_TEXT: The page isn't redirecting properly

Database inconsistency caused by incorrect vendor_id value for the domain in psa.domains table.

Connect to the server via SSH;
Create a dump of psa database according to KB-article #213904125;
Find vendor_id value in domains table for affected domain:

MYSQL_LIN: mysql> select id, name, cl_id, vendor_id from psa.domains where name like '%example.com%';
+----+---------------+-------+-----------+
| id | name | cl_id | vendor_id |
+----+---------------+-------+-----------+
| 49 | example.com | 34 | 3 |
+----+---------------+-------+-----------+
Check that there is no record in clients table for such id:

CONFIG_TEXT: mysql> select * from psa.clients where id=3;Empty set (0.00 sec)
Find proper vendor_id value using domains.cl_id by the following query:

MYSQL_LIN: mysql> select d.name, d.cl_id, d.vendor_id as 'domain_vendor_id', c.id, c.vendor_id as 'client_vendor_id' from psa.domains d join psa.clients c where d.cl_id=c.id and d.vendor_id=3;
+------------------+-------+--------------------+----+------------------+
| name | cl_id | domain_vendor_id | id | client_vendor_id |
+------------------+-------+--------------------+----+------------------+
| example.com | 34 | 3 | 34 | 20 |
+------------------+-------+--------------------+----+------------------+
Update domains table with a correct value of vendor_id for example.com:

MYSQL_LIN: mysql> update psa.domains set vendor_id=20 where id=49;

2 comments

Please sign in to leave a comment.

Have more questions? Submit a request