#46997 [Opn->Fbk]: Column Name Based Result Fetching Causes Access Violation
ID: 46997
Updated by: jani@php.net
Reported By: dangerousdave86 at hotmail dot com
-Status: Open
+Status: Feedback
Bug Type: MySQLi related
-Operating System: Windows Server 2008 Std ISAPI
+Operating System: win32 only - W Server 2008 Std
PHP Version: 5.2.8
New Comment:
Please try using this CVS snapshot:
http://snaps.php.net/php5.2-latest.tar.gz
For Windows:
http://windows.php.net/snapshots/
Previous Comments:
------------------------------------------------------------------------
[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
Thread (8 messages)