The following error in Plesk GUI:
New configuration files for the Apache web server were not created due to the errors in configuration templates: Template processing failed: file = /usr/local/psa/admin/conf/templates/default/domainVhost.php, error = Template_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.fp' in 'field list' file: /usr/local/psa/admin/plib/Template/Processor.php line: 28 code: 0 Previous error: Zend_Db_Statement_Exception: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.fp' in 'field list' file: /usr/local/psa/admin/externals/Zend/Db/Statement/Pdo.php line: 234 code: 42 Previous error: PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'h.fp' in 'field list' file: /usr/local/psa/admin/externals/Zend/Db/Statement/Pdo.php line: 228 code: 42S22. Detailed error descriptions were sent to you by email. Please, resolve the issues and click here to generate broken configuration files once again or here to generate all configuration files.
Database was upgraded and has plesk 12.5 structure:
mysql> select * from misc where param="version";
| param | val |
| version | 012005030 |
Domains configuration files were corrupted after a database upgrade
- Make database dump according to:
213904125 How to backup/restore a Plesk database dump?
Generate the list of affected domains:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -Ne"select domains.name from domains left join Configurations on domains.id=Configurations.objectId where Configurations.objectType='domain' and Configurations.status <> 'ok';" > domains.txt
Reconfigure all domains from domains.txt list to decrease possible downtime of the website:
# cat domains.txt | while read i; do /usr/local/psa/admin/sbin/httpdmng --reconfigure-domain $i && echo "$i is OK" ;done