Matt, If you go through the various build options tried in that bug report, you will see that it is a subtle bug and apparently still unresolved. I couldn't tell you with any degree of confidence will fix it. The bug report does show a couple of configure options for PHP which seem to elimiate it, without shedding much light on the underlaying cause.
Possible conflict in zlib versions or some other common library between PHP and MySQL build.. I would closely examine the dependant libraries via $ ldd... Hard to tell without knowing the OS, the specific software builds and the various library versions especially any shared ones.. If you have a test system you can use, you might consider experimentally building both PHP and MySQL from source and explicitly set them to use the same versions of any shared libraries? Might be a bit of overkill... - michael dykman On Tue, 2005-02-01 at 15:51, Matt Babineau wrote: > Weird thing is that I am running PHP 4.3.9....I guess I can upgrade and see > what happens? > > > Matt Babineau > Criticalcode > w: http://www.criticalcode.com > p: 858.733.0160 > e: [EMAIL PROTECTED] > > -----Original Message----- > From: Michael Dykman [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 01, 2005 12:47 PM > To: Matt Babineau > Cc: 'MySQL General' > Subject: Re: Problem with SELECT SQL_CALC_FOUND_ROWS > > Matt, > > I suspect your problem is PHP, not MySQL. refer to > > http://bugs.php.net/bug.php?id=16906&edit=1 > > On Tue, 2005-02-01 at 15:20, Matt Babineau wrote: > > Hi All- > > > > I'm running a query that uses SQL_CALC_FOUND_ROWS for my search engine > > on a real estate site. The problem is that I get an error when I run my > query: > > > > "Warning mysql_query(): Unable to save result set in /clients/search.php" > > > > My Query is: > > > > SELECT SQL_CALC_FOUND_ROWS propertyData.*, > > propertyDataBulk.propertyDesc FROM propertyData LEFT JOIN > > propertyDataBulk ON propertyData.id = propertyDataBulk.propertyID > > WHERE state = 'CA' limit 0, 5 > > > > Very odd that this happens, I am running MySQL 4.1.9 > > > > Thanks, > > > > Matt Babineau > > Criticalcode > > w: http://www.criticalcode.com > > p: 858.733.0160 > > e: [EMAIL PROTECTED] > -- > - michael dykman > - [EMAIL PROTECTED] -- - michael dykman - [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]