Unable to delete a reseller Error: Plan is used

Created:

2016-11-16 13:19:59 UTC

Modified:

2017-08-16 17:24:05 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to delete a reseller Error: Plan is used

Applicable to:

  • Plesk 11.x for Windows
  • Plesk 12.0 for Windows
  • Plesk 12.5 for Windows

Symptoms

Getting the following error when attempt to delete reseller or resellers from Plesk:

Error: Plan is used

or

Error: Some of the selected resellers were not removed.

Cause

Database inconsistency.

Resolution

Delete the orphaned records from the database by following the steps bellow:

  1. Backup psa database by using KB article # 213904125 .

  2. Login to Pelsk database # 213928465 .

  3. Find the particular reseller id:

    # plesk db
    mysql> select id from clients where login like '%reseller_login%';
    +----+
    | id |
    +----+
    | 3 |
    +----+
  4. Find service plans belonging to this reseller:

    mysql> select id from Templates where owner_id=3;
    +----+
    | id |
    +----+
    | 7 |
    | 8 |
    |144 |
    +----+
  5. From the service plan id, find the subscription_id :

    mysql> select * from PlansSubscriptions where plan_id in (7,8,144);
    +-----------------+---------+----------+
    | subscription_id | plan_id | quantity |
    +-----------------+---------+----------+
    | 655 | 144 | 1 |
    +-----------------+---------+----------+
  6. Delete the orphan subscription_id from subscriptions table:

    mysql> select * from subscriptions where id='655';
    +-----+-----------+-------------+--------+--------------+--------+--------------------------------------+
    | id | object_id | object_type | locked | synchronized | custom | uuid |
    +-----+-----------+-------------+--------+--------------+--------+--------------------------------------+
    | 655 | 1222 | domain | false | false | false | 82f8ecae-0ddd-712b-20cc-4f077d6fb583 |
    +-----+-----------+-------------+--------+--------------+--------+--------------------------------------+

    mysql> delete from subscriptions where id='655';
Have more questions? Submit a request
Please sign in to leave a comment.