#46997 [Com]: Column Name Based Result Fetching Causes Access Violation

ID: 46997 Comment by: pslide at gmail dot com Reported By: dangerousdave86 at hotmail dot com Status: Feedback Bug Type: MySQLi related Operating System: win32 only - W Server 2008 Std PHP Version: 5.2.8 New Comment: For me, the latest Windows VC6 thread safe snapshot, dated 2009-Feb-05 12:00:00, did not work. My machine: Windows XP Pro SP3 IIS 5.1, with PHP ISAPI module (If this is not helpful, please accept my apologies and delete.) Previous Comments: ------------------------------------------------------------------------ [2009-02-05 14:14:49] jani@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ------------------------------------------------------------------------ [2009-02-04 21:09:59] dangerousdave86 at hotmail dot com Replication Code: <?php # Connect to DB $db = mysqli_connect('localhost','root','',''); $res = mysqli_query($db, 'CREATE TEMPORARY TABLE tst1 (c1 VARCHAR(8), c2 VARCHAR(8))'); $res = mysqli_query($db, 'INSERT INTO tst1 (c1, c2) VALUES ("aa","bb"), ("cc","dd")'); $res = mysqli_query($db, 'SELECT * FROM tst1'); $data = mysqli_fetch_assoc($res); var_dump($data); ?> Never reaches VAR_DUMP(); Errors on MYSQLI_FETCH_ASSOC(); PHP has encountered an Access Violation at 004B2BEB ------------------------------------------------------------------------ [2009-01-03 13:58:33] dangerousdave86 at hotmail dot com Description: ------------ Error: PHP has encountered an Access Violation at 00322BEB When calling mysqli_fetch_assoc or mysqli_fetch_object on mysqli result. Also occurs using OO method. Error does not occur when using mysqli_fetch_row. Result is correct and indexed numerically in array. Reproduce code: --------------- Any database query using mysql that fetches rows using mysql_fetch_object, _fetch_assoc, _fetch_array. Or OO equivilents. Expected result: ---------------- an array representing a row from the database Actual result: -------------- Access Violation ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=46997&edit=1