- Plesk Onyx 17.5 for Linux
When running the command "plesk bin subscription --list" to list all subscriptions, the output is interrupted with the following error message:
# plesk bin subscription --list
Unable to load object of type BsDomain with id=101: Domain does not exist.
exit status 1
The Plesk database contains orphaned records.
# plesk db dump psa > /root/psa_backup.sql
Connect to the Plesk database:
# plesk db
Find the domain name by its "id" from the error message:
MYSQL_LIN: mysql> select * from domains where id=101;
Check if the domain directory exists:
# ls -la /var/www/vhosts/example.com/httpdocs
Note: If the directory exists, then try to repair Plesk database with the command "plesk repair db". For more information about this utility, see this documentation page.
If the domain does not exist physically, remove orphaned records from the Plesk database:
MYSQL_LIN: mysql> delete from Subscriptions where object_id=101;
Query OK, 1 row affected (0.01 sec)
mysql> delete from SubscriptionProperties where subscription_id=101;
Query OK, 12 rows affected (0.01 sec)
mysql> delete from PlansSubscriptions where subscription_id=101;
Query OK, 2 rows affected (0.00 sec)