Plesk Domain Not Deleted in database
Posted by PremiumReseller on 05 May 2017 04:29 AM

"Internal error: Unable to load object of type Client with id=xxx: Client: unable to select: no such row in the table"

When domain is deleted on server but still has record in Plesk database.

Error when adding domain and cannot delete domain in Plesk.

C:\Users\Administrator>cd %plesk_dir%\Mysql\bin

C:\Program Files (x86)\Parallels\Plesk\MySQL\bin> mysql -uadmin -p -P 8306 psa
Enter password: *********

Search domain in Plesk database to find domain id

select * from domains where name = 'your-domain'

Result should show client id in error message. Verify domain id from previous query

select * FROM domains WHERE id = xxx;

select * FROM clients where id= client_id_above;

mysql> SELECT * FROM hosting WHERE dom_id = <id_above>;
mysql> SELECT * FROM dom_param WHERE dom_id = <id_above>;
mysql> SELECT * FROM domainServices WHERE dom_id = <id_above>;
mysql> SELECT * FROM domain_aliases WHERE dom_id = <id_above>;
mysql> SELECT * FROM subdomains WHERE dom_id = <id_above>;

Then delete all records to error domain.

Delete FROM domains WHERE id = xxx;

(0 vote(s))
This article was helpful
This article was not helpful