Plesk Domain Not Deleted in database
Posted by Premium Reseller 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.
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>;
Then delete all records to error domain.
Delete FROM domains WHERE id = xxx;