Unable to open a large table via phpMyAdmin in Plesk: Error in Processing Request

Symptoms

• Upon the attempt to open a large table via phpMyAdmin the following error is displayed:

  Error in processing request
   Error code: 500 
   Error text: Internal Server Error

• The following error can be found in /var/log/plesk/panel.log:

  [29-Jan-2018 17:34:10] PHP Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 401128 bytes) in /opt/psa/admin/htdocs/domains/databases/phpMyAdmin/libraries/DisplayResults.php on line 2852

Cause

The insufficient size of PHP memory limit.

Resolution

1. Login to the server over SSH/RDP.

2. Open Plesk PHP configuration file in any editor and increase the memory_limit, max_input_vars parameters:

   • For Linux:

     /usr/local/psa/admin/conf/php.ini

   • For Windows:

     %plesk_dir%adminconfphp.ini

3. Restart the Plesk management service:

   • For Linux:

     # service psa restart

   • For Windows, open the command prompt and run the commands one by one:

     C:> net stop “Plesk PopPass Service”
     net stop “Plesk Management Service”
     net start “Plesk Management Service”
     net start “Plesk PopPass Service”