Plesk repair utility for mysqlPlesk repair utility for mysql

Symptoms

  1. No backup operations are running.
  2. Cannot activate domain in Plesk: Error: The domain or website example.com cannot be activated because it was disabled by your hosting provider. OR Error: The domain or website example.com cannot be activated because it was suspended by your hosting provider.
  3. It may not be possible to activate it via CLI as well:
  4. plesk bin domain –on example.com

    An error occurred during turning domain on/off: The domain is suspended because the subscription is still suspended.

Cause

Unclear.

Resolution

  1. Connect to a Plesk server via SSH/RDP
  2. Activate domain via CLI, if you did not try it yet:
  3. plesk bin domain –on example.com

If the solution above did not help:

activate domain in Plesk database

  1. Connect to a Plesk server via SSH/RDP
  2. Back up Plesk database
  3. Connect to Plesk database
  4. Set domain status to active: mysql> update domains set status = 0 where name=’example.com‘;
  5. Set webspace status to active: mysql> update domains set webspace_status=0 where name=’example.com‘;
  6. To activate domain aliases, find suspended ones and activate them using the value of dom_id: mysql> select dom_id,displayName from domain_aliases where status!=0;
    +——–+————-+
    | dom_id | displayName |
    +——–+————-+
    | 40     | example.net |
    +——–+————-+

    mysql> update domain_aliases set status=0 where status=2 and dom_id=40;
  7. Log in to Plesk
  8. Go to Domains > example.com. Suspend and activate the domain to ensure the issue got fixed.

If still not fixed then suspend subscription and re-activate it again.