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
-
Login to the server over SSH/RDP.
-
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
-
-
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”
-