Need to delete a server, can't remove accounts.

[Mark Caetano]

Hi,

 

I need to remove an old server from my list but WHMCS thinks there's accounts on there when they've all been moved to a new server.

 

It tells me:

An Error Occured

You cannot delete a server while hosting accounts are still assigned to it

 

The old server is switched off and gone.

 

Thanks in advance.

[scurrell]

Have you checked cancelled/terminated accounts to see if they're still assigned to the old server?

[Elik]

Hello,

 

I have this similiar issue, but it is due to how the billing people have messed up the WHMCS with the migiration of old accounts to the new server, with new servername, and closing the old server. So, I have old and new servers listed, but I have lot of accounts that is still pointed to the old server, which it need to be updated to be on the new server id.

 

I am trying to read the mysql db to see where that is encoded so I can do mass change in the DB to have all references to the old server changed to the new server, so that I can get the old server listing removed from WHMCS itself.

 

Any assistance on this is appreciated.

[Fucking Man]

Hello
Anyone solved?

[RadWebHosting]

If your attempt at deleting a server is hindered by the existence of cancelled/inactive services, you can use a SQL query to handle, like:

UPDATE tblhosting SET server='newserverid' WHERE server='serveridtodelete';

Where newserverid is the server ID of the server that you want to assign the services to and serveridtodelete is the server ID of the server you want all services removed from.

For example, you can use:

UPDATE tblhosting SET server='2' WHERE server='1';

to set all services assigned to server ID '1' to now be assigned to server ID '2'. Then you should be able to delete server ID '1' from WHMCS without error.

Edited August 19, 2023 by radwebhosting
formatting