List of records in [psa.Subscriptions.object_id WHERE object_type='domain']

[PierluigiM]

Good morning,
running utility I have this:

List of records in [psa.Subscriptions.object_id WHERE object_type='domain'] that miss a matching record in [psa.domains.id WHERE parentDomainId=0 AND htype = 'vrt_hst' AND webspace_id=0]
1, 5, 6, 20, 47, 51, 52, 59, 60, 76, 104, 105, 115

delete from psa.Subscriptions Where object_id=<those id's>

can damage Plesk application?

Thank you
Pierluigi

 

[IgorG]

Try remove one and return record back if something goes wrong.

 

[PierluigiM]

Try remove one and return record back if something goes wrong.

Is there a way to connect to Mysql server with a graphical utility rather than prompt commands?

 

[IgorG]

Is there a way to connect to Mysql server with a graphical utility rather than prompt commands?

I don't know. I always use command line interface.

 

[PierluigiM]

I don't know. I always use command line interface.

Good morning
Deleting the first record in Subscrptions didn't cause damages in appearance.

But then running again the utility after some days the record deleted miss in related tables PlansSubscriptions and SubscriptionPropeties.

Can I delete with problems also there?

What is table Subscriptions related to in Plesk?

Thanks