Reply
MYSQL database problem
Old 09-23-2007, 08:43 PM MYSQL database problem
Skilled Talker

Posts: 65
hi
i use the easyPHP 1.8 and the database come out with the error

Fatal error: Maximum execution time of 30 seconds exceeded in......

I know i need to set the variable but which variable in which folder i need to change?
i can`t find any folder related except the folder easyPHP1.8 after installing the easyPHP?

please tell me what should i do to fix the error in step by step.
thanks.
leolim is offline
Reply With Quote
View Public Profile
 
When You Register, These Ads Go Away!
     
Old 09-24-2007, 03:14 AM Re: MYSQL database problem
chrishirst's Avatar
Super Moderator

Posts: 12,816
Location: Blackpool. UK
what you were doing when the error occurred might just have some bearing on the problem.


up to now your question is a bit like telephoning a mechanic 500 miles away and asking why your car won't start.

So! before anyone can give step by step instructions how to fix said problem having step by step information on what caused it is needed.
__________________
Chris. ->> Links are advertising NOT optimising!! <<-
Indifference will be the downfall of mankind, but who cares?
Code Samples | People Counting System
chrishirst is offline
Reply With Quote
View Public Profile Visit chrishirst's homepage!
 
Old 09-24-2007, 04:57 AM Re: MYSQL database problem
tripy's Avatar
Fetchez la vache!

Posts: 1,988
Name: Thierry
Location: In the void
Leolim,

php.ini have a variable that tells the engine how much time the script can run (30 seconds by default).
If the processing takes longer than that, php kills the script, and output you this error.

So, you can have 2 scenarios:
1: There is an error in your code that make PHP goes in an infinite loop
2: You are making a lot of processing, and this is normal that your script takes more than 30 seconds to be ran

If you are in case 2, you can modify the default behavior by inserting an
PHP Code:
ini_set('max_execution_time',90); 
on top of your code.
http://www.php.net/manual/en/ref.inf...execution-time
That would lift the max allowed time your script can run to 90 seconds.
Put that value to 0, and it'll mean infinite.

In case you process and store a lot of datas, take care of the memory limit too:
http://www.php.net/manual/en/ini.cor...i.memory-limit
__________________
Listen to the ducky: "This is awesome!!!"

tripy is offline
Reply With Quote
View Public Profile
 
Old 09-24-2007, 08:23 PM Re: MYSQL database problem
Skilled Talker

Posts: 65
tripy i know this might be a funny question. any where to set the setting without inserting the code?
Another is do you mean that i can put the PHP code at anywhere in the page as long as it is within the <?PHP ?> tag?
or the best is to put it after the connection to the database begin?

thanks
leolim is offline
Reply With Quote
View Public Profile
 
Old 09-24-2007, 08:39 PM Re: MYSQL database problem
tripy's Avatar
Fetchez la vache!

Posts: 1,988
Name: Thierry
Location: In the void
To make it permanent, locate your php.ini and change it's settings there.
Otherwise, you should place the ini_set before doing the parsing.
As the PHP engine will parse file from top to bottom, if you place the ini_set under the loop where you work, it won't be applied.
That's the reason why it's usually placed at the top of the file.
And yes, it must be enclosed by PHP tags.
__________________
Listen to the ducky: "This is awesome!!!"

tripy is offline
Reply With Quote
View Public Profile
 
Old 09-25-2007, 08:51 PM Re: MYSQL database problem
Skilled Talker

Posts: 65
another funny question is how to set the permanent setting where i don`t think i see any variable or field called ini_set('max_execution_time',90) in that file. What should i type or add to set the permanent setting and can i place any where in the php.ini?
sorry if this question sounds funny but please guide me on this cause i am new to this mysql and PHP enviroment

Thanks tripy
leolim is offline
Reply With Quote
View Public Profile
 
Old 09-26-2007, 01:38 AM Re: MYSQL database problem
tripy's Avatar
Fetchez la vache!

Posts: 1,988
Name: Thierry
Location: In the void
Quote:
To make it permanent, locate your php.ini and change it's settings there.
The settings is into php.ini, and it's in the form
Quote:
max_execution_time=30
Simply change that value and it will be permanent for every page you run.
__________________
Listen to the ducky: "This is awesome!!!"

tripy is offline
Reply With Quote
View Public Profile
 
Old 09-26-2007, 08:36 PM Re: MYSQL database problem
Skilled Talker

Posts: 65
hi tripy i have located the file and there is two file one is EasyPHP.ini and another is in the apache folder which is the php.ini. is it the one in the apache folder and if i set the value to 0 you say that it will not have and execution timeout rite?

thanks
leolim is offline
Reply With Quote
View Public Profile
 
Old 09-27-2007, 01:26 AM Re: MYSQL database problem
tripy's Avatar
Fetchez la vache!

Posts: 1,988
Name: Thierry
Location: In the void
I don't know, I never used easyPhp.

Create a page with just a call to phpinfo(), in the infos that will be displayed when you open this page with your browser, you will have the full path to the file.
__________________
Listen to the ducky: "This is awesome!!!"

tripy is offline
Reply With Quote
View Public Profile
 
Old 09-28-2007, 03:59 AM Re: MYSQL database problem
Skilled Talker

Posts: 65
any other tools beside easyphp to create php code? kindly tell me how to install and use it. and where can i download latest free unlimited version of the mysql?

thanks

Last edited by leolim : 09-28-2007 at 04:01 AM.
leolim is offline
Reply With Quote
View Public Profile
 
Old 09-28-2007, 04:10 AM Re: MYSQL database problem
tripy's Avatar
Fetchez la vache!

Posts: 1,988
Name: Thierry
Location: In the void
Quote:
any other tools beside easyphp to create php code
To create php files, any text editor will do.

To run php on a window box, I personnaly would recommand xampp
http://www.apachefriends.org/en/xampp-windows.html

Quote:
and where can i download latest free unlimited version of the mysql
http://dev.mysql.com/downloads/mysql/5.0.html
__________________
Listen to the ducky: "This is awesome!!!"

tripy is offline
Reply With Quote
View Public Profile
 
Old 10-02-2007, 09:38 PM Re: MYSQL database problem
Skilled Talker

Posts: 65
hello tripy could you guide me on which version to download form the
http://www.apachefriends.org/en/xampp-windows.html ?

and for the my sql 5.0 is it that i should download the version without payment right?

sorry for asking this question cause i am really new to this enviroment.

thanks
leolim is offline
Reply With Quote
View Public Profile
 
Old 10-03-2007, 03:32 AM Re: MYSQL database problem
tripy's Avatar
Fetchez la vache!

Posts: 1,988
Name: Thierry
Location: In the void
Simply get the windows installer. I never tried other packages.
No need to look for mysql appart of it, the xampp package already contains a mysql 5.0 (I guess...)

But yes, if you would download it independently, you should go for the community version, which is free.
__________________
Listen to the ducky: "This is awesome!!!"

tripy is offline
Reply With Quote
View Public Profile
 
Old 10-03-2007, 07:56 PM Re: MYSQL database problem
Skilled Talker

Posts: 65
let me try it
thanks
leolim is offline
Reply With Quote
View Public Profile
 
Old 10-09-2007, 07:56 PM Re: MYSQL database problem
Skilled Talker

Posts: 65
tripy is the software you introduced is in php 5 or 4? what is the different betwwen those two?
leolim is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to MYSQL database problem
 

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off




   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML

 


Page generated in 0.22938 seconds with 13 queries