Phil - Gaming-Heaven Posted September 9, 2007 Share Posted September 9, 2007 we have a php script running on my forum and it times out (i get a white blank screen) The script works fine as i have tested it on a test forum. normal forum has over 6000 games in it (script times out) white page) test forum has 3000 games in it (script works fine) i have changed the below but it hasnt made any difference so im presuming it is either a sql timeout or a php timeout so i would need to change there limits but i dont know where to do this as ic ants ee nothin int he php.ini relating to them. below si whati changed with no luck on sorting the problem: max_execution_time = memory_limit = Quote Link to comment https://forums.phpfreaks.com/topic/68608-mysql-timeout-limit/ Share on other sites More sharing options...
fenway Posted September 9, 2007 Share Posted September 9, 2007 Shouldn't take that long to run any script... Quote Link to comment https://forums.phpfreaks.com/topic/68608-mysql-timeout-limit/#findComment-345017 Share on other sites More sharing options...
Phil - Gaming-Heaven Posted September 10, 2007 Author Share Posted September 10, 2007 my bad, i set it to 100000 seconds and 2000MB and i just got a white page EDIT: OK I NOW KNOW WHAT TEH ERROR IS BUT STILL I DONT KNOW HWO IT CAN BE SOLVED, MAYBE BY EXTENDING THE TIMEOUT LIMIT ON SQL? Date: Sun, 09 Sep 2007 11:20:23 +0000 Error Number: 2013 Error: Lost connection to MySQL server during query IP Address: 82.*.*.*.*.* Quote Link to comment https://forums.phpfreaks.com/topic/68608-mysql-timeout-limit/#findComment-345034 Share on other sites More sharing options...
fenway Posted September 11, 2007 Share Posted September 11, 2007 Post the EXPLAIN output of the query that's causing problems. Quote Link to comment https://forums.phpfreaks.com/topic/68608-mysql-timeout-limit/#findComment-346182 Share on other sites More sharing options...
bharathkumar Posted November 17, 2007 Share Posted November 17, 2007 Quote Link to comment https://forums.phpfreaks.com/topic/68608-mysql-timeout-limit/#findComment-393302 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.