error removing domain

[kami@]

Hi everybody,
I am having a tough time removing 2 domains on my server.
I am runing plesk 8.2 and when I attempt to remove these 2 domains I get the
following error in Plesk:

Unable to remove domains: Problems occured while removing domains: Table::select() failed: no such row in the table

Could somebody please help me out here as I need to recreate them again>

Thanks in advance

 

[kami@]

Looks like during delete process the domains have been removed from IIS as they do not exist in IIS, but were not deleted from plesk database.

Any help will be greatly appreciated.

 

[DmitryT]

kami,

It looks like DNS zone is absent for this domain in Plesk database. Please try to restore it with the following queries:

1. insert zone record in psa.dns_zone table:
mysql> INSERT INTO dns_zone SET name='DOMAIN-NAME', displayName='DOMAIN-NAME', email='ADMIN-EMAIL';

2. know new zone ID:
mysql> SELECT id, name FROM dns_zone ORDER BY id DESC LIMIT 1;

3. substitute correct ID into psa.domains table, don't forget to replace DOMAN-NAME and DNS-ZONE-ID with correct values:
mysql> UPDATE domains SET dns_zone_id='DNS-ZONE-ID' WHERE name='DOMAIN-NAME';


Hope this will help.