Unable to delete domain or subdomain: Internal error: cObject::update() failed: Some fields are empty or contain an improper value. ('opt' = '')

Created:

2016-11-16 13:05:46 UTC

Modified:

2017-04-24 11:57:55 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to delete domain or subdomain: Internal error: cObject::update() failed: Some fields are empty or contain an improper value. ('opt' = '')

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

The following error appears while trying to delete domain or subdomain:

Internal error: cObject::update() failed: Some fields are empty or contain an improper value. ('opt' = '')
Message cObject::update() failed: Some fields are empty or contain an improper value. ('opt' = '')
File Domain.php
Line 369
Type Smb_Exception

Cause

The issue is caused by database inconsistency. The opt value is missing in psa.dns_recs table for affected domains (i.e. domain.tld):

mysql> select recs.displayVal, recs.type, recs.opt from dns_recs recs join dns_zone zone on zone.id=recs.dns_zone_id where recs.type='PTR' and recs.dns_zone_id in (select id from dns_zone where name='domain.tld');
+-------------+------+-----+
| displayVal | type | opt |
+-------------+------+-----+
| domain.tld. | PTR | |
+-------------+------+-----+
1 row in set (0.00 sec)

Resolution

How to access Parallels Plesk Panel database /en/213928465

  1. Create a backup of the Plesk Panel database by the following command:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > /root/psa_`date +%F`.sql
  2. Update psa.dns_recs table by the following command:

    mysql> update dns_recs set opt='24'  where type='PTR' and dns_zone_id in (select id from dns_zone where name='domain.tld');
Have more questions? Submit a request
Please sign in to leave a comment.