Unable to customize the subscription: Unable to retrieve PHP settings because the required data is absent.

Created:

2016-11-16 13:15:38 UTC

Modified:

2017-08-08 13:38:02 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to customize the subscription: Unable to retrieve PHP settings because the required data is absent.

Applicable to:

  • Plesk 12.5 for Linux

Symptoms

Unable to customize the subscription. Plesk is getting redirected to Home page and the following error is shown:

Unable to retrieve PHP settings because the required data is absent.

Cause

Database inconsistency. Php settings reference is missing in the database.

Resolution

  1. Find the PHP Settings ID in database for required domain:

    mysql> select SubscriptionProperties.value from SubscriptionProperties inner join Subscriptions on SubscriptionProperties.subscription_id=Subscriptions.id inner join domains on domains.id=Subscriptions.object_id where Subscriptions.object_type='domain' and SubscriptionProperties.name='phpSettingsId' and domains.name='example.com';

    +-------+
    | value |
    +-------+
    | 36 |
    +-------+

    where example.com - required domain.

  2. Check that the record is missing:

    mysql> SELECT * FROM `PhpSettings` where id=36;
    Empty set (0.00 sec)
  3. Insert missing value:

    mysql> insert into PhpSettings values (36,0);
Have more questions? Submit a request
Please sign in to leave a comment.