ID: 50727
Updated by: johan...@php.net
Reported By: lodeclaassen at gmail dot com
-Status: Open
+Status: Assigned
Bug Type: Reproducible crash
Operating System: Debian Linux
PHP Version: 5.2.12
-Assigned To:
+Assigned To: mysql
New Comment:
Fixed in 5.3. Can reproduce in 5.2.
A simple fix for this might be
Index: ext/mysqli/mysqli_prop.c
===================================================================
--- ext/mysqli/mysqli_prop.c (revision 293046)
+++ ext/mysqli/mysqli_prop.c (working copy)
@@ -162,7 +162,7 @@
mysql = (MY_MYSQL *)((MYSQLI_RESOURCE *)(obj->ptr))->ptr;
- if (!mysql) {
+ if (!mysql || !mysql->mysql) {
ZVAL_NULL(*retval);
} else {
CHECK_STATUS(MYSQLI_STATUS_VALID);
Untested and other properties might be affected - might be better to
backport the fix from 5.3.
Previous Comments:
------------------------------------------------------------------------
[2010-01-12 00:11:21] lodeclaassen at gmail dot com
Description:
------------
I open a mysqli connection that failes (in the tested case wrong
password). After that when I try to get the affected rows
(mysqli->affected_rows) PHP exits and I only get a blank screen.
The configure command from phpinfo:
'./configure' '--with-apxs2' '--with-curl=/usr/local/lib' '--with-gd'
'--enable-gd-native-ttf' '--with-ttf' '--with-gettext'
'--with-jpeg-dir=/usr/local/lib' '--with-freetype-dir=/usr/local/lib'
'--with-kerberos' '--with-openssl' '--with-mcrypt' '--with-mhash'
'--with-mysql=/usr/local/mysql'
'--with-mysqli=/usr/local/mysql/bin/mysql_config'
'--with-pdo-mysql=/usr/local/mysql' '--with-pear'
'--with-png-dir=/usr/local/lib' '--with-zlib'
'--with-zlib-dir=/usr/local/lib' '--enable-zip'
'--with-iconv=/usr/local' '--enable-bcmath' '--enable-calendar'
'--enable-ftp' '--enable-magic-quotes' '--enable-sockets'
'--enable-mbstring'
Other settings I don't know, I don't operate the host.
Reproduce code:
---------------
<?php
echo 'startup<br />';
if (isset($_GET['try']) && $_GET['try'] == 1) {
$connection = new mysqli('localhost', 'user', 'wrong password',
'SomeExistingTable');
$connection->query("SELECT `id` FROM `SomeExistingTable` LIMIT 1");
echo 'affected rows: '.$connection->affected_rows.'<br />';
}
echo 'ending<br />';
?>
Expected result:
----------------
If I request the file with ?try=0 I expect:
startup
ending
When I request ?try=1 I get nothing, a blank screen.
Actual result:
--------------
With ?try=1 I expect to see:
startup
affected rows:
ending
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=50727&edit=1
