Symptoms
-
WP 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
andapsc
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;
+—–+————…