Cannot delete domain through PLESK - SQL Editing?

[ClickJC]

Hello everyone,

I am currently stuck in a position where my PLESK control panel is showing a domain that used to be on the server and now is unable to be deleted from the "Domains" page. This list currently has the "Red X" located on the left side of the domain and is reading that "Domain is temporarily suspended for backing up or restoring." The problem is that the domain is no longer on the box.

I figured at this stage of the game that I am needing to go through the SQL modification of the database that writes this list. Could anyone please point me in a direction to correct this?

Thanks and happy thanksgiving!

Jeff

 

[IgorG]

Did you try to remove domain with CLI utility

# /usr/local/psa/bin/domain -r domain.com

?

 

[ClickJC]

Yes, this is the same output error I received within PLESK, but here is the feedback from ssh:


[root@server /]# /usr/local/psa/bin/domain -r antiquewoodenboatsigns.com
ERROR: PleskFatalException
Domain antiquewoodenboatsigns.com is temporarily turned off for backup/restoring and is not currently available.

0: class.PhDomain.php:392
PhDomain->reset(integer '0', boolean true, boolean false)
1: class.BsDomain.php:330
BsDomain->reset(integer '0')
2: class.BsDomain.php:302
BsDomain->delete()
3: cuDomain.php:1751
cuDomain->cmdRemove(string 'antiquewoodenboatsigns.com')
4: cuDomain.php:718
cuDomain->cuDomain()
5: domain.php:17
PHP Warning: Releasing semaphore 20 in request cleanup in Unknown on line 0

 

[IgorG]

Try to update status of this domain with

update domains set status=0 where name='antiquewoodenboatsigns.com';

And then remove it with

# /usr/local/psa/bin/domain -r antiquewoodenboatsigns.com

 

[ClickJC]

The command:

update domains set status=0 where name='antiquewoodenboatsigns.com';

Would be through SQL?

 

[IgorG]

Yes, in psa database.
http://kb.odin.com/en/170

 

[ClickJC]

Beautiful, everything worked out great. Thank you IgorG. You're help has been much appreciated!

Happy Holiday to you.

Jeff