PHP handler is displayed as corrupted after it was removed

Symptoms

• After PHP handler is uninstalled it displayed as a corrupt in Tools & Settings > PHP Settings:

  

• There are websites, assigned to this handler even though it is removed:

  • On Linux

    # plesk db -Ne "SELECT d.name, h.php_handler_id FROM hosting h RIGHT JOIN domains d ON d.id=h.dom_id WHERE h.php_handler_id LIKE 'plesk-php72%';"
    example.com plesk-php72-fpm
    example2.com plesk-php72-fpm

  • On Windows

    PS plesk db -Ne "SELECT d.name, h.php_handler_id FROM hosting h RIGHT JOIN domains d ON d.id=h.dom_id WHERE h.php_handler_id LIKE '%7.2%';"
    example.com fastcgi-7.2
    example2.com fastcgi-7.2

• There are Service Plans (including addon plans) with this PHP handler specified as the preset:

  • On Linux

    # plesk db -Ne "SELECT t.name, td.value, t.type FROM TmplData td LEFT JOIN Templates t ON td.tmpl_id = t.id WHERE td.element = 'php_handler_id' AND td.value LIKE 'plesk-php72%'"
    Admin Simple plesk-php72-fpm
    Default Domain plesk-php72-fpm

  • On Windows

    PS plesk db -Ne "SELECT t.name, td.value, t.type FROM TmplData td LEFT JOIN Templates t ON td.tmpl_id = t.id WHERE td.element = 'php_handler_id' AND td.value LIKE '%7.2%'"
    Admin Simple fastcgi-7.2
    Default Domain fastcgi-7.2

• Website assigned to the removed handler does not have PHP Settings button in Domains > example.com:

  

Cause

Bug with ID #PPPM-7677, which will be fixed in the future updates.

Resolution

Until the fix is released, a workaround can be applied:

1. Connect to the server via SSH/RDP;

2. Switch domains that use this handler to a different one:

   Note: Here and further, all objects using PHP 7.2 will be switched to PHP 7.1. This behavior might be changed by modification of highlighted entries to a different handler ID. A list of all available handler IDs can be retrieved via plesk bin php_handler --list.

   • On Linux

     # for i in $(plesk db -Ne "SELECT d.name FROM hosting h RIGHT JOIN domains d ON d.id=h.dom_id WHERE h.php_handler_id LIKE 'plesk-php72%';"); do plesk bin site -u $i -php_handler_id plesk-php71-fpm; done

   • On Windows

     PS &plesk db -Ne "SELECT d.name FROM hosting h RIGHT JOIN domains d ON d.id=h.dom_id WHERE h.php_handler_id LIKE '%7.2%';" | % { if ( $_ ) { &plesk bin site -u $_ -php_handler_id fastcgi-7.1 } }

3. Switch Service Plans (not addon plans) that use this PHP handler to a different one:

   • On Linux

     # plesk db -Ne "SELECT t.name FROM TmplData td LEFT JOIN Templates t ON td.tmpl_id = t.id WHERE td.element = 'php_handler_id' AND td.value LIKE 'plesk-php72%' AND t.type = 'domain'" | while read -r i; do plesk bin service_plan --update "$i" -php_handler_id "plesk-php71-fpm"; done

   • On Windows

     PS &plesk db -Ne "SELECT t.name FROM TmplData td LEFT JOIN Templates t ON td.tmpl_id = t.id WHERE td.element = 'php_handler_id' AND td.value LIKE '%7.2%' AND t.type = 'domain'" | % { if ( $_ ) { &plesk bin service_plan -u $_ -php_handler_id fastcgi-7.1 } }

4. Switch all addon plans that use the PHP handler to a different one:

   • For Linux:

     # plesk db -Ne "SELECT t.name FROM TmplData td LEFT JOIN Templates t ON td.tmpl_id = t.id WHERE td.element = 'php_handler_id' AND td.value LIKE 'plesk-php72-fpm' AND t.type = 'domain_addon'" | while read -r i; do plesk bin service_plan_addon --update "$i" -php_handler_id "plesk-php71-fpm"; done

   • For Windows:

     PS &plesk db -Ne "SELECT t.name FROM TmplData td LEFT JOIN Templates t ON td.tmpl_id = t.id WHERE td.element = 'php_handler_id' AND td.value LIKE '%7.2%' AND t.type = 'domain_addon'" | % { if ( $_ ) { &plesk bin service_plan_addon -u $_ -php_handler_id fastcgi-7.1 } }

5. Update the information on available PHP handlers:

   # plesk bin php_handler --reread

   Or force remove it:

   plesk bin php_handler --remove -id

Additional information

In case the removal command from step 5 errored out with information that handler is being used, check database for orphaned domain entries using the following command. It is the same, both for Windows and Linux:

# plesk repair db