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

Symptoms

Cannot access domain in Home > Domains > domain.tld which belongs to reseller's customer in Plesk with the 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:

The page isn't redirecting properly

Cause

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

Resolution

Create dump of psa database according to KB-article #213904125

1. Find vendor_id value in domains table for affected domain:

   mysql> select id, name, cl_id, vendor_id from psa.domains where name like '%domain.tld%';
   +----+---------------+-------+-----------+
   | id | name          | cl_id | vendor_id |
   +----+---------------+-------+-----------+
   | 49 | domain.tld    |    34 |         3 |
   +----+---------------+-------+-----------+
   

2. Check that there is no record in clients table for such id:

   mysql> select * from psa.clients where id=3;
   Empty set (0.00 sec)
   

3. Find proper vendor_id value using domains.cl_id by the following query:

   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 |
   +------------------+-------+------------------+----+------------------+
   | domain.tld       |    34 |                3 | 34 |               20 |
   +------------------+-------+------------------+----+------------------+
   

4. Update domains table with correct value of vendor_id for domain.tld :

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