Is the live site also running Apache 2? Are they both using the same version of PHP? Panther upgrades the version of php installed as well as overwriting your httpd.conf file. I'm pretty sure Apple renames the existing copy to httpd.conf.applesaved. If you are using PEAR to handle your pagination, there may be a configuration issue there.
I don't use PEAR (for no good reason) and I have no problems with my own pagination code. I would go over your PHP configuration, specifically the include parameters, which you need for PEAR.



On Thursday, November 6, 2003, at 11:20 AM, g4 wrote:


Hi list,

I'm still trying to ascertain if this is in fact an MySql problem, here goes.

I'm developing locally on My G4 box running Apache 2 + MySql 4.0.16, I have a live site on a FreeBSD box running Apache 1.3 + MySql 3.x. The site is an e-commerce site (PHP 4.3). When I try and access a page that paginates because of the number of items has exceeded 6 items I get in Safari:

Could not open the page “http://192.168.0.11/Englishhall/shopping/ index.php?p=1%7C5%7C10%7C14%7C19&id=27” because Safari could not load any data for this location.

and in Mozilla, well just nothing!

When I try an access a page with no pagination it works. So for example “http://192.168.0.11/Englishhall/shopping/ index.php?p=1%7C5%7C10%7C14%7C19&id=30” will work.

My local Database (on my G4 box) has been created from dumps from the live site. At first I thought this was a problem with My PHP, so I downloaded the unchanged PHP source from the live site, so essentially an exact copy of a working site..... and it still produces the same results. So it must be a Database issue right?

I have upgraded to Panther recently and this caused some of the tables to lose their permissions, which I've fixed. I reinstalled the DB and the issue still remains. Is there a limiter of some sort I have to increase?

Anyway any help much appreciated.

--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to