Sorry about taking so long to update this with a solution. You were right in the first place francky - it was the PHP memory limit. I had already checked that and determined (incorrectly) that it was not the cause since the old server had lower limits set than the new server where the problem was. However, after reading your post, I dug a little deeper and discovered that prior to PHP 5.2.x, the memory limits are ignored unless that option is speciically enabled at build time. I'm running PHP 5.1.x on both servers. The old server does not have the memory limits enabled and so it was ignoring the settings I was checking.
I increased the PHP memory limit on the new server and the problem is solved. Thanks for your help, folks. Now if I could just figure out why Cake's debug isn't working on that new server.... On Oct 5, 5:33 am, francky06l <[EMAIL PROTECTED]> wrote: > I have had a crash with zend optimizer (because of I8N usage) ... But > it was a complete crash of Apache .. > I commented the zend from php.ini and everything ok now. > In your case, would be strange that it happens on some query and not > others, but this is worse to give a try. > Have you got zend optimization set on the server that works? > > On Oct 4, 11:33 pm, dardosordi <[EMAIL PROTECTED]> wrote: > > > Maybe is the zend optimizer extension again? > > Search this group, i'm just guessing that it can be, it's evil! > > > On Oct 3, 7:46 pm, francky06l <[EMAIL PROTECTED]> wrote: > > > > Well there might be a solution by writing in the log or print_r how > > > far you go. Start in the index.php of webroot, then dispatcher > > > etc ..It's long but at least you will know if ever you enter in your > > > controller. > > > I have been trying your site, it's not a timeout since the blank page > > > appears right away. > > > > Sorry can't help more from here > > > Good luck and if you find the problem/solution, keep update the post. > > > > On Oct 3, 11:25 pm, digitalcowboy <[EMAIL PROTECTED]> wrote: > > > > > Thanks for the reply, but no, I don't think that's it. In fact, the > > > > new server has twice the physical memory as the old server and the PHP > > > > memory limit is set 4x higher, but the old server will return the full > > > > result set. > > > > > Also, as I said, that is just one example. I have other places where > > > > I'm using Pagination and it returns the empty page when clicking on > > > > more than 500 results at a time in the Pagination options. > > > > > I appreciate your tip about the limit, but that doesn't solve my > > > > problem. In many cases there is a business need to have thousands of > > > > results returned in one page. > > > > > This would also be much easier to track down if I could figure out why > > > > Cake's debug is not working AT ALL on this server. > > > > > On Oct 3, 12:50 am, francky06l <[EMAIL PROTECTED]> wrote: > > > > > > looks like a resource problem when having too many results. Have you > > > > > tried to limit the results set in your findAll (case of Virginia) ? > > > > > Try by setting the "limit" parameter in the query. > > > > > I had that problem (not exactly), that was not a timeout issue but > > > > > rather a memory_limit (max 8 Gb) authorized in php.ini. > > > > > > Hope it's a hint > > > > > > On Oct 3, 7:31 am, digitalcowboy <[EMAIL PROTECTED]> wrote: > > > > > > > I apologize if the solution to my issue is to be found elsewhere. > > > > > > I've tried to look but don't really know what I'm looking for and I > > > > > > don't have a lot of time. > > > > > > > I have two problems and I think - but I'm not sure - they are > > > > > > related. I have a client's production site running on a Cake-based > > > > > > solution I created. Recently we outgrew our dedicated server and I > > > > > > added a second beefier server. The Cake-based site is all now on > > > > > > the > > > > > > new server. I replicated everything as exactly as I could. > > > > > > > Now I have two issues - First (and most critical) is that queries > > > > > > with > > > > > > large results are just not running at all. I don't mean large or > > > > > > complicated queries. In most cases they are simple queries with a > > > > > > large result set. They are not timing out. They are just not > > > > > > running > > > > > > at all. After just a few seconds Cake returns an empty page. Empty > > > > > > as in: "View Source" is an empty file. Other queries - and the > > > > > > majority of the site - are running fine. In addition, the old > > > > > > server > > > > > > is now pointing to the database on the new server and doesn't have > > > > > > this problem. Queries that return a blank page on the new server, > > > > > > work (albeit slowly because of the remote db) on the old server. > > > > > > > Second, in trying to troubleshoot this, I discovered that I'm > > > > > > getting > > > > > > no debug results at all, anywhere on the new server no matter what I > > > > > > set the debug level to in app/config/core.php. > > > > > > > I've checked every timeout I can think of - PHP input, PHP script, > > > > > > Apache, etc. I cannot find anything different between the two > > > > > > servers. > > > > > > > Please help. This site is profitable and the core of my client's > > > > > > business. They are losing customers and getting justifiably > > > > > > impatient. I need a quick resolution. > > > > > > > Details: CakePHP 1.1.something on PHP 5, MySQL 5 (5.024 on the old > > > > > > server and 5.027 on new), CentOS 4. You can see one example of the > > > > > > problem by going tohttp://govdirections.com/bids/sitemap/state/and > > > > > > then clicking on the "List" link next to Virginia. That's the new > > > > > > server and will return a totally empty page after just a few > > > > > > seconds - > > > > > > as if the query doesn't even attempt to run. On the old server, > > > > > > pulling from the same database, it takes a good long time, but will > > > > > > eventually return ~22,000 rows. (That number of rows is not normal > > > > > > - > > > > > > it's a separate problem. This is just one example but the problem > > > > > > is > > > > > > also affecting paged results on the new server when trying to switch > > > > > > to anything greater than 500 results at once.) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
