Article ID: 112815, created on Oct 2, 2012, last review on May 6, 2014

  • Applies to:
  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 10.4 for Linux/Unix
  • Plesk 10.3 for Linux/Unix

Symptômes

Les symptômes varient.

  1. L'outil de vérification préalable à la mise à niveau de Parallels Plesk Panel affiche l'avertissement suivant :

    WARNING: Reference between several subscriptions and APS applications has been broken.
    
  2. L'erreur suivante s'affiche lorsque la configuration des objets de Parallels Plesk Panel est modifiée en supposant que le fichier du serveur Web Apache est recréé :

    Error: New files of configuration for Apache web server were not built due to errors in configuration templates. The detailed error message was e-mailed to you, so please check the e-mail, fix the errors, and click here to retry generating configuration.
    

Résolution

La solution consiste à réparer les références de bases de données qui sont corrompues (toutes les commandes sql sont données pour les bases de données PSA) :

  1. Créez un dump de la base de données PSA :

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa > /var/lib/psa/dumps/psadump.kb112815.`date "+%Y-%m-%d_%H:%M"`.sql
    

    Puis, connectez-vous à la base de données PSA avec la commande suivante :

    # mysql -uadmin -p`cat /etc/psa/.psa.shadow` psa
    
  2. Listez les erreurs de configuration dans la base de données Parallels Plesk Panel :

        mysql> select id,objectId,status,description from Configurations where status="error";
    +-----+----------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    | id  | objectId | status | description                                                                                                                                                                 |
    +-----+----------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    |   5 |        1 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
    | 195 |       96 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
    | 205 |      101 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
    | 835 |      434 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
    | 837 |      435 | error  | Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
    +-----+----------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
    
  3. Listez les contextes corrompus pour les applications APS (subscriptionId doit être identique à MainSubscriptionId ou AdditionalSubscriptionId) :

    mysql> select aps.id, pleskId, subscriptionId, s.id as MainSubscriptionId, su.id as AddSubscriptionId from apsContexts aps left join domains d on d.id=aps.pleskId left join domains w on w.id = d.webspace_id left join Subscriptions s on s.object_id=d.id left join Subscriptions su on su.object_id = w.id where (subscriptionId!=s.id and su.id is null) or (subscriptionId!=su.id and s.id is null) or aps.subscriptionId is null;
    
    +----+---------+----------------+--------------------+-------------------+
    | id | pleskId | subscriptionId | MainSubscriptionId | AddSubscriptionId |
    +----+---------+----------------+--------------------+-------------------+
    |  2 |       1 |              0 |                  1 |              NULL |
    |  3 |      96 |             96 |                 75 |              NULL |
    |  4 |     101 |            101 |                 79 |              NULL |
    |  5 |     434 |              0 |               NULL |                75 |
    |  6 |     435 |           NULL |               NULL |                75 |
    +----+---------+----------------+--------------------+-------------------+
    5 rows in set (0.00 sec)
    
  4. Modifiez le contexte corrompu des applications APS détecté à l'étape 3 :

    mysql> update apsContexts set subscriptionId=1 where pleskId=1;
    Query OK, 1 row affected (0.01 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    mysql> update apsContexts set subscriptionId=75 where pleskId=96;
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    mysql> update apsContexts set subscriptionId=79 where pleskId=101;
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    mysql> update apsContexts set subscriptionId=75 where pleskId=434;
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
    mysql> update apsContexts set subscriptionId=75 where pleskId=435;
    Query OK, 1 row affected (0.00 sec)
    Rows matched: 1  Changed: 1  Warnings: 0
    
  5. Forcez la re-création des fichiers de configuration du serveur Web Apache :

    # /usr/local/psa/admin/sbin/httpdmng --reconfigure-all
    

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c aea4cd7bfd353ad7a1341a257ad4724a 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f 01bc4c8cf5b7f01f815a7ada004154a2 742559b1631652fadd74764ae8be475e e335d9adf7edffca6a8af8039031a4c7 2a5151f57629129e26ff206d171fbb5f e8756e9388aeca36710ac39e739b2b37 dd0611b6086474193d9bf78e2b293040 f4ce8084cb23619ef5fe9428ecc388ea

Email subscription for changes to this article
Save as PDF