Article ID: 122124, created on Jun 21, 2014, last review on Jun 19, 2016

  • Applies to:
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 10.4 for Linux/Unix
  • Plesk 11.5 for Windows


When browsing Home > Domains > domain.tld in Parallels Plesk Panel (Plesk), the following error occurs:

Internal error: MySQL query failed: Unknown column 'php_handler_type' in 'field list'
Message MySQL query failed: Unknown column 'php_handler_type' in 'field list'
File     common_func.php3
Line    220
Type    PleskMainDBException

When logged in to MySQL and checking the php_handler_type colum, it is missing:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa 


mysql> select php_handler_type from hosting;
ERROR 1054 (42S22): Unknown column 'php_handler_type' in 'field list'


Failed upgrade.


It is recommended that you restore a pre-upgrade database dump and then re-run the upgrade procedure.

If the above scenario is not suitable, add the corresponding column manually:

  1. Create database backups:

    MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin psa > /root/psa.`date +%Y%m%d.%H%M%S`.sql
  2. Add the column:

    mysql> ALTER TABLE `hosting` ADD `php_handler_type` enum('cgi','fastcgi','module')  NULL default 'module';

Search Words

Unknown column 'php_handler_type' in 'field list'


MySQL error when creating subscription or accessing Migration Manager


psa missing from server

MySQL query failed: Unknown column 'php_handler_type' in 'field list'

a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c 01bc4c8cf5b7f01f815a7ada004154a2 29d1e90fd304f01e6420fbe60f66f838 0a53c5a9ca65a74d37ef5c5eaeb55d7f aea4cd7bfd353ad7a1341a257ad4724a e8756e9388aeca36710ac39e739b2b37 dd0611b6086474193d9bf78e2b293040 85a92ca67f2200d36506862eaa6ed6b8 46a8e394d6fa13134808921036a34da8 bd7fc88cf1b01f097749ae6f87272128

Email subscription for changes to this article
Save as PDF