Unable to customize the subscription: Call to a member function getPerformanceSettings() on a non-object

Symptoms

When trying to customize a subscription the following error appears:

ERROR: Call to a member function getPerformanceSettings() on a non-object (PhpSettings.php:56)

Cause

Database inconsistency

Resolution

1. Make a backup of psa database:

   • Linux:

     # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > /root/psa_current.sql
     

   • Windows:

     "%plesk_dir%"\\Mysql\\bin\\mysqldump.exe -uadmin -p<plesk_admin_password> -P8306 psa > c:\\psa_current.sql
     

2. Find out the subscription_id using the name of the issued subscription:

   mysql> select id from Subscriptions where object_id in (select id from domains where name='example.com');
   +----+
   | id |
   +----+
   | 55 |
   +----+
   

3. Find out the phpSettingsId of the subscription:

   mysql> select * from SubscriptionProperties where subscription_id=55;
   +-----------------+----------------------+-------+
   | subscription_id | name                 | value |
   +-----------------+----------------------+-------+
   |              55 | aps_bundle_filter_id | 13    |
   |              55 | phpSettingsId        | 1     |
   +-----------------+----------------------+-------+
   

4. Check that the corresponding entry is absent from PhpSettings table:

   mysql> select * from PhpSettings where id=1;
   Empty set (0.01 sec)
   

5. Create the missing record:

   mysql> insert into PhpSettings values (1,0);