Cannot delete domain name Table:: select() failed - Need advice

[luket12]

Hi guys,

basically i was using a webhosting service that was given to me which seems to use plesk as the management system,
I believe the package is Webfusion VPS.

Here are the specs:
OS - Linux 2.6.18-028stab093.2
Panel version - 10.2.0
Ubuntu 10.04

Through the admin panel I made myself a customer account with its own subscription and domain, and installed a drupal 7 installation. I had a few errors such as not being able to use webmail, and also the Imagecache was not working, a function that shrinks the file size into a thumbnail dynamically, the directories were being created but the files were not being created, on my localhost version it was working fine.

Anyway for this reason I decided I was going to try a differnt web hosting so I went to uninstall the drupal application and delete the customer account / domain from plesk.

Now im getting this:

Error: Some of the selected customers were not deleted.
Error: Unable to remove customer: Table::select() failed: no such row in the table

And it cannot delete. I read a little something about having to use SSH to remove it, but I don't want to break something without knowing exactly what to do.

 

[IgorG]

It is database inconsistency. Issue can be fixed with correction of some records in psa database. I suggest you contact Support Team if you are not familiar with SQL.

 

[luket12]

It is database inconsistency. Issue can be fixed with correction of some records in psa database. I suggest you contact Support Team if you are not familiar with SQL.

I know the syntax and have done some basic SQL, what is it I have to do can you point me in the right direction?
About the support, I read that you need a key or something for support, the thing is I didn't buy anything directly from plesk, this was just what came with my Webfusion VPS hosting..



Thanks.

 

[IgorG]

Most probably that there is missing record for domain's dns zone in dns_zone table. Check dependences for this record for specified domain in tables domains and dns_zone. Insert missing record if necessary.

 

[luket12]

Im not sure what to do, I have left it for a while but i need to fix this problem.
My domain has just bugged there, it cant be removed.

I did try to SSH but i needed some kind of master pass to get in, so i couldnt even run a few commands to check anything. How am i supposed to find out the master SSH password, i tried my details from the hosting provider and they didn't work.

 

[Faris Raouf]

Contact Webfusion support to ask how you login via ssh. Plesk doen't touch anything to do with that side of things, with the possible exception of the Plesk firewall blocking port 22 (used for ssh) if you configure it to do so.

Once logged in, if you aren't logging in as root to start with (and you shouldn't allow this anyway for reasons of security), you may need to switch to the root user. You may need to enter a different password again for this. It all really depends on the way the server is set up and again Plesk has nothing to do with this - you'll need to contact Webfusion about that too if need be.

Just remember that the mysql "root" user is "admin" and the password will be the encrypted version of your Plesk password (not the unencrypted version you use to login as admin to Plesk itself).

So that you don't have to worry about it, you'd normally use this command to connect to mysql as admin:

mysql -uadmin -p`cat /etc/psa/.psa.shadow`

Note those things that look like "quotes" are not actually quotes at all but are "backticks". (see http://kb.parallels.com/en/427). On a UK keyboard the backtick is to the left of the number 1, but on other keyboards it could be somewhere else so just copy and past into the command line