Maximum execution time in phpMyadmin?

Question

When I try to go phpMyadmin I get this error

Fatal error: Maximum execution time of 30 seconds exceeded in 
             C:\xampp\phpMyAdmin\libraries\session.inc.php on line 108

Have you looked at: http://stackoverflow.com/questions/5164930/fatal-error-maximum-execution-time-of-30-seconds-exceeded ? — Mike, Nov 10 '15 at 23:59
@Mike When i try to come in http://localhost:8080/phpmyadmin/ i get last message — Bobox, Nov 11 '15 at 00:03
Edit the php.ini in `\xampp\apache\bin\php.ini` and it might well make a difference to the PHP running under Apache — RiggsFolly, Nov 11 '15 at 00:05
your all trying to fix the symptom, not cure the disease. phpmyadmin should not be taking that long, something is wrong with the install — , Nov 11 '15 at 00:15
@Dagon Not necessarily, What is this guy actually doing in phpMyAdmin. The question is WAY TOO BROAD for anything other than guesses — RiggsFolly, Nov 11 '15 at 00:17
**Which php.ini** did you edit, there are **2** One in the `\xampp\php\php.ini` which does not effect phpMyAdmin and one in `\xampp\apache\bin\php.ini` that does effect phpMyAdmin — RiggsFolly, Nov 11 '15 at 00:20
@Dagon I've gone over 30 seconds on some phpmyadmin imports before. Of course, if the OP is just executing a regular query it's likely an indexing problem. As RiggsFolly said, it's way too broad to tell. — Mike, Nov 11 '15 at 00:22
So **read my other comments** make the `max_execution_time=300` change in `\xampp\apache\bin\php.ini` The `\xampp\php\php.ini` file only effects PHP CLI (Command Line Interface) i.e. running php from the command line — RiggsFolly, Nov 11 '15 at 00:27
reads like he is visiting it to log in, not run a query - to me at least — , Nov 11 '15 at 00:27
@Dagon No see his last comment he is editing the wrong `php.ini` file — RiggsFolly, Nov 11 '15 at 00:28
@RiggsFolly I think Dagon's point is that there is very little reason that the script should take more than 30 seconds in the first place. — Mike, Nov 11 '15 at 00:31
@Mike unless like you said, he is actually doing an import of a large backup. That is the normal reason for this sort of issue — RiggsFolly, Nov 11 '15 at 00:31
he just says hes visiting "localhost:8080/phpmyadmin " nothing about actually making a query — , Nov 11 '15 at 00:32
Bobox: Just to be sure, what are you doing once you get into the phpMyAdmin pages? — RiggsFolly, Nov 11 '15 at 00:35
@Mike Patients lie, so do developers with issues. Or rather neglect to give all the facts — RiggsFolly, Nov 11 '15 at 00:35
@Dagon Lucky you, us ugle developers never get any of the breaks.... urm, thats not HOUSE by the way — RiggsFolly, Nov 11 '15 at 00:40

score 1 · Answer 1 · answered Nov 11 '15 at 00:43

Bobox,

You are editing the wrong php.ini file. There are 2 php.ini files.

One is in \xampp\php\php.ini, this file only effects PHP that you run from the command line.

The other is in \xampp\apache\bin\php.ini this is the file that Apache uses when it runs, so this is the file you need to amend to effect the execution of phpMyAdmin.

So edit \xampp\apache\bin\php.ini

Find the max_execution_time parameter and change it to

max_execution_time=600

Then restart Apache, so that it reads this change then try running whatever you are doing in phpMyAdmin again.

If it still errors, try increasing the time parameter to 900, etc, until whatever it is works

Maximum execution time in phpMyadmin?

1 Answers1

Linked