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: 05. Forcibly re-create all Apache web server configuration files:
# httpdmng --reconfigure-all