Symptoms
The following error is displayed while making changes to the configuration of Parallels Plesk Panel objects which assume Apache web server configuration file re-creation: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.
Resolution
1. List configuration error in Parallels Plesk Panel database:mysql -uadmin -p`cat
/etc/psa/.psa.shadow ` psa -Nse"select * from Configurations where
status='error' \G"
mysql> select
id,objectId,status,description from Configurations where status="error";
+------+-------------+--------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| id | objectId | status | description |
+------+-------------+--------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| 3539 | 340
| error | Template processing failed: file =
/usr/local/psa/admin/conf/templates/default/domainVhost.php, error =
SQLSTATE[HY093]: Invalid parameter number: no parameters were bound |
+------+-------------+--------+-------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
2. List broken contexts of the APS applications:
mysql> select * from apsContexts where
(pleskType='hosting' OR pleskType='subdomain') AND subscriptionId=0;
+----+-----------+---------+-------+----------------+
| id | pleskType | pleskId | ssl | subscriptionId |
+----+-----------+---------+-------+----------------+
| 7 | hosting | 347 | false | 0 |
+----+-----------+---------+-------+----------------+
1 rows in set (0.00 sec)
3. Find subscriptionId by object_id:
mysql> select * from Subscriptions where
object_id=340;
+----+------------+
| id | object_id |
+----+------------+
| 89 | 340 |
+----+------------+
1 row in set (0.01 sec)
4. Modify the broken context of the APS applications from #2:
mysql> update apsContexts set
subscriptionId=89 where id=7;
Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings:
0
5. Forcibly re-create all Apache web server configuration files:
# httpdmng --reconfigure-all