Knowledge Base

Unable to access Plesk or perform a WordPress scan: Call to a member function getDomainName() on boolean

Symptoms

WordPress Toolkit scan is failing with the empty ID in the error message:

PLESK_ERROR: ERR [panel] Task failed: id=5635, pid=19031, type=ext-wp-toolkit-taskmanage, error=No integration information available for registry application ID ”

Unable to access Plesk, the following error appears after logging in:

ERR [1] ERROR: Call to a member function getDomainName() on boolean (ApsInstance.php:221)

Unable to retrieve license key via Tools & Settings > License Management with the following error:

Updating Plesk license key: PHP Fatal error: Call to a member function getDomainName() on boolean in /usr/local/psa/admin/plib/Smb/Db/Table/Row/ApsInstance.php on line 221
exit status 255

Unable to retrieve server information with the following command:

# plesk bin server_pref –get-server-info
PHP Fatal error: Call to a member function getDomainName() on boolean in /usr/local/psa/admin/plib/Smb/Db/Table/Row/ApsInstance.php on line 221
exit status 255
Unable to access databases list via Domains > example.com > Databases:
```
Call to a member function getDomain() on boolean (Databases.php:111)
```

Cause

Database inconsistency, there are records in apsc database that contradicts with foreign constraint check.

Resolution

Automatic repair

Log in to the server via SSH.
Create a backup of psa and apsc databases:

# plesk db dump > psa_current.sql

# plesk db dump apsc > apsc_current.sql
Fix errors in database using Plesk self-repair tool by executing the following command:

# plesk repair db

Manual repair

Log in to the server via SSH.
Create a backup of apsc database:

# plesk db dump apsc > apsc_current.sql
Enter apsc database with the following command:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql apsc -uadmin
Determine ID of the extra record:

MYSQL_LIN: > SELECT id FROM aps_application WHERE registry_object_id NOT IN (SELECT id FROM apsc.aps_registry_object);
+—–+
| id |
+—–+
| 206 |
+—–+
1 row in set
Try to remove this record, following the adviсe of the error messages:

MYSQL_LIN: > DELETE FROM aps_application WHERE id=206;
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`apsc`.`aps_resource`, CONSTRAINT `FK_aps_resource_aps_application` FOREIGN KEY (`app_id`) REFERENCES `aps_application` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)

> SELECT id,registry_object_id,app_id FROM aps_resource WHERE app_id=206;
+—–+————…