Mysql Subscription problem

[Jayson]

I have been manually updating dns for domains when I get the following error when accessing the DNS settings for one subscription(domain),

ERROR: PleskException
Table::select() failed: no such row in the table

Additionally, an exception has occurred while trying to report this error: PleskException
Table::select() failed: no such row in the table

0: DNSZone.php:72
DNSZone->DNSZone(string '3')
1: common_func.php3:3286
objectMaker(string 'DNSZone', string '3')
2: DNSManager.php:29
DNSManager::getDNSZone(string '3')
3: Domain.php:1374
Domain->getDNSZone()
4: client.domain.dns.php:22
plesk__client__domain__dns->getDNSZone()
5: DNSUIPointer.php:96
DNSUIPointer->getFlavor()
6: UIPointer.php:919
UIPointer->getCaption(string 'done', string '', NULL null, object of type UserAdmin, NULL null, string '')
7: common_func.php3:4343
wizard_get_done_message()
8: plesk.php:29

If I try and remove the entire domain I get,

Table::select() failed: no such row in the table

Checking user accounts I see no domain administrator account for this subscription, I'm not sure if that is what the UserAdmin NULL error above is regarding?


At this point I'm not sure how to proceed. It's a domain that is completely backed up, so deleting and recreating is not a problem, if it were possible.

Thank you

 

[WayneN]

Jayson,

I also have the same problem, very similar to yours.

ERROR: PleskException
Table::select() failed: no such row in the table

Additionally, an exception has occurred while trying to report this error: PleskException
Table::select() failed: no such row in the table

0: DNSZone.php:72
DNSZone->DNSZone(string '5063')
1: common_func.php3:3316
objectMaker(string 'DNSZone', string '5063')
2: DNSManager.php:29
DNSManager::getDNSZone(string '5063')
3: Domain.php:1340
Domain->getDNSZone()
4: client.domain.dns.php:22
plesk__client__domain__dns->getDNSZone()
5: DNSUIPointer.php:102
DNSUIPointer->getFlavor()
6: UIPointer.php:919
UIPointer->getCaption(string 'done', string '', NULL null, object of type UserAdmin, NULL null, string '')
7: common_func.php3:4380
wizard_get_done_message()
8: plesk.php:29

 

[WayneN]

I know this is MYSQL problem. Tried to log in to mysql server console to fix it but nothing changed.

 

[Jayson]

Did you try the steps mentioned in the KB link "http://kb.parallels.com/1360".

 

[WayneN]

Yes, I did. In the 'DNS-ZONE-ID', is this the IP of the website you're running? That's what I entered for my website.