How to delete unity mobile sites via CLI - Preventing subscription transfer

[Chris1]

Hello,

I am trying to migrate a couple of sites from one owner to another but I am getting the following error:

Unable to continue subscription transfer: this subscription requires more resources than can be provided by the new owner's provider.

It seems that the error output in the GUI doesn't provide all the information. When I attempt a change of ownership via CLI I get this line which I am guessing is causing the problem.

Resource name            Allocated Used  Will be used
max_unity_mobile_sites 0            2       2

These domains were migrated from Plesk 10 to Plesk 12. The unity mobile sites I believe were available on our previous server but not on our new Plesk 12 server.

How can I remove these "used" unity mobile sites via the database or CLI?

 

[Chris1]

Can anyone help with this?

I can't perform a simple task of moving a subscription to another customer.

 

[Chris1]

Could someone please help with this query?

I tried migrating the domain to a Plesk 12.5 server and then could re-assign the domain to a different customer without a problem. But I cannot re-assign the domain to a different customer on the Plesk 12.0 server.

 

[Claudio Cosenza]

Hello,

i've digged around a lot, but there's a workaround: at this KB: https://kb.plesk.com/en/128801

{in short}
(make a backup) mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > psa_backup.sql
(connect to plesk db) plesk db
(search for site that use unity) select * from dom_param where param like "%unity%";
(delete this records) DELETE FROM dom_param WHERE PARAM LIKE "%unity%";

Now i can move subscriptions.