Page 1 of 2

Page does not load : returns "Page Not Found"

Posted: Wed Jul 02, 2003 11:21 am
by cle
Alrighty, here goes. I have Apache2/PHP4.3.2/MySQL running on a Windows box.

Problem: Locally, as in on the same network, my pages load up correctly. However, if I were at some remote location, I get a "Page not found" message...as though it were a 404 Error. But I checked my logs and it says 200, which is normal! No $04's anywhere!

What the script does: The page simply queries my database and lists items in tables. Again, it works locally, but from a remote connection, it doesn't load.

Note: I do notice this: when the query returns, say, about 15 or so results, the page loads irregardless of location. However, anything more and remote sites don't load the as described above. I'm guessing that it's "timing out" or the browser just stopped waiting? I have no idea. :(

I'm not exactly sure. I've uninstalled and reinstalled Apache/PHP/MySQL. Still, I get the same problem. I have no idea why it would only work locally. Not sure what to understand. I've tried google for answers. I've also searched this forum. No problems were similiar. I'm out of ideas. My next choice, which is a good one but not quite feasible at the time, is to run it all on a Linux box.

In the meantime, can anyone help? Thanks in advance!

Posted: Wed Jul 02, 2003 11:46 am
by SBukoski
So you've gotten it to work remotely when there is a small return set from the query? Or is it NEVER working remotely?

Posted: Wed Jul 02, 2003 11:59 am
by cle
Yes. When the return set is small, about 15 results or so, it will load the page. When the results become extensive, which I need, the page will not load. :(

Posted: Wed Jul 02, 2003 12:05 pm
by liljester
do the "extensive" results make the script run for more than 30 seconds? is the remote connection you tried a dialup connection?

Posted: Wed Jul 02, 2003 12:44 pm
by cle
Hehe. Remote connection is cable. The reports don't run for 30 seconds. Well, the things is, I wouldn't know if they ran more than 30 seconds because I've never gotta the page to load. However, the "Page not found" screen pops up immediately. Here's the thing though, it seems that the page loads. You catch a really quick glimpse of it, and then it send it right into the "Page not found."

Extensive results are say, 50-100 results, which really is nothing. On the local machine, the page comes up immediately. But, I don't think that's relevant.

Posted: Wed Jul 02, 2003 12:49 pm
by liljester
have you tried viewing it in different browsers?

Posted: Wed Jul 02, 2003 1:01 pm
by cle
Yup. Netscape loads a half page...then it just stops. Haha. Like, I know there should be 30+ results. It'll load the first 10-14. Randomly chooses when to stop. This all happens remotely though.

Locally, both Netscape and IE render the page correctly. Netscape, however, might screw up the div alignment's slightly, but that's about it. Both still functional. so yeah... I'm trying to stay away from using JS/CSS that's Microsoft based. It's hard breaking the habit because I've been so used to developing in IE. Majority of my hits are IE UA's. But I started testing with Netscape when I noticed descrepancies with alignment as well as non-functioning JS. This is also when I realized the page loaded half way on Netscape, but not at all on IE. So yeah. Still lost. :(

Posted: Wed Jul 02, 2003 1:53 pm
by cactus
To try and understand your issue a little better, can you post the code of, say, your index page.

Do you have logging disabled, or are errors being written to a log file ?

Are your pages publically available (whats the domain ?) or on an intranet ?

Ref : http://uk2.php.net/ref.errorfunc

Regards,

Posted: Wed Jul 02, 2003 3:13 pm
by cle
Alright. I didn't have logging enabled. I do now, E_ALL..all errors logged. I had a friend test it out remotely, but didn't see anything in the log file. However, I do have display errors enabled. But, I don't get any on-screen errors, except for the obvious "Page not Found".

Check these two links out.
Small Result query: http://63.196.63.40/test/testquery.php
Big Result query: http://63.196.63.40/test/testquery.php?query

Source for file: http://63.196.63.40/test/testquery.txt

It's 1:15 California time. gotta go to class. Won't respond until after 6PM. Sorry. But thanks in advance.

Posted: Wed Jul 02, 2003 3:38 pm
by cactus
For:
cle wrote:Small Result query: http://63.196.63.40/test/testquery.php
I get a table showing, Ticket #, Subject, Date, Time, Urgency, Status, Assigned To, all populated with 2 rows of data, and for:
I get a page that constantly refreshes and the data (number of table rows) varies, I DO NOT SEE any 404 or "Page not Found", and continues for more than 1 min. Using Moz/Opera.

It could be network traffic causing your issue.
cle wrote:It's 1:15 California time. gotta go to class. Won't respond until after 6PM. Sorry. But thanks in advance.
No probs.

Regards,

EDIT: What else are you running on your Windows box when these tests are running ?

Posted: Wed Jul 02, 2003 4:04 pm
by liljester
i see a something i dont quite understand ...
below, shouldnt there be a "$result" and "$rows" value set for when $_GET['query'] is set? (the big query)

Code: Select all

<?php

if(isset($_GET['query'])) 
	$query="SELECT NUMBER,SUBJECT,DATE,TIME,URGENCY,STATUS,ASSIGNEDTO FROM help_tickets WHERE CHILD=0 ORDER BY NUMBER DESC,DATE DESC,TIME DESC;";	

else 
	$query="SELECT NUMBER,SUBJECT,DATE,TIME,URGENCY,STATUS,ASSIGNEDTO FROM help_tickets WHERE CHILD=0 AND status='closed' ORDER BY NUMBER DESC,DATE DESC,TIME DESC;";	

	$result=mysql_query($query,$link);
	$rows=mysql_numrows($result);

	print "There are " . $rows . " results in this table<br><BR>";
?>
tho im not convinced fixing that would fix the problem you are having....

Works fine with Mozilla 1.3, doesn't work with MSIE 6.0

Posted: Wed Jul 02, 2003 4:34 pm
by kenrbnsn
I tried this from NJ and here are the results:

MSIE 6.0: Short version works fine.
Long version: very briefly you see a line that says "There are 40 ..." and the "Server can not be reached" page pops up.

Mozilla 1.3: Both versions work fine.

I noticed that you are using CSS classes, but they don't seem to be defined anywhere. That shouldn't be a problem.

I just had a similar situation. A page would display correctly in Mozilla but I got a blank screen in MSIE. Turned out that I had an opening <SCRIPT> tag but no closing </SCRIPT>. IE didn't like it, but Mozilla didn't care.

Take a look for something like that in your generated code.

Posted: Wed Jul 02, 2003 6:57 pm
by cle
See, that's the thing. I don't really use script tags that much. And should this be the case, even in my "short" version, the same should result. Not just in the long version. And I understand what you're doing because I've done the same thing before. Yeah, there aren't any open script tags that I'm currently aware of. Most of my functions are php functions... :( I think I'm gonna try a reformat or something. Start clean. who knows?

Posted: Wed Jul 02, 2003 7:08 pm
by cle
cactus wrote:
EDIT: What else are you running on your Windows box when these tests are running ?
Nothing. I have it specially for PHP/MySQL application development purposes only. The only thing that runs is Apache/PHP/MySQL and that's about it. I once thought network traffic, but at 12:00AM, I know there's not a lot of traffic where I work, a school district..Plus, I check tabs on our proxies and gateways. Not much bandwidth being used at all.

I ought to try mozilla...hm...

Posted: Wed Jul 02, 2003 7:17 pm
by cle
liljester wrote:i see a something i dont quite understand ...
below, shouldnt there be a "$result" and "$rows" value set for when $_GET['query'] is set? (the big query)

tho im not convinced fixing that would fix the problem you are having....
i can imagine that would have been confusing. No, the reason why I did that was because i didn't want to create two separate files to the query. so instead, if you noticed in the URL, i added the 'query' variable...should it be set or exist, then simply run the "extended" query. else, run the short query.

Do you see what i mean? or am I still confusing? Just didn't want two files. ..oh yeah..and two text files to show the source. but in my actual code, it's the extended version...i only coded a lil extra for this example.

oh yeah. these were just query strings....not the actually query being done. :)