Cannot delete reseller account or service plan in Plesk panel
Posted by Premium Reseller on 20 October 2016 10:04 PM

A service plan in Plesk shows subscriptions using it but there is actually no subscription.

The problem is caused by Plesk data inconsistency. Some database procedure goes wrong when subscription is deleted.

To verify error, run below queries on plesk database.

cd %plesk_dir%\Mysql\bin

mysql -uadmin -p -P 8306 psa

mysql> select * from PlansSubscriptions where plan_id=problem_id;

Then search domain of subscription

mysql> select * from Subscriptions where id=subscription_id;

if object_type is domain:

mysql> select * from domains where id=object_id;

It should return empty set which means domain is already deleted but record in database is not updated.

You can delete related records in Subscriptions and PlansSubscriptions table.


(2 vote(s))
This article was helpful
This article was not helpful