Unable to activate suspended subscription in Plesk? This is easily resolved with a handy trick by the experts at Bobcares.

At Bobcares, we offer solutions for every query, big and small, as a part of our Server Management Service.

Let’s take a look at how our Support Team recently helped a customer with activating suspended subscriptions in Plesk.

Are you Unable to activate the suspended subscription in Plesk?

The “Unable to activate suspended subscription” error in Plesk displays several symptoms like:

• We cannot activate suspended customers or subscriptions.
• The subscription owner or customer is still active.
• The customer owner or reseller is still active.
• We cannot export database dump.
• The domain status is 0 while the subscription status is 2.
• MySQL server hands during subscription activation.

According to our experienced Support Techs, this error is due to inconsistency in the Plesk database.

How to activate suspended subscriptions in Plesk

1. First, we have to connect to the Plesk server via SSH or RDP.
2. Then, we will create a dump of the Plesk database with the following commands:

   For Linux:

   # plesk db dump psa > /root/psa_backup.sql

   For Windows server:

   C:\> plesk db dump psa > C:\psa_backup.sql
3. After that we have to access the Plesk database as seen below:

   # plesk db
4. Next, we have to activate the subscription or customer:
   • Activating the subscription:

     mysql> UPDATE domains SET status=0, webspace_status=0 WHERE name='example.com';
   • Activating the customer:

     mysql> UPDATE clients SET status=0 WHERE pname='Customer name';

Once we are done with the steps above, we have to log in to Plesk. Then, we can suspend the subscription or customer in the previous step and activate it again. In the picture below, we can see how we have to select the customer or subscription prior to suspending or activating.

[Need a solution to another query? We are just a click away.]

Conclusion

In brief, the skilled Support Engineers at Bobcares demonstrated how to activate the suspended subscriptions in Plesk.