New configuration files for the Apache web server were not created after upgrade to Plesk 12.5

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:14:49 UTC

Modified:

2016-12-21 20:16:42 UTC

0

Was this article helpful?


Have more questions?

Submit a request

New configuration files for the Apache web server were not created after upgrade to Plesk 12.5

Symptoms

  1. 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.
  2. Database was upgraded and has plesk 12.5 structure:

    mysql> select * from misc where param="version";
    +---------+-----------+
    | param | val |
    +---------+-----------+
    | version | 012005030 |
    +---------+-----------+

Cause

Domains configuration files were corrupted after a database upgrade

Resolution

  1. Make database dump according to:

213904125 How to backup/restore a Plesk database dump?

  1. 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
  2. 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
Have more questions? Submit a request
Please sign in to leave a comment.