Fatal error: Maximum execution time of 30 seconds exceeded in XAMPP
up vote
0
down vote
favorite
I have tried many.
First, I changed these.
- And Change php.ini and my.ini
- post_max_size = 750M
- upload_max_filesize = 750M
- max_execution_time = 5000
- max_input_time = 5000
- memory_limit = 1000M
- max_allowed_packet = 200M (in my.ini)
and add this
$cfg['ExecTimeLimit'] = 6000;
to phpmyadmin/config.inc.php
Second,
In the my.ini file, edit the “max_allowed_packet” by increasing the value.
XAMPP default value is 1M. I updated it to 10M.
But I could't solve it.
The following is the error contents.
Warning: mysqli::__construct(): MySQL server has gone away in
C:xampphtdocsescape_roomLogin.php on line 8
Warning: mysqli::__construct(): Error while reading greeting packet.
PID=5632 in C:xampphtdocsescape_roomLogin.php on line 8
Warning: mysqli::__construct(): (HY000/2006): MySQL server has gone away in
C:xampphtdocsescape_roomLogin.php on line 8
Fatal error: Maximum execution time of 30 seconds exceeded in
C:xampphtdocsescape_roomLogin.php on line 8
https: // ip_number / escape_room / accessed, but if I try to access Login.php, I get an error.
I'm testing when I approach from the outside.
thank you!
mysql xampp
asked Nov 22 at 10:27
황인규
235
add a comment |
up vote
0
down vote
favorite
I have tried many.
First, I changed these.
- And Change php.ini and my.ini
- post_max_size = 750M
- upload_max_filesize = 750M
- max_execution_time = 5000
- max_input_time = 5000
- memory_limit = 1000M
- max_allowed_packet = 200M (in my.ini)
and add this
$cfg['ExecTimeLimit'] = 6000;
to phpmyadmin/config.inc.php
Second,
In the my.ini file, edit the “max_allowed_packet” by increasing the value.
XAMPP default value is 1M. I updated it to 10M.
But I could't solve it.
The following is the error contents.
Warning: mysqli::__construct(): MySQL server has gone away in
C:xampphtdocsescape_roomLogin.php on line 8
Warning: mysqli::__construct(): Error while reading greeting packet.
PID=5632 in C:xampphtdocsescape_roomLogin.php on line 8
Warning: mysqli::__construct(): (HY000/2006): MySQL server has gone away in
C:xampphtdocsescape_roomLogin.php on line 8
Fatal error: Maximum execution time of 30 seconds exceeded in
C:xampphtdocsescape_roomLogin.php on line 8
https: // ip_number / escape_room / accessed, but if I try to access Login.php, I get an error.
I'm testing when I approach from the outside.
thank you!
mysql xampp
asked Nov 22 at 10:27
황인규
235
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I have tried many.
First, I changed these.
- And Change php.ini and my.ini
- post_max_size = 750M
- upload_max_filesize = 750M
- max_execution_time = 5000
- max_input_time = 5000
- memory_limit = 1000M
- max_allowed_packet = 200M (in my.ini)
and add this
$cfg['ExecTimeLimit'] = 6000;
to phpmyadmin/config.inc.php
Second,
In the my.ini file, edit the “max_allowed_packet” by increasing the value.
XAMPP default value is 1M. I updated it to 10M.
But I could't solve it.
The following is the error contents.
Warning: mysqli::__construct(): MySQL server has gone away in
C:xampphtdocsescape_roomLogin.php on line 8
Warning: mysqli::__construct(): Error while reading greeting packet.
PID=5632 in C:xampphtdocsescape_roomLogin.php on line 8
Warning: mysqli::__construct(): (HY000/2006): MySQL server has gone away in
C:xampphtdocsescape_roomLogin.php on line 8
Fatal error: Maximum execution time of 30 seconds exceeded in
C:xampphtdocsescape_roomLogin.php on line 8
https: // ip_number / escape_room / accessed, but if I try to access Login.php, I get an error.
I'm testing when I approach from the outside.
thank you!
mysql xampp
asked Nov 22 at 10:27
황인규
235
I have tried many.
First, I changed these.
- And Change php.ini and my.ini
- post_max_size = 750M
- upload_max_filesize = 750M
- max_execution_time = 5000
- max_input_time = 5000
- memory_limit = 1000M
- max_allowed_packet = 200M (in my.ini)
and add this
$cfg['ExecTimeLimit'] = 6000;
to phpmyadmin/config.inc.php
Second,
In the my.ini file, edit the “max_allowed_packet” by increasing the value.
XAMPP default value is 1M. I updated it to 10M.
But I could't solve it.
The following is the error contents.
Warning: mysqli::__construct(): MySQL server has gone away in
C:xampphtdocsescape_roomLogin.php on line 8
Warning: mysqli::__construct(): Error while reading greeting packet.
PID=5632 in C:xampphtdocsescape_roomLogin.php on line 8
Warning: mysqli::__construct(): (HY000/2006): MySQL server has gone away in
C:xampphtdocsescape_roomLogin.php on line 8
Fatal error: Maximum execution time of 30 seconds exceeded in
C:xampphtdocsescape_roomLogin.php on line 8
https: // ip_number / escape_room / accessed, but if I try to access Login.php, I get an error.
I'm testing when I approach from the outside.
thank you!
mysql xampp
mysql xampp
asked Nov 22 at 10:27
황인규
235
asked Nov 22 at 10:27
황인규
235
asked Nov 22 at 10:27
황인규
235
asked Nov 22 at 10:27
황인규
235
asked Nov 22 at 10:27
황인규
235
235
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
accepted
It is highly possible that you changed the values in the wrong file.
First of all I would check the actual configuration. You can do that easily in XAMPP by looking at this page:
http://localhost/dashboard/phpinfo.php
Then search for max_execution time. You'll find a line like this:
If that doesn't have your updated max_execution_time you changed the wrong file.
You would need to change this file ...xamppphpphp.ini
Do the same with all the other variables you mentioned above.
answered Nov 22 at 10:45
rf1234
40257
Thank you. I've checked everything, and I've made changes that have not been fixed. However, MySQL server has gone away, Error while reading greeting packet PID = 7728 in ... still occurs.
– 황인규
Nov 22 at 11:07
The MySQL issue is probably caused by something completely different. I would open a new question just with this issue and give a lot more detail to it if possible. Have you taken a look at this? dev.mysql.com/doc/refman/8.0/en/gone-away.html
– rf1234
Nov 22 at 12:01
Thank you. I'll try mysql_ping ().
– 황인규
Nov 22 at 13:29
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53428851%2ffatal-error-maximum-execution-time-of-30-seconds-exceeded-in-xampp%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
accepted
It is highly possible that you changed the values in the wrong file.
First of all I would check the actual configuration. You can do that easily in XAMPP by looking at this page:
http://localhost/dashboard/phpinfo.php
Then search for max_execution time. You'll find a line like this:
If that doesn't have your updated max_execution_time you changed the wrong file.
You would need to change this file ...xamppphpphp.ini
Do the same with all the other variables you mentioned above.
answered Nov 22 at 10:45
rf1234
40257
Thank you. I've checked everything, and I've made changes that have not been fixed. However, MySQL server has gone away, Error while reading greeting packet PID = 7728 in ... still occurs.
– 황인규
Nov 22 at 11:07
The MySQL issue is probably caused by something completely different. I would open a new question just with this issue and give a lot more detail to it if possible. Have you taken a look at this? dev.mysql.com/doc/refman/8.0/en/gone-away.html
– rf1234
Nov 22 at 12:01
Thank you. I'll try mysql_ping ().
– 황인규
Nov 22 at 13:29
add a comment |
up vote
0
down vote
accepted
It is highly possible that you changed the values in the wrong file.
First of all I would check the actual configuration. You can do that easily in XAMPP by looking at this page:
http://localhost/dashboard/phpinfo.php
Then search for max_execution time. You'll find a line like this:
If that doesn't have your updated max_execution_time you changed the wrong file.
You would need to change this file ...xamppphpphp.ini
Do the same with all the other variables you mentioned above.
answered Nov 22 at 10:45
rf1234
40257
Thank you. I've checked everything, and I've made changes that have not been fixed. However, MySQL server has gone away, Error while reading greeting packet PID = 7728 in ... still occurs.
– 황인규
Nov 22 at 11:07
The MySQL issue is probably caused by something completely different. I would open a new question just with this issue and give a lot more detail to it if possible. Have you taken a look at this? dev.mysql.com/doc/refman/8.0/en/gone-away.html
– rf1234
Nov 22 at 12:01
Thank you. I'll try mysql_ping ().
– 황인규
Nov 22 at 13:29
add a comment |
up vote
0
down vote
accepted
up vote
0
down vote
accepted
It is highly possible that you changed the values in the wrong file.
First of all I would check the actual configuration. You can do that easily in XAMPP by looking at this page:
http://localhost/dashboard/phpinfo.php
Then search for max_execution time. You'll find a line like this:
If that doesn't have your updated max_execution_time you changed the wrong file.
You would need to change this file ...xamppphpphp.ini
Do the same with all the other variables you mentioned above.
answered Nov 22 at 10:45
rf1234
40257
It is highly possible that you changed the values in the wrong file.
First of all I would check the actual configuration. You can do that easily in XAMPP by looking at this page:
http://localhost/dashboard/phpinfo.php
Then search for max_execution time. You'll find a line like this:
If that doesn't have your updated max_execution_time you changed the wrong file.
You would need to change this file ...xamppphpphp.ini
Do the same with all the other variables you mentioned above.
answered Nov 22 at 10:45
rf1234
40257
answered Nov 22 at 10:45
rf1234
40257
answered Nov 22 at 10:45
rf1234
40257
answered Nov 22 at 10:45
rf1234
40257
40257
Thank you. I've checked everything, and I've made changes that have not been fixed. However, MySQL server has gone away, Error while reading greeting packet PID = 7728 in ... still occurs.
– 황인규
Nov 22 at 11:07
The MySQL issue is probably caused by something completely different. I would open a new question just with this issue and give a lot more detail to it if possible. Have you taken a look at this? dev.mysql.com/doc/refman/8.0/en/gone-away.html
– rf1234
Nov 22 at 12:01
Thank you. I'll try mysql_ping ().
– 황인규
Nov 22 at 13:29
add a comment |
Thank you. I've checked everything, and I've made changes that have not been fixed. However, MySQL server has gone away, Error while reading greeting packet PID = 7728 in ... still occurs.
– 황인규
Nov 22 at 11:07
The MySQL issue is probably caused by something completely different. I would open a new question just with this issue and give a lot more detail to it if possible. Have you taken a look at this? dev.mysql.com/doc/refman/8.0/en/gone-away.html
– rf1234
Nov 22 at 12:01
Thank you. I'll try mysql_ping ().
– 황인규
Nov 22 at 13:29
Thank you. I've checked everything, and I've made changes that have not been fixed. However, MySQL server has gone away, Error while reading greeting packet PID = 7728 in ... still occurs.
– 황인규
Nov 22 at 11:07
Thank you. I've checked everything, and I've made changes that have not been fixed. However, MySQL server has gone away, Error while reading greeting packet PID = 7728 in ... still occurs.
– 황인규
Nov 22 at 11:07
The MySQL issue is probably caused by something completely different. I would open a new question just with this issue and give a lot more detail to it if possible. Have you taken a look at this? dev.mysql.com/doc/refman/8.0/en/gone-away.html
– rf1234
Nov 22 at 12:01
The MySQL issue is probably caused by something completely different. I would open a new question just with this issue and give a lot more detail to it if possible. Have you taken a look at this? dev.mysql.com/doc/refman/8.0/en/gone-away.html
– rf1234
Nov 22 at 12:01
Thank you. I'll try mysql_ping ().
– 황인규
Nov 22 at 13:29
Thank you. I'll try mysql_ping ().
– 황인규
Nov 22 at 13:29
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53428851%2ffatal-error-maximum-execution-time-of-30-seconds-exceeded-in-xampp%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
