rohitbanerjee Posted April 16, 2012 Share Posted April 16, 2012 So I have some php code within an html page (using Apache v2.2, PHP v5.2) that uses MySQLI to connect to a database and fetch some rows from a database. Everything works fine so long as I limit the number of rows fetched, if I try to fetch all the rows, I get a 500 Internal Server Error in my browser. I am using GoDaddy Hosting -- has anyone encountered this problem/know what the hell is going on? Quote Link to comment Share on other sites More sharing options...
gristoi Posted April 16, 2012 Share Posted April 16, 2012 turn on your error chekcing and find out, add this to the top of your page: error_reporting(E_ALL); Quote Link to comment Share on other sites More sharing options...
Adam Posted April 16, 2012 Share Posted April 16, 2012 How many rows are we talking? It's sounds like PHP is running out of memory and throwing the generic server error. If you have access to the error logs you should be able to get the error message, but increasing the memory limit should be enough - see here for directive and use ini_set to change it per request. Don't just whack it up for every request, there's some serious security concerns with increasing the memory. Of course sometimes when dealing with large sets of data it's just not avoidable. Quote Link to comment Share on other sites More sharing options...
rohitbanerjee Posted April 16, 2012 Author Share Posted April 16, 2012 Thanks for the help guys -- apparently GoDaddy internally throttles the amount of data you can fetch. I will update this forum with my results. Quote Link to comment 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.