Search Engine: Elastic

Article ID: 118070, created on Oct 20, 2013, last review on Dec 16, 2015

  • Applies to:
  • Plesk Automation 11.1


I cannot remove a subscription; the operation fails with the error below:

Unsubscribe Cannot unsubscribe 1 subscriptions. Reason: domain does not exist 

There is no corresponding website under the Services > Websites tab.


The issue is caused by a database inconsistency. Most likely, some tasks were canceled.


It is necessary to create a missing record in the domains table of the psa database:

  1. Find external_id. The record in the domains table should have the same external_id as the subscription ID in PPA; you can find it using the query below:

    # psql -Uplesk -h`hostname` plesk -c "select sub_id from subscriptions where name=''"
    (1 row)
  2. Create a corresponding record in the domains table, using the external_id variable from step 1.

    mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa -e "INSERT INTO `domains` (`cr_date`, `name`, `displayName`, `dns_zone_id`, `status`, `htype`, `real_size`, `cl_id`, `cert_rep_id`, `limits_id`, `params_id`, `guid`, `external_id`, `overuse`, `gl_filter`, `vendor_id`, `webspace_id`, `webspace_status`, `parentDomainId`, `permissions_id`) VALUES ('2012-12-12','','',0,0,'none',0,0,0,0,NULL,'cfabf45a-af76-4c17-9d7a-e555b4a99999','14','false','on',1,0,0,0,0);"
  3. Go to Operations > Subscriptions and try to delete the subscription again.

e0aff7830fa22f92062ee4db78133079 caea8340e2d186a540518d08602aa065 c1ecc6010feff26cb42d1d14a7881dd6

Email subscription for changes to this article
Save as PDF