Unable to load object of type BsDomain with id=3: Domain does not exist.

1. Connect to the server via SSH or via RDP

2. Create Plesk database backup

3. Check the links to <id from error> in the psa.domains table:

   # plesk db "SELECT * FROM domains WHERE webspace_id=<id from error>"

   Note: The above query will return a list of domains that belong to a broken webspace, if there are any.

4. Check the domain-related tables and domain aliases:

   Linux:

   # for table in domain_aliases hosting dom_param DomainServices subdomains;do echo TABLE: $table; plesk db "select * from $table where dom_id=<id from error>";done

   Windows:

   C:\> for %T in (domain_aliases,hosting,dom_param,DomainServices,subdomains) do echo %T && plesk db "select * from %T where dom_id=13"

   Note: This query will return domain aliases that belong to the missing dom_id and also entries in related tables that contain information about the domain.

5. If the hosting and DomainServices tables returned a non-empty result on step 3, check whether the actual domain content folder exists (www_root value from hosting table):

   Linux:

   # ls -la /var/www/vhosts/example.com/httpdocs

   Windows:

   C:\> if exist C:\Inetpub\vhosts\example.com\httpdocs echo EXISTS

   • If it does, the domain entry in the database should be recreated. Fetch it from Plesk database dumps using the below command:

     Linux:

     # export dom_id=<dom_id that you got from hosting table>

     # find /var/lib/psa/dumps/ -name mysql.daily.dump.*|sort -n |while read dump_file;do zcat $dump_file|grep '^INSERT INTO `domains'|sed 's/INSERT INTO `domains` VALUES //g'|sed 's/),(/)\n(/g'|grep "($dom_id,";if [ $? == 0 ];then echo;echo Dump file $dump_file contains the entry;exit 0;fi;done
     
     (2,'2013-11-21','domain.com','domain.com',3,0,'vrt_hst',760319296,1,0,NULL,NULL,'53238f70-4818-49a3-8d7e-1a5220e0e06e','','false','on',1,0,0,0,0)
     Dump file /var/lib/psa/dumps/mysql.daily.dump.8.gz contains the entry

     The above command will return the domain entry from Plesk database dumps if it exists there. Re-insert the entry into the domains table:

     # plesk db "INSERT INTO domains VALUES (2,'2013-11-21','domain.com','domain.com',3,0,'vrt_hst',760319296,1,0,NULL,NULL,'53238f70-4818-49a3-8d7e-1a5220e0e06e','','false','on',1,0,0,0,0);"

   • If the domain entry is missing in the dumps and the content folder does not exist, set the dom_id to 0 for all the domains that have webspace_id pointing to the missing domain. Also, remove entries from the following tables:

     # plesk db "DELETE FROM hosting WHERE dom_id = <id from error>"
     # plesk db "DELETE FROM dom_param WHERE dom_id = <id from error>"
     # plesk db "DELETE FROM DomainServices WHERE dom_id = <id from error>"
     # plesk db "DELETE FROM domain_aliases WHERE dom_id = <id from error>"
     # plesk db "DELETE FROM subdomains WHERE dom_id = <id from error>"
     # plesk db "DELETE FROM Subscriptions WHERE object_type = 'domain' AND object_id = <id from error>"

Note: If the content folder is in place but the domain entry is missing in dumps, create a support request in order to resolve the issue