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.
TIA.
Jason Lane
Developer Root10 developments
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]