Article ID: 112815, created on Sep 13, 2012, last review on May 11, 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

Síntomas

Los síntomas pueden ser los siguientes:

1. El verificador previo a la actualización de Parallels Plesk Panel muestra la siguiente advertencia:

WARNING: Reference between several subscriptions and APS applications has been broken.


2. Cuando se realizan cambios en la configuración de los objetos de Parallels Plesk Panel que implican la recreación del archivo de configuración del servidor web Apache, se obtiene el siguiente error:

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.

Resolución

Para resolver el problema es necesario corregir las referencias dañadas de la base de datos:
1. Cree un volcado de la base de datos psa:

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

2. Examine el error de configuración en la base de datos de 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 |
+-----+----------+--------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
5 rows in set (0.00 sec)

3. Cree una lista de los contextos dañados de las aplicaciones APS. Tenga en cuenta que subscriptionId debería ser igual  MainSubscriptionId  o  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. Modifique el contexto dañado de las aplicaciones APS del paso nº 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. Recree de forma forzada todos los archivos de configuración del servidor 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