#34515 [Com]: mysqli_fetch_assoc crashes application

 ID:               34515
 Comment by:       roxanne at archinoetics dot com
 Reported By:      jaba at inbox dot lv
 Status:           No Feedback
 Bug Type:         MySQLi related
 Operating System: Debian GNU/Linux
 PHP Version:      5.0.5
 New Comment:

I found this post, and it worked for me:

http://marc.info/?l=php-internals&m=123825270214607&w=2


Reprinted below:
Put the PHP directory first in your path, doing so will make the mysql
extensions use the php's libmysql.


Previous Comments:
------------------------------------------------------------------------

[2009-04-05 06:11:22] tbee at tbee dot org

Yes. I have the same problem. Clean WindowsXP install with only the
installer of MySQL, Apache and PHP:

Faulting application httpd.exe, version 2.2.11.0, faulting module
php_mysqli.dll, version 5.2.9.9, fault address 0x00002b6b.

All result class methods work fine except the "fetch_*"; I get a result
object, the num_rows and field_count return correct values, I can
traverse the metadata and display the fieldnames, but whenever I try to
access the actual value Apache crashes.

This is the crashing (test) code:

	echo $pResult->field_count;
	for ($i = 0; $i < $pResult->field_count; $i++)
	{
		echo $pResult->fetch_field_direct($i)->name;
	}		
	return $pResult->fetch_assoc();

If the last line is dummified all the fieldname being displayed and
there is no crash. Naturally I tried several other method calls to get
to the data.

------------------------------------------------------------------------

[2009-03-28 14:42:17] Arvids dot Godjuks at gmail dot com

I use one provided by PHP zip package. I just grabed it from php.net,
unziped and that's all.

------------------------------------------------------------------------

[2009-03-28 14:24:11] Arvids dot Godjuks at gmail dot com

Here is a trace with StraceNT:
http://paste.php.lv/685ed5f46f22a328fee5ca8fd917d70a?lang=text

------------------------------------------------------------------------

[2009-03-28 14:22:39] [email protected]

Do not use mysql 5.1 libmysql DLL with PHP. See the numerous other
reports and explainations for more details.

------------------------------------------------------------------------

[2009-03-28 14:06:00] Arvids dot Godjuks at gmail dot com

I'm having same issue with my aplication on my Windows home box.

I have Windows XP with SP3.

Apache 2.2.11:
Server version: Apache/2.2.11 (Win32)
Server built:   Dec 10 2008 00:10:06

PHP 5.2.9-1 (built: Mar  5 2009 20:02:28)

And latest MySQL GA -  5.1.33

I have latest PECL pack avaliable for windows.

I'm not really familiar with debugging on windows, so you will have to
tell me what to do to get debug info.

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/34515

-- 
Edit this bug report at http://bugs.php.net/?id=34515&edit=1