Applicable to:
- Plesk for Linux
Symptoms
-
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
Cause
Database inconsistency caused by incorrect vendor_id value for the domain in psa.domains table.
Resolution
-
Connect to the server via SSH;
-
Create a dump of
psadatabase according to KB-article #213904125; -
Find
vendor_idvalue indomainstable 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
clientstable for such id:CONFIG_TEXT: mysql> select * from psa.clients where id=3;Empty set (0.00 sec)
-
Find proper
vendor_idvalue usingdomains.cl_idby 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
domainstable with a correct value ofvendor_idfor example.com:MYSQL_LIN: mysql> update psa.domains set vendor_id=20 where id=49;
Comments
2 comments
This also resolves:
Unable to load object of type Client with id=
@FrAgFo0d can you please clarify the case and how exactly you resolved it? I am asking because I could not reproduce the error you mentioned in lab environment by modifying vendor_id value. I could reproduce it only by changing cl_id value.
Please sign in to leave a comment.