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

Created:

2016-11-16 13:12:00 UTC

Modified:

2017-04-24 11:54:51 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk 12.0 for Linux

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;
Have more questions? Submit a request
Please sign in to leave a comment.