subscriptions were not removed Unable to remove domain Parallels Plesk

subscriptions were not removed Unable to remove domain Parallels Plesk

Error: Some of the selected subscriptions were not removed.
Unable to remove domain: cObject::update() failed: Some fields are empty or contain an improper value. (‘opt’ = ”)

The issue is caused by database inconsistency.

The opt value is missing in psa.dns_recs table for affected domains eg. domain.extn

parallels-plesk-fields-empty-contain-improper-value

This can be resolved by adding required records on the psa.dns_recs table.
First you need to login to the mysql of the plesk.

On Linux

On Plesk 11.0 and older:

From Plesk 11.5 You can use the single command to login to the plesk db.

On Windows

Execute the following commands in the command prompt:

Once logged in, Just take full backup of the plesk mysql.

Update psa.dns_recs table by the following command:

Make sure, you change the domain.extn to the problem domain name.

Now, go back to the plesk control panel and try deleting the hosting account.

That is all, do visit again for more guides & to do.

About ilangovan ramasamy

I am a IT manager on a Corporate co. Started My Career In a Internet Center. having 10 years on Experience on IT. Very much Interested in knowing New technologies & gadgets. Wrote many Articles & how to’s for Computer Related issues. As I am in to hosting industry We face many issues on work. I thought of sharing my knowledge with you and writing so. If you guys feel something is interesting & helpful, Please do comment on it.

View all posts by ilangovan ramasamy →

Comments

This site uses Akismet to reduce spam. Learn how your comment data is processed.