Creation of new subscription fails with message:
Error: External exception. SQLSTATE: Integrity constraint violation: 1062 Duplicate entry '4842-domain' for key 'object_id_and_type'
Create database dump using article #881.
Login to Plesk database using article #170.
From error message find domain id (in this example it is 4842).
Make sure that there is no such domain in Plesk database:
mysql> select * from domains where id=4842; Empty set (0.00 sec)
Remove entry from
mysql> delete from Subscriptions where object_id=4842; Query OK, 1 row affected (0.03 sec)
- Create new subscription.
In case there is more than one incorrect entries in database:
mysql> select count(*) from Subscriptions where object_id NOT IN (select id from domains); +----------+ | count(*) | +----------+ | 196 | +----------+ 1 row in set (0.00 sec)
Remove all such entries using the following query:
mysql> delete from Subscriptions where object_id NOT IN (select id from domains); Query OK, 196 row affected (0.03 sec)